Chapter 4 - Database System Quiz

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

• To optimize network performance

• To manage database security

• To translate conceptual design into a logical database design

• To create user interfaces

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

• Data encryption

• Data visualization

• Data mining

• Data structure

What does ERD stand for?

• Entity Relational Data

• Entity Relationship Diagram

• Entity Reference Design

• Entity Resource Diagram

What is a primary key?

• A unique identifier for a table

• A key that allows multiple values

• A key that can be null

• A foreign key from another table

What is the result of mapping a composite attribute?

• It becomes a separate relation

• It is ignored in the schema

• It is combined with other attributes

• Only simple attributes are used

Which of the following is NOT a type of relationship in ER diagrams?

• One-to-zero

• Many-to-many

• One-to-many

• One-to-one

What is the purpose of referential integrity constraints?

• To restrict data access

• To allow null values in primary keys

• To maintain consistency among rows of two entities

• To ensure data is encrypted

What happens in a one-to-many relationship?

• Both sides have unique keys

• The primary key on the one side becomes a foreign key on the many side

• A new relation is created

• There are no foreign keys involved

What is a weak entity?

• An entity with multiple attributes

• An entity that can exist independently

• An entity that depends on another entity

• An entity that has no primary key

Which of the following is a domain constraint?

• Matching of primary and foreign keys

• Allowable values for an attribute

• Business rules for operations

• No primary key attribute may be null