Note: In case if your problem statement is updated, please donot hesitate us and send it to us at [email protected] We would surely like to help you in this regard.
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 own reservation. Each reservation is automatically assigned a
unique reservation number (rNo) and a starting date (start), ending date (end),
and daily boarding rate (rate) are recorded. The kennel keeps records on each
dog, including a unique pet ID number (pID), name (pName), and birth year
(pYear). The kennel also assigns each owner a unique ID number (oID) and
records their name (oName), 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 (sCost) may vary from reservation to reservation.
The following unnormalized relation has been developed based for this case. Do
not add any additional attributes as you complete the problem or delete any.
RESERVATION (rNo, start, end, rate, pID, pName, pYear, oID, oName, phone, sID,
sDesc, sCost)
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
* If you have any issues with the payment method, please let us know at [email protected] and that can be discussed and considered.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at [email protected].
* As soon as the payment is received through PayPal, download link of the solution will automatically be sent to the address used in Paypal.
* Please check your junk mails as the download link email might go there.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at [email protected] and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please expect to get a response within 8 hours from our side.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.
* In case of any query, please donot hesitate to contact us at [email protected].
******************************************** Good Luck ***************************************************
Any personal information received will only be used to fill your order. We will not sell or redistribute your information to anyone.
We will try our best to resolve the issue and if still persists we can discuss for a refund in case its required.
Note: In case if your problem statement is updated, please donot hesitate us and send it to us at [email protected] We would surely like to help you in this regard.