Answer to Question #212942 in Programming & Computer Science for henny

Question

Busiswe runs a small shop selling products that are produced by individuals working from their homes. She would like to have a database where she stores details of the products that she sells, the producers from which she buys, and a list of her customers that have a standing order. For each product, she would like to have a unique product number, a description of the product, and the cost price of the product. For the producers, she would like to know the producer's name and telephone number. For her customers, she would like to give each customer a unique number and store their name and birth date in the database. Each customer must have a separate standing order for each product that they want to be delivered every month. Each standing order will have a unique number, the product that is ordered, and the date that the order was placed. A customer cannot be added to the database if they do not have a standing order.

 

draw an ERD for the following case study.

Answer 1

Dear henny, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order