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+
134+ Reviews
427+ 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...
-
The unadjusted trial balance of Tenterfield Tree Specialist, which keeps trees healthy or remove them if they cannot be saved, appears as shown below. Ignore GST. Additional information 1. Expired...
-
a. Using algebra, establish an alternative expression \[b_{1}=\frac{\sum_{i=1}^{n} \text { weight }_{i} \times \text { slope }_{i}}{\sum_{i=1}^{n} \text { weight }_{i}} .\] Here, slope \(_{i}\) is...
-
Katie Davis is contemplating paying five years rent in advance. Her annual rent is $12,600. Calculate the single sum that would have to be paid now for the advance rent. Assume compound interest of 8...
-
Assume A and B are connected via a direct link of bandwidth B bps. Let the one-way propagation delay be equal to T, sec. The maximum frame size is equal to P bits. The receiver B has an infinite...
-
For each of the following pairs of related entities, indicate whether (under typical circumstances) there is a one-to many or a many-to-many relationship. Then, using the shorthand notation...
-
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...
-
George has $96,200 in salary from his full-time position and $43,000 in net income in 2019 from his sole proprietorship. What is his self-employment tax? What portion of this can he deduct?
-
Write a one page document that explains your strategy for acquiring resources in the simulation and in real life? Use of proper APA formatting and citations. If supporting evidence from outside...
-
References : Hudson, M (2009) Managing Without Profit, UNSW Press: Sydney (see Chapters 6 & 9) . Robbins et al., (2019) Management: the essentials (4 th Ed.) Pearson Australia: Melbourne (see Chapter...
-
what are the measurements and measures 2. what are the 5 details of the study 3. what are the research strategies ,extensive researcher interference study setting, analysis and time horizon the...
-
The Conference Board reported that between 1987 and 2009, four key indicators of job satisfaction declined dramatically; (a) interest in their work, down 18.9 percent; (b) job security, down 16.5...
-
Zach and the hospital board of directors are concerned about the organizational culture in the emergency department. Zach has asked you to recommend ways to improve the organizational culture and to...
-
Traditional free-trade theory is basically a static theory of international exchange leading to certain conclusions about the benefits likely to accrue to all participants. Explain the dynamic...
-
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...
-
How Effective human resource management and organizational behavior as they relate to organizational design? Explain briefly
-
Locate several classified ads from the web and/or the Sunday help wanted ads and find one of your choosing. - Analyze the effectiveness of one of these ads you have picked; you only need to analyze...
-
Please complete the problems below. Make sure to show the formulas you used and your calculations. Each problem is worth up to 3 pts. Problem #1 Selling price per uint 50 Unit...
Study smarter with the SolutionInn App