Please help, I am so confused on this assignment Recall that in Data Modeling section we have developed the E R model for the Highline University database After you have reviewed the E R model, create relational database design for the model For each entity in the E R model, specify a table structure, determine the data types and additional column properties, identify primary keys and foreign keys, and verify normalization on the resulting tables Document referential integrity constraint enforcement actions and any business rules that you think are important Use the provided RI table template for question 2 below to fill in as appropriate DEPARTMENT COLLEGE PK DepartmentName PROFESSOR PK CollegeName TO Chairs PK ProfFirstName Phone HTPK ProfLastName DeanFirstName H has H TotalMajors DeanLastName Building Building Phone Room H contains 14 OfficeNumber Building Phone Room HE H Major PO STUDENT PK StudentNumber Title StudFirstName StudLastName HomeStreet PO Advises HomeCity HomeState HomeZip Phone f

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 22, 2024

Please help, I am so confused on this assignment. Recall that in Data Modeling section we have developed the E-R model for the Highline University

Please help, I am so confused on this assignment.

Recall that in Data Modeling section we have developed the E-R model for the Highline University database. After you have reviewed the E-R model, create relational database design for the model.

For each entity in the E-R model, specify a table structure, determine the data types and additional column properties, identify primary keys and foreign keys, and verify normalization on the resulting tables.

Document referential integrity constraint enforcement actions and any business rules that you think are important. Use the provided RI table template for question 2 below to fill in as appropriate

DEPARTMENT COLLEGE PK DepartmentName PROFESSOR PK CollegeName TO- -_ _ _Chairs PK ProfFirstName Phone - -- -HTPK ProfLastName DeanFirstName -H- - - -! has - - - -H TotalMajors DeanLastName Building Building Phone Room - H- - _ _ contains ---14 OfficeNumber Building Phone Room - HE -H Major PO- - STUDENT PK StudentNumber Title StudFirstName StudLastName HomeStreet PO Advises HomeCity HomeState HomeZip Phone\f