It's By Design
DOUBLE JEOPARDY
These are 3 of the 7 steps in the designing databases guideline.
It is one of the three reasons to have the primary key.
1) What is to uniquely identify each record in a table?
2)What is a primary key prevents duplicate values?
3)What is Access responds faster to requests for specific records based on the primary key?
This is the main type (cardinality) of a relation between tables in a relational Access database.
What is one-to-many?
Like the design of a racing car, this is the main reason database designing is crucial.
What is for high performance?
These are two of the three rules for primary keys.
What are - can not be null; no duplicate values; never changes?
This is what you call the comma in a CSV (or text) file.
What is a delimiter?
This is the name of the logical model used when designing databases.
What is an Entity Relationship Diagram (ERD)?
These are the two types of primary keys.
What are natural and surrogate keys?
DOUBLE JEOPARDY
This is what prevents orphaned records.
The process you use to optimize relationships in your database and avoid data redundancy.
What is normalization?
It is what you call it when you put the PK in the related table to establish a relationship.
What is the foreign key?
These are two of the three advantages of referential integrity.
What are:
-prevents entry of duplicate data;
-prevents one table from pointing to a nonexistent field in another table;or
-Guaranteed consistency between "partnered" or related tables?