Question
Normilation Database Question where the primary keys are underlined the foriegn keys are Italics Normilation process consists of the 1)candidate keys 2) functional dependencys 3)
Normilation Database Question where the primary keys are underlined the foriegn keys are Italics
Normilation process consists of the 1)candidate keys 2) functional dependencys 3) the Referential integrity
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