Part 4 (20 marks) Figure 4.9 shows an EER diagram for a university database. Map

Question

Part 4 (20 marks)
Figure 4.9 shows an EER diagram for a university database. Map the EER diagram into a relational schema that consist of relation names, their attributes with primary keys
underscored and foreign keys pointing to the corresponding attributes properly without
using SQL.

Frame (Mini Liname Sun Bdate Se No Street Apt no City Stat Zip PERSON Rphone Salary Class Foffice lege Degre STUDENT Rank FACULTY Degrees Class 5 GRAD STUDENT COMMITTE GRANT Agency St date MINOR PAN Start MAJOR SUPPORT Time M End Grade BELONGS REGISTERED M NSTRUCTOR RESEARCHER CHAIRS RANSCRIPT CURRENT SECTION Current qtr and Year Current year SECTION DEPARTMENT (Year Sect Office CS Dphone COLLEGE KDC N COURSE CD CE Cname

Explanation / Answer

Here we try to reate a relation for each entity set. It can use the same name and same set of attributes as the entity set. The key of the entity set is used as the primary key of the relation.

Person(Name,S&n, Bdate, Sex, Address) // Here S&n is the primary key for the table: Person

These are the two sub attributes of table person :-

Name(Fname, Middle, Lname)
Address(No, Street, Apt_no, City, State, Zip)

Faculty(Rank, Foffice, Fphone, Salary)

Grant(Title, No, Agency, St_date)    // Here No is the primary key for the table: Grant

Department(Dname, Dphone, Office)    // Here Dname is the primary key for the table: Department

College(Cname, Dean, Coffice) // Here Cname is the primary key for the table: College

Course(C#, Cname, Cdeac) // Here C# is the primary key for the table: Course

Section(Sec#, Year, Qtr) // Here Sec# is the primary key for the table: Section

Current_Section(Current_qtr, Current_Year)

Degrees(College, Degree, Year)

Support(Start, Time ,End)

Here we shown above the relation schema of given EER diagram, please go through it throughly.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---