Question 1

What is a primary key in a relational database?

Options :

A : A constraint that ensures data integrity

B : A unique identifier for each record in a table

C : A field that can have multiple values

D : A foreign key that points to another table

Answer: B

Question 2

What is a relationship in data modeling?

Options :

A : An attribute of a table

B : A table in the database

C : A connection between entities

D : A field in a table

Answer: C

Question 3

What is the role of normalization during the mapping of the physical model?

Options :

A : To determine the primary key of each table

B : To improve query performance

C : To eliminate redundancy in the database

D : To ensure data integrity and consistency

Answer: C

Question 4

When mapping the physical model, why is it important to consider data types?

Options :

A : Data types determine the available storage space for each attribute

B : Data types affect the efficiency of data retrieval operations

C : Data types determine the order of execution for database operations

D : Data types determine the relationships between tables

Answer: A

Question 5

Which of the following is a valid cardinality notation for a one-to-many relationship in a physical data model?

Options :

A : (1, N)

B : (0, 1)

C : (1, 1)

D : (N, M)

Answer: A