Question: B . CUSTOMER _ COUPON ( CustomerID , CustomerFirstName, CustomerLastName, CustomerPhone, CouponID, CustomerCouponDateUsed, CouponDescription, CouponDiscountPercent, ItemID, ItemName, ItemPrice ) Business Rules: A customer can obtain
B CUSTOMERCOUPON CustomerID CustomerFirstName, CustomerLastName, CustomerPhone, CouponID, CustomerCouponDateUsed, CouponDescription, CouponDiscountPercent, ItemID, ItemName, ItemPrice
Business Rules: A customer can obtain many coupons. A customer can purchase many items. A coupon is assigned to one customer and for one item. An item can have many coupons.
Step: Identify all candidate keys
Step: Identify all the functional dependencies
Step: Is there a determinant that is not a candidate key?
Final Normalized relations in BCNF with referential integrity rules
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
