information system and technology

the question in the next picture

Plastic-Shoes company: Perfect Plastic is a factory that produces shoes and sandals from plastic (and other materials). They purchase decorative motifs from suppliers, and produce the main part in the company, then they glue the decoration and the main part together. I They purchase each decoration motif from one and only one supplier. Suppliers can be from different cities, some suppliers can be from the same city, and they don't have a supplier in each city (some cities do not have any supplier). Their customer are wholesalers, they can order different products with different quantities at the same time. And they can pay by cash or by installments. The manager of the company wants an information system that allows to track orders, show the credit and the paid amount of each customer, as well as the stock level of each product. The stock level is taken from another information system (inventory) so you do not have to design an IS for inventory. Questions : 1- Create An E-R diagram for this information system. A. Identifyting Entitites B. Attributes C. Identifying Relationships D. Drawing the ERD 2- Which entities are in 2NF, which ones are in 3NF (normal form) ? 3- Draw the ERD that you will use un physical design phase. (20 minutes) (represent the relationships to be done in Ms Access)