DBC CHAPTER 3 - REVISION

What does the relational data model allow the designer to focus on?

• Logical representation of data

• Physical storage details

What is the primary purpose of keys in the relational model?

• To ensure each row is uniquely identifiable

• To eliminate redundancy

What does the data dictionary contain?

• Metadata

• User access logs

Which relationship type is considered the norm in relational database design?

• M:N relationship

• 1:M relationship

What is a composite entity used for in a relational database?

• To create primary keys

• To link tables in an M:N relationship

What is the role of foreign keys in controlling data redundancy?

• They eliminate redundancy completely

• They minimize data redundancies

What is the main function of an index in a relational database?

• To logically access rows in a table

• To enforce integrity rules

What does the term 'full functional dependence' refer to?

• A relationship among attributes

• A way to create indexes

What is the significance of the system catalog?

• It eliminates the need for foreign keys

• It describes all objects within the database

Which of the following is true about the 1:1 relationship?

• It allows multiple entities to relate

• It should be avoided in most designs

• It is the most common relationship type