Database System Quiz

What is the primary purpose of logical design in database systems?

• To ensure data integrity through business rules

• To create a physical database structure

• To perform data manipulation using SQL

• To translate conceptual design into a logical database design

Which of the following is NOT a component of a relational database?

• Data visualization

• Data integrity

• Data manipulation

• Data structure

What does a primary key do in relational modeling?

• Identifies a unique record in a table

• Stores multiple values in a single field

• Links two tables together

• Defines the data type of an attribute

What is the result of mapping a many-to-many relationship?

• A foreign key in the one side entity

• A new relation with a primary key from one entity

• An associative entity with primary keys from both entities

• A composite key from the two entities

Which constraint ensures that no primary key attribute may be null?

• Entity integrity constraint

• Domain constraint

• Referential integrity constraint

• Operational constraint

What is the purpose of referential integrity constraints?

• To ensure every table has a unique name

• To maintain consistency among rows of two entities

• To enforce business rules

• To define allowable values for an attribute

What happens to multi-valued attributes when mapping to relations?

• They are ignored

• They become a separate relation with a foreign key

• They are combined into a single attribute

• They are converted into composite attributes

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

• It cannot exist without a related entity

• It has its own primary key

• It can have multiple primary keys

• It is always optional in a relationship

What is the first step in transforming an ER diagram into relations?

• Map associative entities

• Map unary relationships

• Map weak entities

• Map regular entities

Which of the following statements about attributes in tables is true?

• Every attribute can have multiple values

• Every attribute value must be atomic

• Attributes can have the same name in different tables

• The order of attributes is crucial for data retrieval