Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q18) Normalise the following form to the third normal form (3NF), clearly showing the stages of 0NF, 1NF, 2NF and 3NF. Clearly state any assumptions
Q18) Normalise the following form to the third normal form (3NF), clearly showing the stages of 0NF, 1NF, 2NF and 3NF. Clearly state any assumptions you make about the data shown (e.g. derived fields), and name your final set of relations. Use underlining to depict primary keys, and dotted underlining to depict foreign keys. Use both types of underlining on a single attribute if necessary.
DOOM CO. LTD 1 in Supervillain Supply! Tax Invoice Tax Invoice Invoice Details: Supervillain Details Villain ID: 134 Invoice #: | 21574 Code Name: "Dr. Dastardly" Order Date: 25-05-11 Item Details Item Description Code A-143 NOBOND-Z3000 Island Defence Systenm C-211 Shiny black henchman outfit A-232 Sharks with lasers on their heads E-093 Freeze-ray MKII E-091 Basic laser pistol D-126 Taking Over The World for Dummies Qty Price Sub Total 1 $65000 $65000 $10 $50000 850 $17000 $6000 $12000 5000$130 $650000 $30 Grand Total: $794030 5000 20 $30 Delivery Details Location ID: 364 Location Code Name: "Normal Island (not a secret base)" Location Coordinates:-46 25.995, 51 45.484Step 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