Archer Solutions needs to store the following data about customers and sales in a relational database:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Archer Solutions needs to store the following data about customers and sales in a relational database: Product ID Order date Customer ID Customer address Customer name Customer phone Selling price (per unit) Quantity sold Purchase order number Product Description Salesperson ID Salesperson name Salesperson commission rate You are an intern at a local CPA firm. You have been asked by your supervisor to draw a physical ERD for Archer Solutions to illustrate relationships and field names for these tables in a relational database. You must also identify the primary keys and foreign keys that relate to the tables. You may add additional field names, as necessary. For example, the salesperson would have a first name and a last name. Archer Solutions needs to store the following data about customers and sales in a relational database: Product ID Order date Customer ID Customer address Customer name Customer phone Selling price (per unit) Quantity sold Purchase order number Product Description Salesperson ID Salesperson name Salesperson commission rate You are an intern at a local CPA firm. You have been asked by your supervisor to draw a physical ERD for Archer Solutions to illustrate relationships and field names for these tables in a relational database. You must also identify the primary keys and foreign keys that relate to the tables. You may add additional field names, as necessary. For example, the salesperson would have a first name and a last name.
Expert Answer:
Answer rating: 100% (QA)
Heres a physical ERD for Archer Solutions In this diagram Salesperson Product and Customer are three ... View the full answer
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Posted Date:
Students also viewed these mathematics questions
-
To store the following data about our mattress stores revenue (sales) activity: item number item description item cost item commission % customer number customer name customer address sales order...
-
You as a HR Generalist have been asked by your HR Director for your recommendations in terms of what tools your organization could use to better manage the talents of your employees. This will help...
-
In a relational database environment, certain accounting records (for example, journals, subsidiary, ledgers, and event general ledger accounts) may not exist. How is this possible?
-
This scenario is based on thefollowing information: Jo King, aged 58 provided the following information for the year ended 30 June 2023. Table2 - Jo's receipts Receipts $ Net salary (PAYG tax...
-
The following data were taken from the balance sheet of Bock SuppliersCompany: a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one...
-
Evaluate the integral. (Use C for the constant of integration.) | 464+ ex dx
-
Comparative stockholders' equity sections from two successive years of balance sheets from Farrow, Inc., are as follows: No dividends were declared or paid during 2018. Required Prepare the journal...
-
The comparative balance sheets of Nike, Inc. are presented here. Instructions(a) Prepare a horizontal analysis of the balance sheet data for Nike, using 2008 as a base.(Show the amount of increase or...
-
Build Corporation wants to purchase a new machine for $315,000. Management predicts that the machine can produce sales of $213,000 each year for the next 5 years. Expenses are expected to include...
-
Steve, Carol, and Lisa get their first full-time jobs and talk about saving for retirement. They are each 22 years old and plan to work until they are 55. Steve starts investing immediately and puts...
-
CC uses absorption (full) costing and its direct competitor, FF uses variable costing for internal decision making purposes. Last year, both companies reported the same production and sales volumes....
-
If measurements of the elasticity of a fabric yarn can be looked upon as a sample from a normal population having a standard deviation of 1.8 , what is the probability that the mean of a random...
-
How would you derive the demand for milk at the local grocery store? How would you derive the demand for tuna? How would you derive the demand for national defense?
-
Describe the relation between marginal and average costs. Describe the relation between marginal and average fixed costs and between marginal and average variable costs.
-
Is the United States the nation with the most government debt? If not, who is?
-
A very large fermenter is supplied with oxygen sparged in at the bottom to run an aerobic fermentation. Proper control of the device requires that we be able to estimate the percent oxygen...
-
Pure Goodness Company produces and sells canned vegetable juice. The ingredients are first combined in the blending department and then packed in gallon cans in the canning department. The following...
-
Integration is a vital concept when applied in one?s life. Integrating your life means making ideal choices. Perfect choices on the other go in line with quality decisions. Quality decisions lead to...
-
Remnants, Inc., with headquarters in St. Louis, manufactures designer clothing. The company markets and services its products by region, with each functioning as a profit center. Each region has a...
-
An auditor found that Rent-A-Wreck management does not always comply with its stated policy that sealed bids be used to sell obsolete cars. Records indicated that several vehicles with recent major...
-
Should companies allow purchasing agents to start their own businesses that produce goods the company frequently purchases? Why? Would you change your answer if the purchasing agents company was...
-
A distillation column operating at total reflux is separating acetone and ethanol at \(1.0 \mathrm{~atm}\). The height of packing is \(2.0 \mathrm{~m}\). The column has a partial reboiler and a total...
-
We wish to strip \(\mathrm{SO}_{2}\) from water using pure air at \(20.0^{\circ} \mathrm{C}\). Outlet water contains \(0.0060 \mathrm{~mol} \% \mathrm{SO}_{2}\), and inlet water contains \(0.112...
-
If 1-in. metal Raschig rings are used instead of 2-in. rings in Example \(16-2\) : Example 16-2 Example 4-3 Example 16-1 a. Recalculate the flooding velocity and the required diameter. b. Recalculate...
Study smarter with the SolutionInn App