Database Normalization and E-R Diagrams Quiz

What is the main purpose of normalization in database models?

• To ensure data dependencies make sense

• To eliminate all data

• To increase data redundancy

• To make data harder to find

Which of the following is NOT a type of anomaly in databases?

• Modification anomaly

• Insert anomaly

• Update anomaly

• Delete anomaly

What does 1NF stand for in normalization?

• First Normal Form

• First Normal Function

• First Non-Functional

• First Notation Form

Which normal form eliminates partial dependencies?

• Third Normal Form

• Second Normal Form

• Boyce-Codd Normal Form

• First Normal Form

What is a functional dependency?

• A relationship between two attributes

• A type of database error

• A method of data storage

• A way to increase redundancy

Which of the following is a characteristic of a weak entity?

• It has its own unique identifier

• It can exist independently

• It depends on a strong entity

• It is represented with a single-line rectangle

In an E-R diagram, what does a diamond shape represent?

• A weak entity

• An entity

• An attribute

• A relationship

Which of the following is a multivalued attribute?

• Major

• Phone Numbers

• Student Name

• Student ID

What is the purpose of an E-R diagram?

• To eliminate data

• To increase redundancy

• To represent entities and relationships

• To store data

Which of the following is a characteristic of a composite attribute?

• It cannot be broken into smaller parts

• It can be broken into smaller parts

• It has only one value

• It is always derived