Question: Knowing that a customer can make more than one reservation and one reservation is made by only one customer, analyze the given schema: ResCust= (Res.No,

 Knowing that a customer can make more than one reservation and

Knowing that a customer can make more than one reservation and one reservation is made by only one customer, analyze the given schema: ResCust= (Res.No, Deadline, C.id, C.name, Caddress(Street, City)) (i) {20 points} Draw all functional dependencies (fds) (ii) {5 points} Create a meaningful snapshot by populating the table ResCust with, at least, 5 rows (iii) {5+10+ 5 points} Discuss insertion, deletion and modification anomalies (iv) {10 points} Is ResCust in INF? If yes WHY?? If not modify ResCust so as to put it in INF. Let us call ResCust1 the main relation resulting out of this step (v) {5 points} Draw the fds of ResCust1 (vi) {10 points} Is ResCust1 in 2NF? If yes WHY?? If not modify ResCust1 so as to put it in 2NF. Let us call ResCust2a and ResCust2b the two new relations, i.e. the two relations resulting out of this step (vii) {20 points} Is ResCust1 in 3NF? If yes WHY?? If not, modify ResCust1 so as to put it in 3NF. Let us call ResCust3a and ResCust3b the two new relations, i.e. the two relations resulting out of this step (viii) {10 points} Draw the fds of ResCust3a and ResCust3b

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!