Can you please help me in doing it correctly 1.Using the figure blow, identify e

Question

Can you please help me in doing it correctly 1.Using the figure blow, identify each relationship type and write all of the business rules (for instance: a student can take many courses, a course can be taken by many students). facuty facuty 2. Convert the table below to 3NF Table Studente Advisor Advis Adv Room Class Class2 Class 0107 143-01 159-02 01 159 02 214 01 1022 10 Susan Jones 412 Anse Smith Table 2 Dept Dapt Name Pro Tm Proj 2 Table 3 Rep ID Representative Client 1 Time 1 Client 2 Time 2 Client 3 Time 3 TS-89 Giroy Gladstone US Corp 14 hrs Taggarts 26 hrs Kiroy Inc 9hrs RK-56 Mary Mayhem Italiana 67 hrs Linkers 2hrs

Explanation / Answer

1. Business Rules and Relationship types

2. 3NF

Table1

Functional Dependencies :

Student# -> Advisor#

Student# ->-> Class# ( multivalue dependency)

Advisor# -> Advisor,Adv-Room

Tables in 3NF

Student(Student# , Advisor#)

Class(Student# , Class# )

Advisor(Advisor# , AdvisorName,Adv-Room)

underlined are primary keys and italicized are foreign keys. Some attributes are both.

Table 2

Functional Dependencies :

EmpID -> Name,DeptCode

EmpID ->-> Proj#(multivalue dependency)

DeptCode -> DeptName

Proj# -> time

Tables in 3NF

Employee(EmpID ,Name,DeptCode)

EmployeeProject(EmpID, Proj#)

Department(DeptCode, DeptName)

Project(Proj#, time)

underlined are primary keys and italicized are foreign keys. Some attributes are both.

Table 3

Functional Dependencies:

RepID -> Representative

RepID ->> Client# (multivalue dependency)

Client# -> Time

Tables in 3NF

REP(RepID , Representative)

RepClient(RepID, Client#)

Client(Client# ,Time)

underlined are primary keys and italicized are foreign keys. Some attributes are both.

Do ask if any doubt. Please upvote

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---