Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CS Hobbies is a hobby retail outlet that sells military model kits direct to the public. The business has a number of model categories such
CS Hobbies is a hobby retail outlet that sells military model kits direct to the public. The business has a number of model categories such as cars, boats, airplanes, figurines and tanks that come from different manufacturers such as Airfix and Tamiya. The same models may even come in different scale sizes. E.g. a Volkwagen Beetle may come in 1:10 scale and 1:50 scale.
Customers visit the store and place an order with a staff member. An order can consist of one or more models. Should the customer wish to create a complete scene, then all the models in the scene should be to the same scale. For instance, a scene may have two tanks, an airplane, 5 soldiers and a refuelling truck all with a scale of 1:48
Once the order is placed and the payment is confirmed, the items are then retrieved from the storeroom. When the order is completed and shipped, the customer will be notified about the shipping date and the expected delivery date.
CS Hobbies now wants to computerize their order management system. The owner wants to record details of the customers, the orders that are placed, remaining stock levels for future orders and more than one contact phone number for each customer.
The owner would also like to know as to when each item in the order has been retrieved from the storeroom, so that the customer can be informed of shipping delays, if the products are not available. The customer can then decide whether to have the order sent out with fewer items than what was originally ordered.
As part of the computerization, the business also wants to offer an online ordering page with a click and collect option.
-An entity relationship diagram including significant attributes against each entity.
use the example below for reference on how to draw the ER diagram
yes please do the ER Model by following the case study
Apparel Size size id size code sort order Product Colors color id Product product name product id other data Color color id color code color name Product Categories category id Categories category id parent category id category name Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started