Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Produce a set of relations in third normal form (3NF) from the following un-normalised relation, showing all the intermediate steps. Marks will be allocated for

Produce a set of relations in third normal form (3NF) from the following un-normalised relation, showing all the intermediate steps. Marks will be allocated for satisfactory execution of each intermediate step, in accordance with their complexity.

PRODUCT (product manufacturing code, product title, product manager name, product manager office, product manager contact number, productmanufacturing budget, product batch code ((operator number, operator name, operator station, operator contact number, department number, departmentname, number of hours, hourly rate)), total staff on productmanufacturing roster, average hourly rate, total number of hours, ((vendorname, procurement number, customer name, order number, notes)) ) Notes: 1. Product manufacturing code is a unique identifier for a product. 2. One dedicated product manager and several operators work as a team in aproduct manufacturing roster. 3. A manufacturing roster is defined as an 8-hour working shift. 4. Product managers can choose between different operators to be in amanufacturing roster team whenever a production shift is scheduled. 5. Product managers are not able to choose or switch between products ormanufacturing lines while a product batch is actively in production. 6. One product batch refers to a single customer order. Multiple productbatches refer to multiple customer orders. 7. Product managers are also operators. So we dont need a separate relation tostore product managers. 8. Each operator belongs to only one department during active batchproduction. 9. Operators may change departments depending on their assignments inbetween batch production schedules. 10. The number of hours is determined by both the operator and the productbatch. 11. Hourly rate is fixed and dependent on the department where the operatorbelongs.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2019 Wurzburg Germany September 16 20 2019 Proceedings Part 2 Lnai 11907

Authors: Ulf Brefeld ,Elisa Fromont ,Andreas Hotho ,Arno Knobbe ,Marloes Maathuis ,Celine Robardet

1st Edition

3030461467, 978-3030461461

More Books

Students also viewed these Databases questions