Amy’s Bikes is a new bike shop located in a suburb in Ontario, offering a wide range of bicycles and related accessories. Amy, the shop’s owner, has been conducting her daily business mostly on paper. She records sales on preprinted forms, which contains the invoice number and date of the sale, the customer and the employee involved in the sale and the product being sold. Employee and customer information is maintained on sheets of paper. For each employee, this includes his/her social insurance number, first and last name, and home phone number. For each customer, Amy records the first, middle (if any) and last name, as well as phone number and home address (consisting of street number and post code). To keep track of the product inventory, Amy uses a spreadsheet program to record the number, name, price and quantity of the products in stock. For each product, a range of services is offered. The spreadsheet program is also used to list the type (e. g., repair, exchange) and charge for each service. Multiple types of service may be offered to one product (e. g., repair and exchange for bikes) and a service may be offered to multiple products (e. g., repair for bikes and accessories) at different prices.
Required:
1. Recently, she has decided to use database to manage all this data. Now help Amy to design an ER schema that better captures the requirements. It should contain all relevant concepts in the requirements.