Access over 20 million homework & study documents
search

3 A vehicle is considered to be heavy if its 5000 or more pounds,

Content type

User Generated

Rating

Showing Page:
1/3
3. A vehicle is considered to be heavy if it\'s 5000 or more
pounds, and light if it\'s below 2000 pounds, and Medium
otherwise. The following table shows four vehicles:
Vehicle
make
model
type
weight
Ford
F-350
Heavy
7000
Mazda
Miata
Light
1800
Toyota
Camry
Medium
3000
Lincoln
Town Car
Heavy
5100
There\'s a relationship between the type column and the
weight column. The values in type are descriptions of
Heavy, Medium, and Light. The values in weight also
correspond to Heavy, Medium, and Light. These two
columns are related to each other, and they shouldn\'t be.
The table complies with all the normal forms through 5NF,
so there isn\'t a key problem. The problem stems from an
interrelationship between the the domains of type and
weight.
(a) What normal form does this table not comply with?

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/3
(b) Write the schemas ( TableName ( attribute1, attribute2,
) ) for a pair of decomposed tables that correct the
problem.
make
model
type
weight
Ford
F-350
Heavy
7000
Mazda
Miata
Light
1800
Toyota
Camry
Medium
3000
Lincoln
Town Car
Heavy
5100
Solution
a)
The table is in 1NF. Since every attribute is independent.
But it won\'t support 2NF, since it has partial dependency

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/3

Sign up to view the full document!

lock_open Sign Up

Unformatted Attachment Preview

3. A vehicle is considered to be heavy if it \'s 5000 or more pounds, and light if it\'s below 2000 pounds, and Medium otherwise. The following table shows four vehicles: Vehicle make model type weight Ford F-350 Heavy 7000 Mazda Miata Light 1800 Toyota Camry Medium 3000 Lincoln Town Car Heavy 5100 There\'s a relationship between the “type” column and the “weight” column. The values in “type” are descriptions of Heavy, Medium, and Light. The values in “weight” also correspond to Heavy, Medium, and Light. These two columns are related to each other, and they shouldn \'t be. The table complies with all the normal forms through 5NF, so there isn\'t a key problem. The problem stems from an interrelationship between the the domains of “type” and “weight”. (a) What normal form does this table not comply with? (b) Write the schemas ( TableName ( attribute1, attribute2, ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4