T Level OccSpec 4.3 Databases

What are the two main stages in the development of a database?

• Logical and Physical

• Conceptual and Structural

• Design and Implementation

• Planning and Execution

What does logical database design focus on?

• Defining the structures of tables

• Defining entities and their relationships

• Implementing the actual database

• Specifying field properties

What is the outcome of physical database design?

• A conceptual view of the database

• The actual implementation of the database

• The organization of data

• The definition of entities

Which of the following is NOT a feature of Entity Relationship Modelling?

• Producing a data model

• Visual representation of data

• Data encryption

• Investigation of data

Which of the following best describes Entity Relationship Modelling?

• A programming language

• A data modeling process

• A network protocol

• A hardware design method

Which of the following can be both a physical object and a concept entity?

• A book

• A customer

• A plane

• None of the above

What is the format for listing attributes in an entity description?

• EntityName {PrimaryKey, attribute01, attribute02, attribute03, …}

• EntityName (PrimaryKey, attribute01, attribute02, attribute03, …)

• EntityName [PrimaryKey, attribute01, attribute02, attribute03, …]

• EntityName

Which of the following is an example of an entity description?

• Customer {CustomerID, Surname, Forename, DateOfBirth, …}

• Customer (CustomerID, Surname, Forename, DateOfBirth, …)

• Customer [CustomerID, Surname, Forename, DateOfBirth, …]

• Customer

Which of the following is NOT a correct way to show a foreign key?

• Using an overbar

• Using an asterisk

• Using italics

• Using bold text

What is a primary key in the context of an entity description?

• A unique identifier for each record

• A common attribute shared by all entities

• A secondary attribute for sorting

• A visual representation of data