For the following question, prepare ER model and convert it to database designs (i.e., relational schemas). The ER model should have entities, attributes and relations and the database design should have primary and foreign keys. Comment on what normal form your database is in. If you make any assumptions, then write them below the models.

2. You are asked to create a database to produce a report of customer details. The report is to list the customer name, account balance, credit limit, and other customer details. The report will also list the customer account rep (one of our sales employees). Our sales reps manage many customers each, but each customer will be managed by only one account rep at any one time. However, your design should allow for customer's being managed by many account reps as it is possible that some of our employees may leave the company - thus, requiring new account reps for a customer.