Question
Wholesale Club is a Canadian wholesaler of food for retailers in most Canadian regions and cities. Wholesale Club buys its products directly from manufacturers and
Wholesale Club is a Canadian wholesaler of food for retailers in most Canadian regions and cities. Wholesale Club buys its products directly from manufacturers and farmers, and then resells them to individual retail stores and end-user consumers in the region. The table on the nest page contains raw information related to ordering and purchasing products and items from suppliers. Review the data and answer the questions that follow.
- What is the main problem with the information presented in the table? How should this problem be solved? (5 marks)
- Design the relational tables necessary to solve this problem. (15 marks)
- Identify the primary key for each table as well as the foreign keys needed in the tables to implement referential integrity. (5 marks)
| Purchase Order # | Purchase Order Date | Product # | Description | Unit Price | Quantity Ordered | Vendor # | Vendor Name | Vendor Address |
| 5 | 3/9/18 | 334 | XYZ | $30 | 3 | 204 | FK Supply | 107 Fairmont Dr. |
| 5 | 3/9/18 | 231 | PDQ | $50 | 5 | 204 | FK Supply | 107 Fairmont Dr. |
| 5 | 3/9/18 | 444 | YYM | $80 | 6 | 204 | FK Supply | 107 Fairmont Dr. |
| 3 | 4/5/18 | 231 | PDQ | $50 | 2 | 689 | Norman Inc. | 56 Main Street |
| 3 | 4/5/18 | 241 | XWZ | $80 | 4 | 689 | Norman Inc. | 56 Main Street |
| 3 | 4/5/18 | 261 | XYZ | $90 | 3 | 689 | Norman Inc. | 56 Main Street |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Eoc Only Davis Managerial Accounting
Authors: Charles E. Davis, Elizabeth Davis
2nd Edition
111883464X, 978-1118834640
