1. Engineering
  2. Computer Science
  3. definition of requirements for a small company a company has...

Question: definition of requirements for a small company a company has...

Question details

Definition of requirements for a small company:
A company has a set of products that it can supply. These products are supplied by a set of suppliers. A supplier can supply many different products and a product can be supplied by many different suppliers. Customers of the company can place an order for a product. They can also provide feedback on the product. For a customer, the company needs to record the customer’s name and multiple telephone numbers. For the suppliers, they record the supplier’s name and at least one email address. For each product, they record the purchase price, the selling price and a description. The feedback records the customer, the product, the text of the feedback and a score (0-10). An order is for a product, by a customer on a date.

(a) Draw an ER diagram that captures these requirements.

(b) From this design, create a set of table definitions. You should do this using a set of SQL CREATE statements. Make sure that you include all of the necessary constraints.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution