Question
The following table shows a sample business report. Please decompose it into first, second and third normal forms, and specify the primary key for each
The following table shows a sample business report. Please decompose it into first, second and third normal forms, and specify the primary key for each relation.
| Order ID | Order Date | Customer ID | CName | Cadd- ress | Item ID | Item Name | Unit price | Quantity | Sub- total | Order total |
| 103 | 10/5/98 | 1002 | Cooper | 3256 grand Ave. | 1015 | Toaster | 19.95 | 1 | 19.95 |
|
|
|
|
|
|
| 1010 | Blender | 29.95 | 1 | 29.95 | 1459.8 |
|
|
|
|
|
| 1025 | TV | 699.95 | 2 | 1399.9 |
|
| 108 | 10/16/98 | 1000 | Kris | 637 Johnson St. | 1025 | TV | 699.95 | 1 | 699.95 |
799.9 |
|
|
|
|
|
| 1045 | Clock | 99.95 | 1 | 99.95 |
|
| 110 | 10/24/98 | 1003 | Cyber | 455 Kendall Dr. | 1045 | Clock | 99.95 | 3 | 299.95 | 299.95 |
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
Managerial Accounting
Authors: John Wild, Ken Shaw, Barbara Chiappetta
8th Edition
1264111924, 9781264111923
