Database Recap

The Relational Model of Data comprises of...

• Structure

• Manipulation

• System Choice

• Integrity

A Logical Database Design shows:

• Tables

• Relationships

• Database Management System

• Attributes

An Entity Relationship Model shows the attributes

• True

• False

Every set contains the empty set

• True

• False

 $\left\{1,\ 5,\ 99\right\}\ \subseteq\left\{4,\ 5,\ 2,\ 111,\ 78,\ 99,\ 43,\ 1\right\}$  

• True

• False

If
 $M\ =\ \left\{2,\ 4,\ 6\right\}$  and  $N\ =\ \left\{4,\ 7,\ 1,\ 9\right\}$  
How many elements does the Cartesian Product have?

• 3

• 12

• 4

• 7

Which of the following is a derived attribute?

• Student First Name

• Date of Birth

• Age

• Student Number

In Relational Databases we allow Many-to-Many relationships.

• True

• False

{'Canterbury', 'Ashford', 'Folkestone', 'Dover'}

What data type could these be stored under?

• Char

• VarChar

• Integer

• Boolean

Using null is the same as using zero.

• True

• False