Answer Happy

CIS 2165 - Database ManagementQuestion 2The Big Accounting and Recounting Firm has contacted you to createa personnel database tokeep track of their employees. The company requires thefollowing: The company has a single location The company is organized into departments Each department has multiple employees Each employee is assigned to one department at a time Each employee has a personnel history (promotions, raises,transfers, etc.) Each employee is assigned a phone number that does notchange Each employee is assigned to an office which could change (whentransferred,promoted, etc.)Draw an entity-relationship diagram of your database design forthis system with a reasonablenumber of fields for your tables using DBDL. Be sure to normalizeto third normal form