Hands-on Modul 3

Database normalization is a systematic approach of decomposing cardinality to eliminate data classification

• TRUE

• FALSE

Which normal form is considered adequate for usual database design?

• 1NF

• 2NF

• 3NF

• 5NF

What must you do to maintain data integrity when you normalize a relation by breaking it into two smaller relations?

• Create a primary key(s) for the new relation

• Denormalize the data

• Assign both relations the same primary key field(s)

• Remove any functional dependencies from both relations

Every Boyee-Codd normal form is in…

• First normal form

• Third normal form

• First normal form, Second normal form

• First normal form, Second normal form, Third normal form

Which one of these are TRUE about the rules of 1NF

• It should only have single (atomic) valued attributes/columns, Columns have no repeating/similar data, each row is unique

• Columns have a few similar data

• It doesn't have Transitive Dependency

• It should only have single (atomic) valued attributes/columns, it doesn't have Transitive Dependency, Columns have no repeating/similar data, each row is unique

The primary key is selected from...

• Determinants Key

• Composite Key

• Candidate Key

• Foreign Key

A foreign key is a column or a set of columns in a table whose values correspond to the values of the primary key in another table

• TRUE

• FALSE

Which is the following statement best to describe PRIMARY KEY?

• A primary key is a column of a table or a set of columns that helps to identify every record present in that table similarly

• A primary key is a set of two or more attributes that help identify each tuple in a table uniquely

• None of the above are right

• A primary key is a column of a table or a set of columns that helps to identify every record present in that table uniquely

A database is in third normal form if it satisfies the following conditions

• All of the answers above are correct.

• The relation is in fourth normal form and There is no transitive functional dependency

• Contains an atomic value

• The relation is in second normal form and There is no transitive functional dependency

A descriptor column contains what type of data?

• A candidate key

• A link to another table

• A description of the table as a whole

• A non-key attribute of an entity