DATABASE TO DESIGN

In a database, sorting in what order would put things from A - Z?

If you sort from 100-1 you are sorting in what order?

Match the term to its description

• Tasks users must be able to perform

• User Requirement

• A feature needed to meet user needs

• Attribute

• A table in a database

• Functional Requirement

• A characteristic of an entity

• Entity

What is the purpose of a validation rule in a database?

• To make the database user friendly

• To ensure data entered is accurate and fits predefined criteria

• To create relationships between entities

• To sort data in ascending or descending order

Label all aspects of the ERD

a

b

c

d

e

f

PK; booking

FK

PK; activity

Attribute

Entity

One to Many Relationship

What should be included in a data dictionary?

• The names of the database users

• Details of entities, attributes, data types and validation rules

• A list of records in the database

• The specific software used to create the database

What shape is used to represent an entity in an ERD

• Diamond

• Rectangle

• Oval

• Triangle

What is a record in a database?

• A single piece of data

• A collection of related fields for one entity

• A column in a database table

• The set of validation rules applied to a database

Which of the following is NOT an example of GDPR compliance?

• Encrypting sensitive data

• Allowing users to request the deletion of their personal data

• Sharing user data without their consent for marketing purposes

• Informing users about how their data will be used