A company currently has a series of products which they are selling. Each product is stored as a name and products may be categorised according to a type, e$.$g$.$ a product may be a refrigerator and the type of the product may be appliance or the product may be a knife and the product type may be utensil. The company plans to do sales using the products. Every sale needs to be captured with a customer name and a date of the sale. A sale may consist of multiple products and multiple items of a specific product may be included on a sale, e$.$g$.$ The customer Thea Nilsen purchased $5$ knives and $5$ forks on $11$ August $2020.$

Your task is to design a database schema that allows the information provided above to be stored. The focus of the question is the creation of the various tables, which you think are required, the relationship between the tables and the constraints you think should be applied. As your answer:

Paste the script$($s$)$ necessary to create the tables required for your envisioned solution.

For each table, provide a brief description of the role of the table and how it relates to any of the other tables.

Answer rating: 100% (QA)

Based on the provided information we can design a database schema with the following tables 1 Customers Description This table stores information about the customers Columns customerid primary key cus... View the full answer