Create a Salesperson table and a Customer Order table using the data in Figure 3-11. Create records
Question:
Create a Salesperson table and a Customer Order table using the data in Figure 3-11. Create records for each table using the data provided. Add one more Salesperson record with your own name and an employee number of your choosing. Also add at least one customer order with your number as the salesperson. Finally, create a relationship for the two tables. Create hard-copy documentation of your work.
Transcribed Image Text:
Customer Order Table (Event) Customer # Order # Employee # Date Comments B104 1003 M24SP 01/03/2014 R63SP 01/03/2014 1004 P202 Ship ASAP 1005 M24SP S200 01/03/2014 CI00 1006 WIISP 01/03/2014 Inventory Table (Resource) Item # Description Unit Cost Sales Price Beg QOн $0.20 $0.40 13025 1400 Yummy Bar $0.25 $0.45 1500 Almond Delight 5010 $0.60 $0.70 $0.18 $0.95 1600 Gummy Lions 20109 1700 $1.09 $0.30 Pecan Bar 4508 1800 Milky Bars 2207 Customer Table (Agent) City Customer # Name Address Province Postal Code Credit Limit C1A 1P1 $20000.00 A101 Amanda Wills 22 Yellow Ln. Charlottetown PEI 5,000.00 B104 Boris Bailey 321 Church St. Oxford ON K1S 106 QC C100 Gaily Riccaini 1899 Green St. Montreal Peggy Marlin 1260 Main St. Churchill H4N 3K1 10,000.00 10,000.00 5,000.00 ROB OEO P202 MB V6X 3J9 BC S200 Bill Safer 860 Broad St. Fairfax Salesperson Table (Agent) Employee #Name Address City ProvincePostal CodeDept IDDate Hired 406SF Sally Anderson3026 Skye Ln. Ajax ON МэВ внв 247 1/31/1989 7/2/1999 1/16/2009 M24SP Randy Merit 262 Main St. Brampton ON L6X 2B4 182 Barry Rogers 80N. Long St. Caledon Jim Rudolph 64 Lantern Ave.Orangeville 1028 Fields Ln. Mississauga ON R63SP L8G 4P4 247 R73SP ON L7A 2A1 76 8/15/2010 ON WIISP JolinWalker L5R 4J3 182 9/1/1992
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 55% (9 reviews)
ANSWER Salesperson Table Employee Name Address City Province Postal Code Dept ID Date Hired 406S...View the full answer
Answered By
Churchil Mino
I have been a tutor for 2 years and have experience working with students of all ages and abilities. I am comfortable working with students one-on-one or in small groups, and am able to adapt my teaching style to meet the needs of each individual. I am patient and supportive, and my goal is to help my students succeed.
I have a strong background in math and science, and have tutored students in these subjects at all levels, from elementary school to college. I have also helped students prepare for standardized tests such as the SAT and ACT. In addition to academic tutoring, I have also worked as a swim coach and a camp counselor, and have experience working with children with special needs.
0.00
0 Reviews
10+ Question Solved
Related Book For
Core Concepts Of Accounting Information Systems
ISBN: 9781118738108
1st Canadian Edition
Authors: Mark G. Simkin, Carolyn A. Strand Norman, Scott Paquette
Question Posted:
Students also viewed these Business questions
-
Customer profitability in a manufacturing firm. Bizzan Manufacturing makes a component they call P14-31. This component is manufactured only when ordered by a customer, so Bizzan keeps no inventory...
-
Customer profitability in a manufacturing firm. Bizzan Manufacturing makes a component called P14-31. This component is manufactured only when ordered by a customer, so Bizzan keeps no inventory of...
-
The following represent errors that could occur in a computerized environment. Required For each error, identify a control procedure that would have been effective in either preventing or detecting...
-
A steam generator consists of a bank of stainless steel (k = 15 W/m K) tubes having the core configuration of figure and an inner diameter of 13.8 mm. The tubes are installed in a plenum whose...
-
What frequency is one octave above 5 kHz? b. What frequency is one decade below 10 kHz? c. What frequency is two octaves below 20 kHz? d. What frequency is two decades above 1 kHz?
-
The headline of an August 21, 2005 article in the New York Times was Its the Simple Things, but Some Hospitals Dont Do Them. Use the Quality of Care section to discuss and explain why hospitals may...
-
In 2014, Air Asia Flight No. 8501 crashed in the Java Sea while flying from Indonesia to Singapore. The crash resulted in the deaths of all passengers and crew on board. The plane involved in the...
-
Avaya Corporation had the following stock outstanding from 2011 through 2014: Preferred stock: $100 par value, 8 percent cumulative, 5,000 shares authorized, issued, and outstanding Common stock: $10...
-
What are the capabilities of online analytical processing (OLAP)? What is the value of this tool to business? Is OLAP much different from data mining and warehousing? Explain..!
-
Lydia Hartley, manager of UltraProducts New Zealand Division, is trying to set the production schedule for the last quarter of the year. The New Zealand Division had planned to sell 100,000 units...
-
Use the Web to find current examples of OLAP. Why do companies use OLAP? What is the connection between OLAP and databases?
-
1. Assume you are the director of the State Department of Mining and Reclamation and were informed of the findings on the new samples versus the old samples. What actions would you direct your staff...
-
Match each equation with the graph of f, g, h, or k in the figure. (A) y=(1/4)x (B) y=(0.5)x (C) y=5X (D) y=3X y h k
-
1. Discuss new technologies thatshould be implemented today and in the near future to support first responder safety practices. 2.How can the government partner with private industry to improve first...
-
Problem 1: 12 Cabins, 12 Vacancies (4 points) Bates Motel, Inc. is incorporated and headquartered in State Z. It owns and operates several hotels in several states and reports the following...
-
Locate the code of ethics online for Apple. Discuss the impact of the code of ethics on day-to-day operations for Apple? What are the costs of compliance Apple? What are the costs of non-compliance?...
-
Sometimes the governments of free market countries try to control prices to support an industry rather than the functions of supply and demand. For example, the US government supports various...
-
Analyze, and discuss the logistics services listed below and give a practical example that has been practiced in any organization/company/business. You are required to provide as many examples as you...
-
You have $250,000 to invest in a stock portfolio. Your choices are Stock H, with an expected return of 13.5 percent, and Stock L, with an expected return of 9.8 percent. If your goal is to create a...
-
What are current assets and current liabilities? How are they different from non-current assets and non-current liabilities?
-
Search the web for unusual and interesting uses of RFID tags. Find at least two that are unusual and share those with your classmates.
-
How do you feel about RFID tags? Do you think they offer more advantages or disadvantages? Identify the various advantages and disadvantages. Do you support the use of RFID tags for personal ID? Why...
-
Listed below are several types of accounting data that might be coded. For each data item, recommend a type of code (mnemonic, sequence, block, or group) and support your choice. a. Employee...
-
The answer of the fiurth line is not 4, 8, 32 or 40. I just need the answer for the fourth line Question 1 Memory Allocation SUBMITTED How much memory (in bytes) is taken up by the following...
-
Critical Thinking 10-7: Dynamic Mobile Access There are so many opportunities now for people to allow constant and dynamic connection between their mobile phone and an external (often unregulated)...
-
In Matlab, create a code that puts the value three-halves pi radians, 3 ????, in a variable named "angle". Then set another variable named angleDegrees equal to a calculation that converts the value...
Study smarter with the SolutionInn App