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+
137+ Reviews
431+ 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...
-
A highway department is considering building a temporary bridge to cut travel time during the three years it will take to build a permanent bridge. The temporary bridge can be put up in a few weeks...
-
Which of the following information system functions is generally responsible for the design, coding, and debugging of computer programs? (a) technical support (b) programming (c) operations (d)...
-
America Online published a survey question. Among the 2,300 Internet users who responded, 20% answered "yes" and the others answered "no." For the "yes" responses, what is the value of /5? What is...
-
Project A is to be closed and all equipment scrapped in year 10.At that point, Project A has a salvage value of $2,000,000 and book value of $200,000.The tax rate is 27%, and the firm's WACC is...
-
In December, Northern Kiteboarding magazine collected $80,000 for subscriptions for the next calendar year. The company collects cash in advance and then downloads the magazines to subscribers each...
-
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...
-
SpringFresh charges its customers $1.50 per pound laundered, regardless of the items to be cleaned. SpringFreshs variable costs equal $0.50 per pound laundered, with fixed costs amounting to $50,000...
-
Suppose Die Cast Aluminum Co. is a subcontractor for the auto industry and makes specialized auto parts. There is a bracket it manufactures that it sells for $1.00. The following table shows the...
-
Sunia is a senior lending officer at the ANZ Bank. He would like to develop a model that predicts defaults in loan payment. He insists that his model must include both accounting information and...
-
How does magical realism blur the lines between fantasy and reality, and what cultural or philosophical meanings might this genre convey in postcolonial contexts ?
-
Use the Fisher Equation to answer the following: i) (3pts) Assuming the nominal rate of interest is 2%, can the ex-post real interest rate be greater than 2%? Explain. ii) (3pts) Assuming the...
-
How would you define Viral marketing and Affiliate Marketing ?What impact might cookie deletion have on an affiliate marketing campaign?
-
Write down how you would answer one of the following interview questions using the STAR method: (a) Can you tell me about a challenge you overcame at work? (b) Can you give me an example of how you...
-
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...
-
The most likely outcomes for a particular project are estimated as follows: Unit price: $ 4 0 Variable cost: $ 2 0 Fixed cost: $ 3 5 0 , 0 0 0 Expected sales: 3 4 , 0 0 0 units per year However, you...
-
Rent of the land will be 2800 per month. The rent of the building with all the facilities installed is estimated in 24,000 per year, with council tax charges estimated at 15,000 per year. The rent of...
-
Further to the lesson discussions and readings about the Sales and Operations Planning Process, provide your argument for the value of this process applied to a CPG (Consumer Packaged Goods) company....
Study smarter with the SolutionInn App