Hidden Valley Golf Lesson Pro First Class Exp Level Pro LastPro PhonePro email W

Question

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 H
• Subjects

---

---

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