Question
Normalize the following data into its 3NF and then, if necessary, into a second form called BCNF (Boyce-Codd Normal Form). If both are needed, you
Normalize the following data into its 3NF and then, if necessary, into a second form called BCNF (Boyce-Codd Normal Form). If both are needed, you will have two sets of tables. If there is no need for both, state why there is no need for both. Be specific on your reasoning. For example, if you think that there is no need for BCNF, then say why the BCNF will not change anything. This assignment is to be submitted as one and you can use a Word table attachment or an Excel spreadsheet attachment for those who already know Excel (this course has not hit Excel as yet.)
Record # | Order Number | Product Number | Quantity | Price per Unit |
1 | 1000 | 201000 | 1 | 300.00 |
2 | 1001 | 202000 | 1 | 130.00 |
3 | 1002 | 101100 | 4 | 50.00 |
4 | 1003 | 101200 | 2 | 50.00 |
5 | 1004 | 100200 | 1 | 300.00 |
6 | 1005 | 101100 | 2 | 50.00 |
7 | 1006 | 101200 | 1 | 50.00 |
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