Wheelies is a bicycle manufacturing company based in Holland. Wheelies buys all the parts for its bicycles from various suppliers around the world. The parts are then assembled in the factory in Holland to produce a number of different bicycle models. Customers of Wheelies place orders for the bicycles they require, and delivery is estimated to take three weeks. Each customer order can consist of more than one model of bicycle, and the required quantity of each model is also recorded on the order. At the end of each week the production lines are set up with the models and quantities that will be produced in the following week. The customer orders are used to plan the manufacturing weeks and to purchase parts from the suppliers so all the necessary parts are available for a week’s production. Each individual bicycle that is assembled has a unique code stamped on the frame. When a customer order is ready for dispatch, the frame code of each actual bicycle allocated to that customer order is recorded so that each bicycle can be traced to a particular customer. Deliveries to customers can be arranged for complete or partial orders.
Construct a logical data model (entity-relationship model) showing the details of your methods for identifying entities and