NEW
Font size
WorksheetsHands-on Modul 3
Total questions: 10
Worksheet time: 10mins
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
