Question 5. Relational database design. (20 marks) Designing an ER diagram is the first step for database design. It is critical that we understand what makes a good design. Figure 2 is an ER diagram designed for the Orders database about customers and their orders for a company. The semantics of attributes, entity sets and relationships is as expressed in their names. Each item in the database must have an "owning" salesman, whether or not it is being ordered. 5.1. (5 marks) Discuss any issues with the given ER diagram. Give your suggested ER diagram. 5.2. (15 marks) Map your suggested ER diagram to a relational database schema. For each relation schema in the mapped relational database schema, indicate the primary key (underline) and any foreign keys (asterisk) f name l name custID Customer HasAddress address customer Order Item HasSalesman name itemNo salesman desc Figure 2: The Orders database ER diagram