Relational Databases Quizzes Solved 100% Correct
What are the stages of Database Normalization? - ANSWER first, second, and third
normal form
Most Relational Database Designers will accept that in order to deal with the
complexities of "real life" data modeling, a design needs to reach - ANSWER
third normal form
A relation is in 1NF if it doesn't contain any ____________? - ANSWER duplicate rows,
repeating fields in a table values are atomic
Second Normal Form is designed to - ANSWER ensure that every non-key field in a
record is fully functionally dependent upon the key for that record
An atomic field is - ANSWER a singled valued field
, What is a transitive dependency? - ANSWER is when field A depends on field B and
field B is not a key field
What does 3NF ensure? - ANSWER ensure that there is no dependencies between
non-key fields
Consider the following table which of the following affirmations applies the best:ID(Key
Field) | FIRSTNAME | LASTNAME | BIRTHDATE | GENDER | CITYOFBIRTH | STATE
- ANSWER the table is in second normal form
What is the name of a field in a table that relates to the identifier in another table? -
ANSWER foreign key
A foreign key must - ANSWER have either a matching value in the referring
(primary) table
Is it possible for a table to have more than one foreign key? - ANSWER yes a table
can have more than one foreign key
What do the lines between tables (or entities) on a database diagram mean? -
ANSWER relationships between two tables
What are the stages of Database Normalization? - ANSWER first, second, and third
normal form
Most Relational Database Designers will accept that in order to deal with the
complexities of "real life" data modeling, a design needs to reach - ANSWER
third normal form
A relation is in 1NF if it doesn't contain any ____________? - ANSWER duplicate rows,
repeating fields in a table values are atomic
Second Normal Form is designed to - ANSWER ensure that every non-key field in a
record is fully functionally dependent upon the key for that record
An atomic field is - ANSWER a singled valued field
, What is a transitive dependency? - ANSWER is when field A depends on field B and
field B is not a key field
What does 3NF ensure? - ANSWER ensure that there is no dependencies between
non-key fields
Consider the following table which of the following affirmations applies the best:ID(Key
Field) | FIRSTNAME | LASTNAME | BIRTHDATE | GENDER | CITYOFBIRTH | STATE
- ANSWER the table is in second normal form
What is the name of a field in a table that relates to the identifier in another table? -
ANSWER foreign key
A foreign key must - ANSWER have either a matching value in the referring
(primary) table
Is it possible for a table to have more than one foreign key? - ANSWER yes a table
can have more than one foreign key
What do the lines between tables (or entities) on a database diagram mean? -
ANSWER relationships between two tables