Lecture 4.1 (i) Relational Model Quiz

What does the acronym ERD stand for?

• Entity Relation Data

• Entity Relation Diagram

• Entity Relationship Diagram

• Entity Record Diagram

Which of the following is NOT a component of an ERD?

• Record

• Attribute

• Entity

• Relationship

In a relational database, what does a table represent?

• A single record

• An entity set

• A field

• A key

What is the primary key (PK) in a relational schema?

• An attribute that can be duplicated

• An attribute that uniquely identifies a row

• An attribute that is always numeric

• An attribute that is optional

Which of the following best describes a field in a relational model?

• A unique identifier for a record

• A column representing a property of an entity

• A relationship between two tables

• A single row in a table

What is the purpose of a foreign key (FK)?

• To uniquely identify a record

• To create a common attribute between tables

• To store data temporarily

• To define the structure of a table

How many main components are there in an ERD?

• Three

• Six

• Four

• Five

What does a record (tuple) represent in a table?

• A single instance of an entity

• A collection of attributes

• A relationship between entities

• A unique identifier

What is the significance of the attribute domain?

• It indicates the data type of a field

• It determines the relationship between tables

• It specifies the valid set of values for an attribute

• It defines the unique identifier for a record

Which of the following is NOT a type of key in a relational model?

• Secondary Key

• Foreign Key

• Tertiary Key

• Primary Key