No need for Visio, I would like this on a Word, Excel, or hand written with a sp

Question

No need for Visio, I would like this on a Word, Excel, or hand written with a specific detailed ERD please.

Upload Assignment: Hon x y D wEEKLY SCHEDULE-Spix D Project Task 4(11pdf × MGMT 329: Database M ? A local kennel asked us: ? ???Secure ! https://learn.unm.edu/bbcswebdav/pid?3708909-dt-content-rid-24931000-1/courses/27085.201860/Homework 3.pdf AppsBlackboard IT PearsonEthics ConnectM Update on Medical ? ? vRealize Automation Other bookmarks WEEKLY SCHEDULE-SPRING 2008 (REVISED) OVERVIEW A local kennel asked us to create a database to keep track of their puppies that they have for adoption. They are continuing to grow and have ran into problems with data management trying to use Excel spreadsheets to manage their information. They need to have ability to present reports to their customer showing puppies that are available for adoption and what tricks each puppy is able to perform. If a customer decides to adopt the puppy then they need to know which kenn el the puppy is located at. Start with this report showing puppies, their kennels, and the tricks they have learned. P Num P Name K Code Kennel K Loc Trick Skil T Where 341 Fido 48 Unitedogs Quincy Rolle Gd Chicago Play Dead od Quincy Quincy Excellent Quincy 49 Dogs'RUs Buffalo Play Dead Po Omaha Buffalo 48 UnitedDogs Quincy e Excellent Seattle PlayDead Excellent Seattle 49 Dogs'R'Us Buffalo Roler God Miami 49 Dogs Are Us Buffulo Rollover GoodAtlanta Speak Shake 399 Fluffy Shake Poor 328 Butch 311 Sparky 350 Goofy 388 Snuggles 42 HappyDogs Norwood Shake Excellent Charlotte Play Dead Excellent Charlotte 333 Butch 48 Unitedogs Quincy SpeakP Poor Miami REQUIREMENTS Your task is to create a normalized ERD using the information provided in the Kennel Report above. You need to identify the entities, attributes and relationships for the ERD. The ERD should be normalized to 3NF for the final solution. Use Visio to create your final ERD solution. O Type here to search 10:53 AM 6/30/2018

Explanation / Answer

Kernal_Master

Puppy_master

Locaction_Master

Trick_Master

Glossary:

PK : Primary Key

FK: Foreign Key

Note one more table or master may be created for Skill but Puppy_Master get ovloaded and to get shown data in question is required 4 inner join which is not optimized select statement and also skill not having more different values.

Column Name Data type Constraint K_Code integer PK Kernal varchar Location_code integer FK (Location_Master)

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.