Question: Having an issue with these two relation normalization problems , can you please help? Apply the normalization process to the following relations. Show the following

Having an issue with these two relation normalization problems , can you please help?

Apply the normalization process to the following relations. Show the following steps for each relation:

Show the candidate keys from the original relation.

Show the functional dependencies from the original relation.

Is any determinant not a candidate key? If so, show the following:

The new normalized relations.

The primary key in each new relation.

The foreign keys in the new relations.

The referential integrity constraints for the foreign keys.

Relation 1:

This relation is about home appliances, such as refrigerators, stoves, ovens, washers, dryers, etc.

APPLIANCE (ApplianceType, BrandName, ModelNumber, SerialNumber, OwnerName, OwnerAddress, OwnerPhone)

Assumptions:

Each model number is unique to its brand and type. For example, a Kenmore washer could have a model number of KEN-WASH-990.

Serial numbers are just numbers, like 12345678, so could be duplicated.

Owner phone numbers are unique.

State any other assumptions you make.

Relation 2:

This relation is about playgroups for children. Any child can belong to any playgroup. Each playgroup meets at a certain parents home. That parent is the playgroup leader.

PLAYGROUP (ParentName, ParentEmail, ParentAddress, ChildName, PlayGroup, GroupLeader)

Assumptions:

Each parent has a unique e-mail address.

Each playgroup has a unique name.

Each playgroup has only one leader.

State any other assumptions you make.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!