Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 2. Normalisation (10 marks) Consider the two relations below. They are in BCNF with primary key attributes underlined Customer(custlD, firstname, lastname) Item(itemNo, desc, price)
Question 2. Normalisation (10 marks) Consider the two relations below. They are in BCNF with primary key attributes underlined Customer(custlD, firstname, lastname) Item(itemNo, desc, price) A Transaction relation as below is proposed to keep data for orders. Each order is by one customer and it can contain multiple items with their quantities. Transaction(custlD, itemNo, orderlD, quantity, discount, amount_due) Given the FDs below orderlD custlD, amount_due, discount orderlD, itemNo quantity custlD, orderlD amount_due, discount Answer questions. 2.1 (4 marks) Give the minimal basis for the given FDs. 2.2) 2 marks) The Transaction relation is not in BCNF or 3NF. Give the reason. 2.3) (4 marks) Follow the BCNF/3NF decomposition algorithm to decompose Transaction into relations in BCNF or 3NF. Give the relations after decomposition and specify the primary key and any foreign keys for each relation
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