Give some examples of field names that you would use for the Customer table in Figure. What
Question:
Transcribed Image Text:
Customer Order Table (Event Order # Employee # Customer # Date Comments 1003 1004 1005 1006 M24SP B104 P202 01/03/02 Ship ASAP 01/03/02 M24SP W11SP 01/03/02 01/03/02 Inventory Table Item # Description Unit Cost Sales Price Beg QOH 1400 Goodie Bar 1500 Almond Delight S0.25 1600 Gummy Lions $0.60 1700 Pecan Bar 1800 Milky Bars $0.40 $0.45 $0.95 $1.09 $0.30 8 20109 S0.70 S0.18 Customer Table (Agent) Customer # Name Address City State Zip Code Credit Limit A101 B104 C100 Amanda Wills 22 Yellow Ln. Chatte NC 79803 $20,000.00 Boris Bailey 321 Church St. Oxford Carly Riccardi 1899 Green St. Dayton OH 4329910,000.00 Peggy Martin 1260 Main St. Columbus OH 43320 Bill Safer OH 45056 860 Broad St. Fairfax VA 22030 5,000.00 Salesperson Table( Employee # Name Address City State Zip Code Dept ID Date Hired Sally Anderson 3026 Skye Ln. Columbus OH 43213 247 1/31/1989 Randy Mer 262 Main St. Bexley Barry Rogers 80N. Long St Gahanna OH 43215 247 1/16/2001 Jim Rudolph 64 Lantern Ave. Columbus OH 43213 John Walker 028 Fields Ln. Lancaster OH 43307 OH 43209 182 7/2/1999 W11SP 182 9/1/1992
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 69% (13 reviews)
Here are some characteristics of data fields for the Customer Table of Figure 46 Data field Data typ...View the full answer
Answered By
Ishrat Khan
Previously, I have worked as an accounting scholar at acemyhomework, and have been tutoring busines students in various subjects, mostly accounting. More specifically I'm very knowledgeable in accounting subjects for college and university level. I have done master in commerce specialising in accounting and finance as well as other business subjects.
5.00+
139+ Reviews
432+ Question Solved
Related Book For
Core Concepts Of Accounting Information Systems
ISBN: 9780470507025
11th Edition
Authors: Nancy A. Bagranoff, Mark G. Simkin, Carolyn Strand Norman
Question Posted:
Students also viewed these Accounting questions
-
Give some examples of how technology is creating employer/employee rights and policy issues. Then suggest some possible actions that may be needed.
-
What is an activity? Give some examples of activities within a manufacturing firm.
-
What are database cardinalities? Give some examples of such cardinalities for an accounting application other than sales.
-
A particle is described by the normalized wave function (x, y, z) = Axe-ax2 e -y2 e-yz2', where A, a, , and are all real, positive constants. The probability that the particle will be found in the...
-
Journalize the following investment transactions of Vantage Inc.: 2014 Aug. 6 Purchased 900 Rhodes Corporation common shares as a long-term investment, paying $90.00 per share. Vantage Inc. exerts no...
-
As of June 30, 2018, the bank statement showed an ending balance of $19,500. The unadjusted Cash account balance was $15,200. The following information is available: 1. Deposit in transit, $2,400. 2....
-
Martina Bridgeman is a lawyer employed bya large law firm at $90,000 per year. She is considering whether to become a sole practitioner, which would probably generate annually $320,000 in operating...
-
The following expenses were incurred by a merchandising business during the year. In which expense section of the income statement should each be reported: (a) Selling, (b) Administrative, or (c)...
-
Which of the following tax materials is a legislative source? Income Tax Folios Information Circulars Income Tax Act Advance Income Tax Rulings
-
Fiske Corporation manufactures a popular regional brand of kitchen utensils. The design and variety have been fairly constant over the last three years. The managers at Fiske are planning for some...
-
This chapter described how to create tables and records in Microsoft Access. What other database management systems are available? Use the Internet to determine their current retail prices.
-
Identify the different data types available for creating data fields in Microsoft Access. Similarly, identify the different types of numbers (e.g., Long integer) you can use if you define a field as...
-
Identify the amplitude and period of the following functions. f() = 2 sin 2
-
1.Explain how tariffs work? 2.How can the lack of international competition impact prices in the United States? 3.Domestically, who benefits from tariffs? Who could tariffs be bad for? 3.Using the...
-
Give four principal reasons economies of scale can occur when output increases. Provide examples of each for a service firm.
-
Managers practice 4 fundamental functions: planning, organizing, leading, and controlling. As a manager moves higher in the organization, they are faced with broader responsibilities and use all 4...
-
Focusing on TAKT time, consider the following. a. You have product demand of 800 units per day. You currently work one 8-hour shift, with 7.5 real work hours. What is your TAKT time? b. Your demand...
-
Make a PowerPoint infographic of 3 different logic controllers used in PLC programming. Include an example of the logic controller in a ladder logic set up, how it is working, and what function is...
-
If an international business firm has separate vice presidents in charge of its Asian, African, and European divisions, it is most likely using a global ____________ structure. (a) product (b)...
-
Consider the setup in Problem 16. Show that the relative speed of the ball and the point of contact on the stick is the same before and immediately after the collision. (This result is analogous to...
-
Repeat Problem 3-4 for 4 x 4 tic-tac-toe, which is played on a four-by-four grid. Assume that the numbering pattern is left to right and top to bottom, as in Problem 3-4. Problem 3-4 A simple...
-
Pherigo Co. uses special journals and a general journal. The following transactions occurred during May 2010. May 1 I. Pherigo invested $50,000 cash in the business. 2 Sold merchandise to B. Sherrick...
-
Wick Company uses the columnar cash journals illustrated in the textbook. In April, the following selected cash transactions occurred. 1. Made a refund to a customer as an allowance for damaged...
-
Velasquez Company has the following selected transactions during March. Mar. 2 Purchased equipment costing $9,400 from Chang Company on account. 5 Received credit of $410 from Lyden Company for...
-
On January 1, 2021, the general ledger of Tripley Company included the following account balances: Accounts Debit Credit Cash $286,000 Accounts receivable 76,000 Allowance for uncollectible accounts...
-
M12-14. Time Value of Money: Basics Using the equations and tables in Appendix 12A of this chapter, determine the answers to each of the following independent situations: a. The future value in three...
-
Adjust the Cash Balance We obtain the following 2018 forecasts of selected financial statement li $ millions 2017 Actual 2018 Est. $688,555 $720,440 Net Sales Marketable securities 67,096 62,096...
Study smarter with the SolutionInn App