Given the following relational schema and its functional dependencies:

(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) 

You might also like to view...
What is the output from the following?
``` >> a = ord("A") >>> b = 2 >>> x = a * b >>> print x ```
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
After a VM is created, you cannot change its generation
Indicate whether the statement is true or false
How are nested loops implemented in a loop structure?
What will be an ideal response?