Relational Model Quiz

What is the fundamental data representation in the relational model?

• Files

• Objects

• Tables

• Graphs

What do rows in a relational table represent?

• Keys

• Relations

• Records

• Attributes

Which of the following is NOT a property of relations?

• Rows must be unique

• Every attribute value must be atomic

• Must have a unique name

• Columns must be ordered

What is the purpose of a primary key in a relational database?

• To link tables

• To uniquely identify rows

• To define relationships

• To store data

What type of key links dependent tables to parent tables?

• Primary Key

• Foreign Key

• Composite Key

• Unique Key

Which integrity constraint ensures primary key fields cannot be null?

• Data Integrity

• Domain Integrity

• Entity Integrity

• Referential Integrity

What does referential integrity enforce?

• Atomicity of attributes

• Consistency between foreign and primary keys

• Uniqueness of rows

• Order of columns

What is an insertion anomaly?

• Unintentional data deletion

• Forcing duplicate data creation

• Changing data in multiple rows

• Setting foreign keys to null

What is the first step of normalization?

• Remove transitive dependencies

• Ensure every non-key attribute is dependent

• Eliminate multivalued attributes

• Organize data to minimize redundancy

What does 2NF ensure in normalization?

• No multivalued attributes

• Non-key attributes depend on the primary key

• No duplicate records

• Attributes have unique names