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 doesn’t 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?