WorksheetsNormalization with ERD
Total questions: 20
Worksheet time: 12mins
What is Normalization?
Normalization is the process of organizing the data in the database.
Normalization divides the larger table into smaller and links them using relationships.
The normal form is used to reduce redundancy from the database table.
Normalization is a saving function from the database
Why Normalize a Database?
Make the database more efficient
Reduce the storage space that a database takes up
To update data from the database.
Make the database more efficient
What is the main purpose of normalization in database design?
To reduce redundancy
To increase redundancy
To ensure faster queries
To decrease database size
Which normal form ensures that there are no repeating groups of data?
2NF
3NF
1NF
BCNF
In a normalized database, which normal form ensures that there are no partial dependencies?
1NF
2NF
3NF
BCNF
What does the process of normalization aim to achieve?
Improve query speed
Eliminate anomalies and redundancy
Reduce data size
Create complex relationships
In an ERD, what symbol typically represents an entity?
Circle
Diamond
Rectangle
Oval
What is the purpose of a foreign key in a database?
To uniquely identify records
To enforce relationships between tables
To store duplicate data
To create indexes
Which of the following is a characteristic of 1NF?
Elimination of transitive dependencies
No repeating groups of data
No partial dependencies
Use of composite keys
What type of relationship does a crow's foot represent in an ERD?
One-to-one
One-to-many
Many-to-many
Self-referencing
Which normal form ensures that there are no transitive dependencies?
1NF
2NF
3NF
BCNF
Which of the following describes 3NF?
A table is in 3NF if it is in 1NF
A table is in 3NF if it has no transitive dependencies
A table is in 3NF if it contains repeating groups
A table is in 3NF if it has only one candidate key
What is a many-to-many relationship in an ERD?
When one instance of an entity relates to only one instance of another
When multiple instances of an entity relate to multiple instances of another
When one instance of an entity relates to multiple instances of another
When an entity relates to itself
What type of key is used to enforce relationships between tables in an ERD?
Primary key
Composite key
Foreign key
Candidate key
What does 1NF eliminate?
Transitive dependencies
Partial dependencies
Composite keys
Repeating groups of data
What is the main characteristic of 3NF?
No repeating groups of data
No transitive dependencies
No partial dependencies
No foreign keys
What is a primary key used for?
To uniquely identify each record in a table
To relate tables
To enforce data types
To store foreign key values
Which form is used to eliminate redundancy by ensuring attributes depend only on the primary key?
1NF
2NF
3NF
BCNF
In an ERD, what does the cardinality define?
The uniqueness of an entity
The number of records in an entity
The nature of relationships between entities
The attributes of an entity
What is the purpose of normalization in a relational database?
To increase redundancy
To reduce data anomalies
To create complex relationships
To improve data retrieval performance
