Get Solved Case Normalization Problem
NORMALIZATION CASE PROBLEM (20 POINTS)
In the following case description, the attribute names are included in parentheses
to clarify what each represents:
Pleasant Stay Kennels is a family-run kennel for dogs that would like to
computerize their reservation system. Dog owners call the kennel and make a
reservation for their dog. If an owner will be leaving multiple dogs at the kennel,
each dog has its reservation. Each reservation is automatically assigned a
unique reservation number (do) and a starting date (start), ending date (end),
and daily boarding rate (rate) is recorded. The kennel keeps records on each
dog, including a unique pet ID number (PID), name (name), and birth year
(pear). The kennel also assigns each owner a unique ID number (OID) and
records their name (name), and phone number (phone). While their dog is at
the kennel, the owner may request the kennel perform several services, such as
trimming, baths, or flea dips. The kennel would like the database to identify each
type of service with a unique ID (SID) and record its description (sDesc). The
cost of a service (Scott) may vary from reservation to reservation.
The following unnormalized relation has been developed based on this case. Do
not add any additional attributes as you complete the problem or delete any.
RESERVATION (no, start, end, rate, PID, name, pear, OID, name, phone, sID,
sDesc, Scott)
Using the normalization process, produce a set of 1NF, 2NF, and 3NF relations
for the case described above. Discuss the steps that you take to reach each
normal form and show each set of relations. The following sample data is
provided to illustrate this case:
rNo start end rate pID pName pYear oID oName phone sID sDesc sCost
21456 6/1/02 6/4/02 15.00 4123 Fido 1993 49021 Joe Sims 999-1212 1 Trim $25
21456 6/1/02 6/4/02 15.00 4123 Fido 1993 49021 Joe Sims 999-1212 2 Bath $10
21457 6/1/02 6/4/02 15.00 4124 Spot 1993 49021 Joe Sims 999-1212
21458 6/2/02 6/8/02 20.00 2187 Mutt 1991 38124 May Lo 888-1515 3 Dip $15
21459 6/3/02 6/16/02 10.00 3987 Mini 2001 39218 Jim Sand 555-1414 2 Bath $8
Want Assistance with the Problem?
While you are at IWantOnlineclasshelp.com then the process to hire for a brilliant level of services is very easy. To have to do my online exam-related services, you just have to fill out the form available on the website of www.IWantOnlineclasshelp.com, and once after finishing up this process, all your information that contains Order-ID, name, Contact, email address, etc. will be handled by the sales experts for offering you some effective quotation. Once you settle down with the best possible quotation, you need to pay for the services, and then the management team will take better care of matching pairs of tutors and subjects. We cater to fulfill all your needs even Before the deadline with the best possible A or B grades in a guaranteed way regarding paying someone to take my exam query. You can surely spend some leisure time with your loved ones, take care of the different priorities you have in your life and leave the rest to our professional team. For custom, help email us at [email protected] or WhatsApp us at +1(657)366-7486
