Results from Normalization: (List each table including all fields with data and

Question

Results from Normalization: (List each table including all fields with data and primary keys) Hidden Valley Golf Lesson Pro First Class Exp Level Pro LastPro PhonePro email Winters Client First Client Last Client Phone i (540) 123-4567 Weathers (540) 123-4999 cweathers Montvale(540) 123-8004 Montvale(540) 123-8004 114 123 123 101 114 Sally Struthers (540) 333-8786 Jenny Wital (540) 489-0807 T Bob Jones Bob Jones Sally Struthers (540) 333-8786 Getting Started Jenny Witherall(540) 489-0807 Getting Started Debbie Debbie ohnne Winters540) 123-4567 winters@hfg.com (540) 845-7689 (540) 845-7689 The Chip 1 Short Put 1 Long Drive 1 Weathers(540) 123-4999 cw Stineman (540)123-7778 rstineman@hfg.com Stineman (540) 123-7778 rstineman@hfg.com Stin(540) 123-7778 rstineman@hig.com Winters (540) 123-4567 Larsdale (540) 123-6789 blarsdale@h Larsdale(540) 123-6789 blarsdale@hig.com Collins Ricky Ricky Ricky Joe Percell (540) 345-8711 Improving Chip Frank Rella Frank Rella (540) 986-4456 Focus on Put (540) 986-4456 Increasing the Drive (540) 833-9690 Increasing the Drive (540) 156-8745 Getting to the Win (540) 156-8745 Refining your Stroke 540) 755-9812 Refining your Stroke 242 Betsy Betsy Katie ChrisKruck Patty Akers Patty Akers 0) 123-3377 kllinsahfg.com 420 Notes: Recall you cannot add fields or remove fields when normalizing! List all Functional Dependencies: HINT: Determine whether you have 1:M or M:N relationships and refer to pages 220-222 in your textbook for help

Explanation / Answer

Functional Dependencies

ProID -> Pro_First

ProID -> Pro_Last

ProID -> Pro_Phone

ProID -> Pro_email

ClientID -> Client_First

ClientID -> Client_Last

ClientID -> Client_Phone

Class -> Class_Exp_Level

Class -> Cost

Normalized tables

Pro(ProID , Pro_First , Pro_Last , Pro_Phone , Pro_email)

Client(ClientID , Client_First , Client_Last , Client_Phone)

Cls(Class ,Class_Exp_Level , Cost)

underlined are primary keys

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

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