Question: B . CUSTOMER _ COUPON ( CustomerID , CustomerFirstName, CustomerLastName, CustomerPhone, CouponID, CustomerCouponDateUsed, CouponDescription, CouponDiscountPercent, ItemID, ItemName, ItemPrice ) Business Rules: A customer can obtain

B. CUSTOMER_COUPON (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.
Step1: Identify all candidate keys
Step2: Identify all the functional dependencies
Step3: Is there a determinant that is not a candidate key?
Final Normalized relations in BCNF with referential integrity rules
B . CUSTOMER _ COUPON ( CustomerID ,

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 Programming Questions!