Question 1

Explain the following cardinalities between A,B and C,D

(4 marks)

Define the following keys and give an example of each from the following table (name, email, phone, carModel). You can add new columns to the table as needed.

Candidate key

Primary Key

Composite key

Foreign key

Surrogate Key

(1 Mark per definition)

(1 Mark per example)

(10 Marks Total)

Explain what a functional dependency between two entities means, what is the difference between a partial and transitive dependency?

(6 marks)

Total: 20 Marks

Question 2

Write the SQL statements you would need to

Make a new database Bookstore

Add a table called Fiction with fields title, author and genre and an Auto-incrementing Primary ID called id

Add the following values to Lecturers

Title: IT, Author: Stephen king, Genre: Horror

Title: The reaper man, Author: Terry Pratchett, Genre: Terry Pratchett

See all tables

Delete the table Fiction

Total: 20 Marks

C