ER-Assista project-Ha Dass-Part 2 Fle Edt Mew Insert Mode Window Help FACULTY Fa

Question

ER-Assista project-Ha Dass-Part 2 Fle Edt Mew Insert Mode Window Help FACULTY Facuby D LastName FacutyEmai H+------------3 partment Buildi OfficeNumber Office OR STUDENT A Student D F ty D (FH) Assignment Beg Assignment End Ready STUDENT Student astNam Student StudentE Dorm Name Dorm Room NTLM Men Assignment B Assignment -+H DEGREE INFO +-----------------1 Student D FK ALUMNI Graduatio eMajol MENTOR AAumFirstName AhumLastName Mentor astName AumE MentorfirstN Add State Com ystate Phone Com Com yPhone R ADVISOR A Faculty D (FK Assignment B A8aignmentLE

Explanation / Answer

FACULTY(Faculty_ID,FacultyLastName,FacultyFirstName,FacultyEmail,Department,BuildingName,OfficeNumber,OfficePhone)

Here Department,BuildingName,OfficeNumber,OfficePhone are not functionally dependent on Faculty_ID So take them in another table DEPARTMENT

FACULTY(Faculty_ID,FacultyLastName,FacultyFirstName,FacultyEmail)

DEPARTMENT(DepartmentName,BuildingName,OfficeNumber,OfficePhone)

STUDENT(Student_ID,StudentLastName,StudentFirstName,StudentEmail,DomName,DomRoom,DomPhone)

Here DomName,DomRoom,DomPhone are not functionally dependent on Student_ID so take them in another table DOM

STUDENT(Student_ID,StudentLastName,StudentFirstName,StudentEmail)

DOM(DomName,DomRoom,DomPhone)

MENTOR(MentorEmail,MentorLastName,MentorFirstName,CompanyName,CompanyAddress,CompanyCity,CompanyState,CompanyZip,CompanyPhone)

Here CompanyName,CompanyAddress,CompanyCity,CompanyState,CompanyZip,CompanyPhone are not Functionally dependent on MentorEmail so take them in another table

MENTOR(MentorEmail,MentorLastName,MentorFirstName)

COMPANY(CompanyName,CompanyAddress,CompanyCity,CompanyState,CompanyZip,CompanyPhone)

DEGREE_INFO(Student_ID,Enrollment,Graduation,DegreeMajor)

ALUMNI(Alumni_ID,AlumniFirstName,AlumniLastName,AlumniEmail,Address,City,State,Zip,Phone)

Assignment_Beg and Assignment_End attributes in following tables are not functionally dependent on Student_ID or MentorEmail so take them in another table ASSIGNMENT with Assignment_ID as primary key and use Assignment_ID as foreign key in these tables

OR_STUDENT_A(Student_ID,Faculty_ID,Assignment_ID)

MT_MENTOR_A(StudentID,MentorEnroll,Assignment_ID)

OR_ADVISOR_A(MentorEmail,Faculty_ID,Assignment_ID)

ASSIGNMENT(Assignment_ID,Assignment_Beg,Assignment_End)

All the tables in bold are normalized where underlined attributes are primary keys and italicised are foreign keys. Some attributes are both.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

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