Reference no: EM133163785

SYM-408 Design a Relational Schema - Grand Canyon University

Canyon Sales Business Requirements

The sales department at Canyon Retail Company has decided to create a database that contains the details of its sales process. After gathering all the requirements, conducting interviews, and studying Canyon documentation, the database team spotted the following requirements for the future database. Data will capture about the following:

Question 1. For each product being sold: product ID, product name, and price.

Question 2. For each category of product: Category ID and Category name.

Question 3. For each vendor: Vendor ID and Vendor Name.

Question 4. For each customer: Customer ID, name, and Zip code.

Question 5. For each store: Store ID, and Zip Code.

Question 6. For each region: Region ID and Region Name

Question 7. For each Sales Transaction: Transaction ID and Date of Transaction.

Question 8. Each product is supplied by exactly one Vendor. Each Vendor supplies one or more products.

Question 9. Each Product belongs to exactly one category. Each category contains one or more products.

Question 10. Each store is located in exactly one region. Each region contains one or more stores.

Question 11. Each sales transaction occurs in one store. Each store has one or more transactions occurring at it.

Question 12. Each sales transaction involves exactly one customer. Each customer can be involved in one or more sales transactions.

Question 13. Each product is sold via one or more sales transactions. Each sales transaction includes one or more products.

Question 14. For each instance of a product being sold via sales transaction, the quantity of sold products is recorded.

Attachment:- Design a Relational Schema.rar