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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started