Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For each of the following, explain why or why not a relation is in a particular normal form, underline primary keys and indicate which fields

For each of the following, explain why or why not a relation is in a particular normal form, underline primary keys and indicate which fields are foreign keys and which relation they are keys into.

1.PetStore(storeBranchName, storeAddr, storeManager,(customerName, customerAddr, customerPhone,(petName, petBreed, petSex, price) ) )

FDs storeBranchName storeAddr, storeManager customerName customerAddr, customerPhone customerName, petName petBreed, petSex customerName,storeBranchName petName petBreed price

a. Is this relation in 1NF? If not, why isn't it? Then put it in 1NF.

b. Is this relation in 2NF? If not, why isn't it? Then put it in 2NF.

c. Is this relation in 3NF? If not, why isn't it? Then put it in 3NF.

2.R(A,B,C,D,E)

Fds

A A,B,C

C D

A,C E

a. Is this relation in 1NF? Why or why not? If not, put it into 1NF.

2b. Is it now in 2NF? Why or why not? If not, put it into 2NF

2c. Is it now in 3NF? Why or why not? If not, put it into 2NF.

3.price(product,sName,uPrice,qty,storeLocation,unitWeight)

Fds

product, sname qty

sName storeLocation

product uprice, unitWeight

a. Is this relation in 1NF? If not, why isn't it? Then put it in 1NF.

b. Is this relation in 2NF? If not, why isn't it? Then put it in 2NF.

c. Is this relation in 3NF? If not, why isn't it? Then put it in 3NF.

4.person(personId, name, country,(phone, type))

FDs

personId name, country, phone

name country

phone type

a. Is this relation in 1NF? If not, why isn't it? Then put it in 1NF.

b. Is this relation in 2NF? If not, why isn't it? Then put it in 2NF.

c. Is this relation in 3NF? If not, why isn't it? Then put it in 3NF.

5.carTheft(VID,vehicleType,(ownerID,ownerName),

(suspectId,suspectName))

FDs

VID vehicleType, ownerID

ownerId ownerName

suspectID suspectName

a. Is this relation in 1NF? If not, why isn't it? Then put it in 1NF.

b. Is this relation in 2NF? If not, why isn't it? Then put it in 2NF.

c. Is this relation in 3NF? If not, why isn't it? Then put it in 3NF.

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

XML Data Management Native XML And XML Enabled Database Systems

Authors: Akmal Chaudhri, Awais Rashid, Roberto Zicari, John Fuller

1st Edition

0201844524, 978-0201844528

More Books

Students also viewed these Databases questions