Higher DDD - Compound keys, relationships & data dictionaries

• I can explain why a compound key may be required in a database entity which does not contain a naturally occurring primary key.

• I can populate all/part of a data dictionary to indicate entity names along with the name, type, size, key and validation of their associated attributes. 

Achievements

• We are learning how multiple attributes can be combined to form a compound key

• We are learning how to develop a data dictionary at higher level.

Aims

Match

Match the following terms

• Entity

• Attribute

• Compound key

• Relationship

• Cardinality

Database table

Database Field

Primary key consisting of 2(+) fields

A link between two entities

One-One, One-Many, Many-Many

• Database table

• Database Field

• Primary key consisting of 2(+) fields

• A link between two entities

• One-One, One-Many, Many-Many

Multiple Choice

What cardinality is the relationship between Pupils in a school to Extracurricular Clubs?

• One - One

• One - Many

• Many - One

• Many - Many

Multiple Choice

What cardinality is the relationship between Head teacher to School?

• One - One

• One - Many

• Many - One

• Many - Many

Multiple Choice

What cardinality is the relationship between Pupil to Year group?

• One - One

• One - Many

• Many - One

• Many - Many

Multiple Choice

What cardinality is the relationship between Teacher to Class?

• One - One

• One - Many

• Many - One

• Many - Many

Match

Match the following data types with the sample data

• 07766591297

• 560.56

• True

• 13/09/1989

Object

Text

Number

Boolean

Date

• Object

• Text

• Number

• Boolean

• Date

Multiple Choice

Which type of validation would be best to set on a number field which displays a rating between 1 and 10?

• Presence check

• Length check

• Range check

• Restricted choice

Multiple Choice

Which type of validation would be best to set on a text field which displays a month of the year?

• Presence check

• Length check

• Range check

• Restricted choice

Multiple Choice

Which type of validation would be best to set on the primary key in a database?

• Presence check

• Length check

• Range check

• Restricted choice

Multiple Choice

Which type of validation would be best to set on a text field which contains a membership number?

FK778-008

LI450-109

IN677-908

• Presence check

• Length check

• Range check

• Restricted choice