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

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

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!