Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started