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