WorksheetsNormalization Quiz
Total questions: 7
Worksheet time: 4mins
Problems in Relational Data Model are :
Anomalies
Information Redundancy
None of the above
3 types of anomalies are :
insert
delete
modification
None of the above
Anomalies is Errors or inconsistence that may result when a user attempts to update a table that contains redundant data.
True
False
Information Redundancy is Duplication of data due to storing the same data multiple times.
True
False
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
The purposes of normalization are :
To ensure that the anomalies doesn’t occur
To reduce data or storage redundancy
To ensure easy for record searching/finding
All the above
Choose three types of Functional Dependency
Full Functional Dependency
Partial Functional Dependency
Transitive Functional Dependency
None of the above
