Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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.484

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

Step: 3

blur-text-image

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

Spatial Databases A Tour

Authors: Shashi Shekhar, Sanjay Chawla

1st Edition

0130174807, 978-0130174802

More Books

Students also viewed these Databases questions

Question

What is the difference between a public and a private corporation?

Answered: 1 week ago

Question

How is the WRR calculated utilizing the two applicable methods?

Answered: 1 week ago

Question

Define organization development (OD)

Answered: 1 week ago