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...

________ view displays thumbnails of all the slides in the presentation

A) Reading B) Slide Sorter C) Presenter D) Notes Page

View
Computer Science & Information Technology

Given the function, and the main function calling it: Which, if any, of the following choices is the output of the following code? What does this function do?

``` #include using namespace std; void func ( int& x, int & y) { int t = x; x = y; y = t; } int main() { int u = 3; v = 4; // ... cout << u << " " << v << endl; func ( u, v ) cout << u << " " << v << endl; // ... } ``` a) 3 4 3 3 b) 3 4 4 3 c) 3 4 3 4 d) 3 4 4 4 e) none of the above. If you choose this, you must specify the output

View
Computer Science & Information Technology