Given the following relational schema and its functional dependencies:

![15244|477x136](upload://pw4RYGKVj7mCrgn6B9znY3Pqzoh.png)

(a) Specify candidate keys and state the primary key.
(b) Assuming that the relation is in first normal form (1NF), describe and illustrate the process of normalising the relational schema to second (2NF) and third (3NF) normal forms. Identify the primary and foreign keys in your third normal forms.


(a) Candidate keys: (custNo, propertyNo), (custNo, rentStart)
Primary key: any of the above set of attributes; e.g. (custNo, propertyNo)
(b) ![15245|543x220](upload://rmNIJOSVSFMkVAwajgRcOUrxUrm.png)
![15246|491x253](upload://lEz7KNAAED5uupyLTirWPvoHubv.png)

Computer Science & Information Technology

You might also like to view...

What is the output from the following?

``` >> a = ord("A") >>> b = 2 >>> x = a * b >>> print x ```

Computer Science & Information Technology

A(n) _______ card allows video signals normally seen on a TV to be viewed on a computer

Fill in the blank(s) with correct word

Computer Science & Information Technology

After a VM is created, you cannot change its generation

Indicate whether the statement is true or false

Computer Science & Information Technology

How are nested loops implemented in a loop structure?

What will be an ideal response?

Computer Science & Information Technology