Database Quiz

What is the main purpose of a logical data model?

• To define the physical structure of the database

• To identify the relationships between data and create a logical design

• To implement the database software

• To manage database transactions

During which stage is a logical data model produced?

• Implementation stage

• Testing stage

• Design stage

• Maintenance stage

Which of the following is NOT a feature of a logical data model?

• Identifies entities

• Specifies foreign keys

• Describes the physical structure of the database

• Normalisation occurs

What does a physical data model define?

• The logical relationships between entities

• The physical structure of the database

• The business needs

• The software requirements

Which of the following is a feature of a physical data model?

• A) It defines user roles and permissions.

• B) It creates the table structures.

• C) It outlines business processes.

• D) It manages network security.

What does a physical data model include regarding columns?

• A) User access levels

• B) Network configurations

• C) Column names/field names/aliases

• D) Software requirements

What is included in the data type specification in a physical data model?

• A) User interface design

• B) Data type of each field

• C) Server hardware specifications

• D) Application software versions

What is a key feature of each table in a physical data model?

• A) User login details

• B) Validation rules

• C) Network protocols

• D) Software licenses

How might physical considerations affect a data model?

• A) They make it identical to the logical data model.

• B) They cause the physical data model to differ from the logical data model.

• C) They ensure the data model is always secure.

• D) They simplify the data model.

Which level of data modeling is primarily concerned with business concepts?

• Logical

• Physical

• Conceptual

• Technical