Please use ERDPlus available at www.erdplus.com to create ER diagram.

Small College (database file as below) wants to migrate their data to a database system and your job is to help them design the new database. Modify below design to complete the ER model for the database.

a. Identify all the relationship types and their attributes, if any. b. For each relationship types, identify the structural constraints (both the cardinality ratios and the participation constraints) c. List any assumptions made during design, especially for the structural constraints d. Using ERDPlus, available at www.erdplus.com draw ER diagram, use the crow's foot notation for the constraints.

Database Design:

Database Files:

name D_address Number Name Address Salary Chair ld DEPARTMENT YTD earrn Rank FACULTY Depend_cov Description Degree Single_cost Plan_nr In Department INSURANCE Family_cost Degree Middle_I Dept Num Last Name City First_Name State Rank Street (Name) (Address) Dept_Coverage Plan_Nr Faculty ID (Insurance) Faculty Salary YTD earn Faculty Room Nbr Building Dept_Name Dept Address) Plan_Nr Single_Cost Dept Num Chairperson Insurance Dept Cost Department