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, Deadline,

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 1NF? If yes WHY?? If not modify ResCust so as to put it in 1NF. Let us call ResCust1 the main relation resulting out of this step
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
