Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

1. Describe the types of power that effective leaders employ

Answered: 1 week ago