1. Based on the Crow's Foot ERD below: a) list the entities (8 points). b) for each entity, list the attributes (8 points), the relationship cardinalities (8 points) between the entities and the primary and foreign keys (8 points). For example, there is a one to many (1:M) relationship between the CUSTOMER and INVOICE entities. (What does the circle notation in 2 tell us?) 2. Write the business rules that are reflected in the following Crow's Foot ERD. (8 points) N.B.: You need to list 8 business rules, one rule for each cardinality symbol. I have labelled the symbols from 1 to 8 in red. Label your business rules accordingly. The business rules should be stated in plain English. For example, here is the business rule (again, in plain English) corresponding to the symbol labelled 2: 2. Every customer can have many invoices. LINE INV_NUMBER CUSTOMER CUS_CODE CUS L.NAME CUS_AREACODE CUS_INITIAL CUS_BALANCE CUS_PHONE CUS_FNAME INVOICE INV_NUMBER INV_DATE CUS_CODE + 3 LINE_NUMBER LINE_UNITS P_CODE LINE_PRICE VENDOR V_CODE V_NAME V_CONTACT PRODUCT P_CODE P_Q P_DISCOUNT V_CODE P_PRICE P_MIN P_DESCRIPTION P_INDATE + V_PHONE V_ORDER V_STATE V_AREACODE 1. Based on the Crow's Foot ERD below: a) list the entities (8 points). b) for each entity, list the attributes (8 points), the relationship cardinalities (8 points) between the entities and the primary and foreign keys (8 points). For example, there is a one to many (1:M) relationship between the CUSTOMER and INVOICE entities. (What does the circle notation in 2 tell us?) 2. Write the business rules that are reflected in the following Crow's Foot ERD. (8 points) N.B.: You need to list 8 business rules, one rule for each cardinality symbol. I have labelled the symbols from 1 to 8 in red. Label your business rules accordingly. The business rules should be stated in plain English. For example, here is the business rule (again, in plain English) corresponding to the symbol labelled 2: 2. Every customer can have many invoices. LINE INV_NUMBER CUSTOMER CUS_CODE CUS L.NAME CUS_AREACODE CUS_INITIAL CUS_BALANCE CUS_PHONE CUS_FNAME INVOICE INV_NUMBER INV_DATE CUS_CODE + 3 LINE_NUMBER LINE_UNITS P_CODE LINE_PRICE VENDOR V_CODE V_NAME V_CONTACT PRODUCT P_CODE P_Q P_DISCOUNT V_CODE P_PRICE P_MIN P_DESCRIPTION P_INDATE + V_PHONE V_ORDER V_STATE V_AREACODE