Database Design Fundamentals Quiz

What does a table contain data about?

• A specific entity type

• A specific attribute

• A specific key

• A specific relation

How is a table characterized?

• By rows and columns

• By nodes and edges

• By keys and values

• By attributes and entities

What does a column in a relational model represent?

• A specific attribute of the table's entity type

• A unique identifier for each row

• A collection of tables

• A primary key

What restricts the set of values allowed in a column?

• Primary key

• Domain

• Foreign key

• Index

How are entries in columns described in a relational model?

• Multi-valued

• Single-valued

• Composite

• Hierarchical

What does each row in a relational model describe?

• A fact about an entity

• A collection of attributes

• A primary key

• A foreign key

What is a relationship in the context of databases?

• An association between common columns in two tables

• A link between unrelated tables

• A connection between different databases

• A method to store data

How are tables in a relational database linked to each other?

• Through relationships

• By using primary keys only

• By using foreign keys only

• By using indexes

What is the role of cardinality in database relationships?

• To define the number of instances of an entity in relation to another entity

• To determine the size of the database

• To specify the type of data stored

• To enhance data retrieval speed

What is the relationship between the titles table and the publishers table?

• One-to-one relationship

• Many-to-many relationship

• One-to-many relationship

• No relationship