Prove that these tables are 3rd normal. Tour TOUR ID INT Tour has Guide v TOUR N

Question

Prove that these tables are 3rd normal.

Tour TOUR ID INT Tour has Guide v TOUR NAME VARCHAR(45) t Tour TOUR ID INT TOUR LENGTH INT t Guide GUIDE EMPID INT TOUR FEE INT Indexes Indexes CLIENT CLIENT ID INT CLIENT NAME VARCHAR (45) CLIENT PHONENUM VARCHAR(4... t Tour TOUR ID INT Indexes OUTING has CLIENT V t OUTING OUT ID INT t CLIENT CLIENT ID INT Indexes Guide GUIDE EMPID INT GUIDE NAME VARCHAR(45) GUIDE ADDRESS VARCHAR (45) GUIDE HIREDATE VARCHAR(4 GUIDE QUALDATE VARCHAR (45) LOCATION LOC ID INT Indexes LOCATION LOC ID INT LOC NAME VARCHAR(45 LOC TYPE VARCHAR (45) LOC DESCRIP VARCHAR (45) t OUTING OUT ID INT Indexes OUTING OUT ID INT OUT LOC VARCHAR (45) OUT DATE8TIME VARCHAR(45) Indexes

Explanation / Answer

By looking at the tables it can be said that Guide and Tour are connected by Tour_has_guide. Thus it does not have transitive functional dependency. Hece the tables are in 3N form. Similarly client outing and location also dont have transitive functional dependeny. Hence these are also in 3N form.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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