Year 14 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

• To implement the database software

• To create user interfaces

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

• Normalisation occurs

What does a physical data model define?

• The logical relationships between entities

• The business needs

• The physical structure of the database

• The user interface design

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

• A) It includes user interface design.

• B) It creates the table structures.

• C) It defines business processes.

• D) It manages network protocols.

What does a physical data model include regarding column names?

• A) User access levels

• B) Network configurations

• C) The data type of each field

• D) Security protocols

What is one of the considerations that may cause a physical data model to differ from a logical data model?

• A) User preferences

• B) Physical considerations

• C) Software updates

• D) Marketing strategies

Which level of data modeling is primarily concerned with business concepts and communication of business terms and rules?

• Logical

• Physical

• Conceptual

• Technical

In the comparison of logical and physical data models, which feature is identified in the logical model but created in the physical model?

• Entity Names

• Primary Keys

• Table Names

• Field Data Types

Which feature is only present in the physical data model and not in the logical data model?

• Entity Relationships

• Attributes

• Field Data Types

• Foreign Keys