Font size
WorksheetsNormalization
Total questions: 15
Worksheet time: 8mins
A relation is in 1NF if it doesn't contain any ____________?
Determinants
Repeating groups
Null values in primary key fields
Functional dependencies
If every non-key attribute is functionally dependent on the primary key, then the relation will be in :
1NF
2NF
3NF
4NF
Which of the following statements is/are true: (Hint: 2 statements are true)
Normal forms can be derived by inspecting the data in various tables
Normal forms speed up all queries
Normal forms reduce the risk of inconsistent update of replicated data
Normal forms eliminate redundant storage of data
Third normal form is based on getting rid of ________
Closure Dependency
Transitive Dependency
Normal Dependency
Functional Dependency
Which are the 3 violations of the 1NF ?
Composite attributes
Multivalued attributes
Nested relations
Prime attributes
A table that has no partial functional dependencies is always in _______ form
3NF
2NF
0NF
BCNF
If all non-primary key attributes in a table depend on the primary key, the whole key and nothing but the key, then the table is in
1NF, but not in 2NF
2NF, but not in 3NF
3NF
Not in 1NF
Which normal form allows for multivalued dependencies to be eliminated?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Fourth Normal Form (4NF)
Which normal form guarantees that there are no non-prime attributes functionally dependent on a proper subset of any candidate key?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
What is a functional dependency in the context of database normalization?
The relationship between two or more tables in a database
The relationship between primary and foreign keys in a table
The relationship between data types in a database schema
The relationship between attributes in a table, where the value of one attribute determines the value of another
What is a composite primary key?
A primary key that can be duplicated in the same table
An attribute that is a primary key in another table
A foreign key that is a primary key in more than one other table
A primary key made up from two or more attributes
A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multi valued facts about an entity, is said to be in ____.
1NF
2NF
3NF
4NF
Problems in Relational Data Model are :
Anomalies
Information Redundancy
None of the above
A process for assigning attributes into a table and reduces data redundancy and helps eliminate the data anomalies that associated with poor database design is called as :
Normalization
Information Redundancy
Anomalies
"Occurs when an attribute is functionally dependent on another non-key attribute."
The above statement is referring to :
Full Functional Dependency
Partial Functional Dependency
Transitive Dependencies
