Looking for the solution of this problem, thanks for any help!!

Create an ER diagram for each of the scenarios below in LucidChart. Create the ERDs, then one by one copy them this word document. Save the word document as pdf and submit via Canvas. Please be sure to include all components (parts of the model and assumptions) and all necessary notation. For each of the Assumption items, answer the question based on your model and explain how/where your model shows this assumption.

Problem 2: FlyAKite (50 points)

FlyAKite is a small manufacturing company that manufactures specialty kites. They manufacture and sell 200 kites of different sizes and shapes. They have several wholesale customers that order kites from them and FlyAKite needs to keep track of these orders. In particular, they need to know who ordered, when, how many kites of each type, and the delivery type (e.g., ground shipping, overnight). Ina Cloud, the owner of the company, allows her customers to customize the patterns on the kites. However, this customization adds an additional 10% to the price of the kite. It is very important to know how many kites of each type the company has available on hand so that they manage customer expectations at the time of the order.

To increase profits, FlyAKite also wants to keep better track of their spending. They have several approved vendors for their raw materials (e.g., wood, string, paper, paint, glue). They need to keep track of their purchase orders and the prices that different vendors charge for their products. Because FlyAKite is a small manufacturing company, Ina herself is in charge of these purchase orders. A few times in the past, it turned out that the owner paid the same invoice twice make sure that the database tracks whether an invoice was paid or not so this doesnt happen again.

Ina designs most of the kites herself she is a passionate kiter who attends kite-running competitions. She needs to keep track of what material and how much of each is used to make each kite design and also the pattern that is painted on the kite.

Assumptions/Questions:

Which accounting cycles are represented in your ERD?

Are all customers invoiced the same way?

Does FlyAKite deliver partial orders?

Does FlyAKite sell anything that they do not make themselves?