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