Suppose you are creating a database for a small business. The business sells hobby and memorabilia...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose you are creating a database for a small business. The business sells hobby and memorabilia products. The store manager wants to expand the business and she's looking for help to develop a database that should be able to capture customer /shipping information, track inventory and orders. Table 1 shows some examples of the type of information contained in a typical customer order: Table 1. Sample Orders Customer Name: Boris Badenov Shipping Address: 314 Python Street, Washington, DC 20001 Order Date: Dec. 7th, 2020 Items Ordered: Item 1: Magic Glove 2020 Item 2: Raccoon Spray Items Ordered: Item 1: Magic Glove 2020 Item 2: Brick-proof Helmet Quantity: 2 Quantity: 1 Customer Name: Nicolas Flamel Shipping Address: 17 Prime Street, Boston, MA 02101 Order Date: Dec. 8th, 2020 Items Ordered: Item 1: Force Sword Item 2: Brick-proof Helmet Item 3: Hamster-powered Generator Quantity: 1 Quantity: 2 Unit Price: $25.99 Unit Price: $15.99 Customer Name: Johnny Test Shipping Address: 11 Parallel Road, Infiniville, MI, 00000 Order Date: Dec. 8th, 2020 Quantity: 1 Quantity: 2 Quantity: 2 Unit Price: $25.99 Unit Price: $18.99 Unit Price: $130.00 Unit Price: $18.99 Unit Price: $40.00 a) Design a simple relational database that captures the information required to maintain records of orders. Take into account that your design should allow a customer to order as many items as he/she would like, eliminate potential errors and redundancies by having multiple tables for the entities that are needed in this process. Present your design with an Entity Relationship Diagram (ERD) for this database. Add attributes if necessary (e.g. primary key(s)) to make sure you have unique records in your tables. Consider compounding fields to create unique records on your intersection table. Follow the design process to avoid potential issues b) Use the concept your initial design from part a, and create your database in Access. Create the relationships between your tables and populate your tables with the orders/information in Table 1. Suppose you are creating a database for a small business. The business sells hobby and memorabilia products. The store manager wants to expand the business and she's looking for help to develop a database that should be able to capture customer /shipping information, track inventory and orders. Table 1 shows some examples of the type of information contained in a typical customer order: Table 1. Sample Orders Customer Name: Boris Badenov Shipping Address: 314 Python Street, Washington, DC 20001 Order Date: Dec. 7th, 2020 Items Ordered: Item 1: Magic Glove 2020 Item 2: Raccoon Spray Items Ordered: Item 1: Magic Glove 2020 Item 2: Brick-proof Helmet Quantity: 2 Quantity: 1 Customer Name: Nicolas Flamel Shipping Address: 17 Prime Street, Boston, MA 02101 Order Date: Dec. 8th, 2020 Items Ordered: Item 1: Force Sword Item 2: Brick-proof Helmet Item 3: Hamster-powered Generator Quantity: 1 Quantity: 2 Unit Price: $25.99 Unit Price: $15.99 Customer Name: Johnny Test Shipping Address: 11 Parallel Road, Infiniville, MI, 00000 Order Date: Dec. 8th, 2020 Quantity: 1 Quantity: 2 Quantity: 2 Unit Price: $25.99 Unit Price: $18.99 Unit Price: $130.00 Unit Price: $18.99 Unit Price: $40.00 a) Design a simple relational database that captures the information required to maintain records of orders. Take into account that your design should allow a customer to order as many items as he/she would like, eliminate potential errors and redundancies by having multiple tables for the entities that are needed in this process. Present your design with an Entity Relationship Diagram (ERD) for this database. Add attributes if necessary (e.g. primary key(s)) to make sure you have unique records in your tables. Consider compounding fields to create unique records on your intersection table. Follow the design process to avoid potential issues b) Use the concept your initial design from part a, and create your database in Access. Create the relationships between your tables and populate your tables with the orders/information in Table 1.
Expert Answer:
Answer rating: 100% (QA)
a Here is a design for a simple relational database that captures the information required to maintain records of orders Table Customers Attributes CustomerID Primary Key CustomerName ShippingAddress ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
1) (a) How can you calculate various Capital Adequacy Ratio under Bank Regulation? Explain them. (b) State the Banking Regulation for Capital Adequacy of Banks in Saud Arabia. 2) Discuss any three...
-
If you can't find similar ratios to class-covered ones, use financial formulas to calculate them manually. Choose up to two of the following: Operating Margin EBITDA Margin Payout Ratio 3. Analysis...
-
A set of ten jobs must be scheduled at an integrated machining center that performs a number of metal-cutting operations on components for complex assemblies. These jobs and their processing times...
-
Determine whether each statement is true or false, and explain why. For the limit of (x) as x a to exist, must be defined at a.
-
Acne Medication and Gastrointestinal Injury Since 1999, Kamie Kendall had experienced ongoing abdominal pain, and she was eventually diagnosed with ulcerative colitis and irritable bowel syndrome...
-
Choosing cost drivers, activity-based costing, activity-based management. Pumpkin Bags (PB) is a designer of high quality backpacks and purses. Each design is made in small batches. Each spring, PB...
-
Date Account Title Debit Credit Sept 1 Cash 10,000 Common Stock 10,000 Sept 2 Equipment 5,000 Cash 5,000 Sept 3 Rent Expense 400 Cash 400 Sept 4 Supplies 500 Cash 500 Sept 5 Advertising Expense 250...
-
Murphy Delivery Service completed the following transactions during December 2018: Dec. 1 Murphy Delivery Service began operations by receiving $13,000 cash and a truck with a fair value of $9,000...
-
PAL: Histology > Epithelial Tissue > Lab Practical > Question 2 Identify the highlighted structures.
-
What should be done with any activities that remain incomplete at the time of project closure?
-
What are the benefits and challenges of growing through internal expansion? Acquisition? Networks and alliances?
-
During the close project or phase process, the team and project manager may wish to review the ________________. a. project charter b. WBS c. risk register d. all of the above
-
What are the differences between strategic plans and marketing plans?
-
How might alliances be less risky than ownership?
-
Last year the news media reported the jailing of a telecommunications technician who obtained the personal data of a family member of a police officer for the purposes of doxing. This involved the...
-
3M Company reports the following financial statement amounts in its 10-K report: a. Compute the receivables, inventory, and PPE turnover ratios for both 2018 and 2017. (Receivables turnover and...
-
The Carter family wants to purchase a time-share condominium for 1 week during the summer in Hilton Head, South Carolina. There are many resort complexes from which to choose, and the Carters have...
-
The Fifth Quarter Bar buys Old World draft beer by the barrel from a local distributor. The bar has an annual demand of 900 barrels, which it purchases at a price of $205 per barrel. The annual...
-
The Hickory Cabinet and Furniture Company produces sofas, tables, and chairs at its plant in Greensboro, North Carolina. The plant uses three main resources to make furniturewood, upholstery, and...
-
In the January 1, 20X8, consolidated balance sheet, the amount of goodwill reported should be a. $0. b. $76,000. c. $95,000. d. $156,000. On January 1, 20X8, Ritt Corporation acquired 80 percent of...
-
In the December 31, 20X8, consolidated balance sheet, the amount of noncontrolling interest reported should be a. $200,000. b. $239,000. c. $251,000. d. $252,000. On January 1, 20X8, Ritt Corporation...
-
On January 1, 20X5, Post Company acquired an 80 percent investment in Stake Company. The acquisition cost was equal to Posts equity in Stakes net assets at that date. On January 1, 20X5, Post and...
Study smarter with the SolutionInn App