Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A company has a range of products for sale to customers, and for the products that it sells, it has suppliers. E.g. think of IKEA

image text in transcribed
A company has a range of products for sale to customers, and for the products that it sells, it has suppliers. E.g. think of IKEA or ACE or Lulu. Based on the following brief description of operations, create the appropriate fully-labeled Crow's Foot ERD. - A customer can order one or more products. For example, you could order one chair of a certain model from IKEA. Or you might order many more chairs. The name, address, gender and date of birth of customers is recorded. That is so that relevant marketing messages could be sent to the customer on their birth dates. - For each order placed by a customer, a product (by ID), date of the order, how many of it the customer needs and the total cost amount is tracked. - A product at the store must be purchased from a supplier. Therefore, other than the product ID, its name and the supplier's ID should be recorded. - A supplier can have many different products. It is possible for a supplier to be in the system even if they don't currently have any products to sell. - Other than an ID, the name of the supplier and a contact person needs to be tracked. What to Submit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Reliability Engineering Designing And Operating Resilient Database Systems

Authors: Laine Campbell, Charity Majors

1st Edition

978-1491925942

More Books

Students also viewed these Databases questions

Question

Explain the steps involved in training programmes.

Answered: 1 week ago

Question

What are the need and importance of training ?

Answered: 1 week ago