Small College wants to migrate their data to a database system and your job is to help them design the new database. As first step, please begin the conceptual design by doing the following:

a. Identify all the entity types.

b. For each entity type, identify all the attributes. Note that some of the attributes may be

composite, multivalued, or derived.

c. Note any assumptions made during the design.

d. Using ERDPlus (www.erdplus.com), draw the initial ER diagram for this preliminary design

PAYROLL SYSTEM FILES Faculty.file ID Nr Name Address Salary YTD earn Dpt. N 52,500 59,000 60,000 119Marten, Ann 94 Ridge, Grant, MI 209 Newton, Jane 210 Leonard, Ada, MI 421 Johns, Alice 121 Calhoun, Hart, MI 462 Johnson, Tom 604 46th Street, Lowell, MI65,000 485 Sparks, Pam201 Olive, Holt, MI 507 Canton, Rob5 State, Cutler, MI 564 Ferris, Gina16 W.9th St., Troy, MI 683 Nils, Frank46 Creston, Ada, MI 15,425 18,945 11,402 16,952 20,115 11,010 18,450 22,050 43,500 59,500 58,500 76,500 Department.filc Dept. Nr Dept. Name Dept. Address Chair Computer Science 408 Kelly Hl Jones, Ann Mathematics Geology Physics 253 Watson Ha Sparks, Pam 707 Case TowerFerris, Gina 118 Font TowerNils, Frank