Create an ER model for each of the following descriptions:

$($a$)$ Each company operates four departments, and each department belongs to one company.

$($b$)$ Each department in part $($a$)$ employs one or more employees, and each employee works for one department.

$($c$)$ Each of the employees in part $($b$)$ may or may not have one or more dependents, and each dependentbelongs to one employee.

$($d$)$ Each employee in part $($c$)$ may or may not have an employment history.

$($e$)$ Represent all the ER models described in $($a$),($b$),($c$),$ and $($d$)$ as a single ER model.

Create an ER model to represent the data used by the library. The library provides books to borrowers. Each book is described by title, edition, and year of publication, and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is available for loan, and the allowable loan period for a given copy. A borrower may loan one or many books, and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan.

a$)$ Draw the diagram and submit the model file using workbench.

Download the attached file and run script in workbench to create a CIS$495$ DB$.$ Use the "Reverse Engineer" in workbench to generate the EER Diagram. Based on the digram, plese describe

a$.$ The primary and foreign key for each table

b$.$ The relationship between the tables

Updated$\_$mysqlsampledatabase.sq

$$

$$