Draw ERD diagram Crows foot notation

#1

Draw an ERD containing the Order and Customer entity types connected by a 1:M relationship between Customer and Order. Choose an appropriate relationship name using your common knowledge of interactions between customers and orders. Define minimum cardinalities so that an order is optionally connected to a customer and a customer is mandatory for an order. For the Customer entity type, add attributes CustNo, CustFirstName, CustLastName, CustStreet, CustCity, CustState, CustZip, and CustBal (balance). For the Order entity type, add attributes OrdNo, OrdDate, OrdName, OrdStreet, OrdCity, OrdState, and OrdZip. Next, add the Employee entity type and a 1:M relationship from Employee to Order. Choose an appropriate relationship name using your common knowledge of interactions between employees and orders. Define minimum cardinalities so that an employee is optionally connected to an order and an order is optionally connected to an employee. For the Employee entity type, add attributes EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEmail, EmpCommRate (commission rate), and EmpDeptName. Now, add a management relationship where employees have a manager assigned to them from amongst them. Lastly, add a Product entity type and an M:N relationship between Product and Order. Choose an appropriate relationship name using your common knowledge of connections between products and orders. For the Product entity type, add attributes ProdNo, ProdName, ProdQOH, ProdPrice, and ProdNextShipDate. For the M:N relationship, add an attribute for the order quantity. Since M:N relationships are not advisable, revise the ERD as suitable. Make sure you choose appropriate data types for the attributes based on your common knowledge. Select suitable primary keys and foreign keys. Clearly label weak entities, and identifying and nonidentifying relationships.