Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Before starting this problem, you should consult the customer master file record layout in Figure 3.6 (page 76).
REQUIRED: Using the database software indicated by your instructor:

a. Create the "structure" for the records in the customer file. Use Figure 3.6 as a general guide to the data elements to be included in the customer records. However, observe the following specific requirements:

(1) Devise your own coding scheme for the "customer number."

(2) For the customer address, provide three separate fields, one each for street address, state, and ZIP code.

(3) Provide for two additional data elements that are not shown in Figure 3.6 (because they normally would be accessed from other files)-open sales orders and accounts receivable balance

b. If the software package supports a function to design input screens, create the screen format to be used for entering customer data.

c. Create hypothetical customer records and key the data into the database. The only design constraint is to use a variety of names, street addresses, states/ZIP codes, open sales order amounts, accounts receivable balances, and credit limits. (The number of records will be indicated by your instructor.)

d. Obtain a printout of the database records.

1720_0721b6eb-1a6b-48fb-9f46-df99d7ebca3d.png

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M92170105

Have any Question?


Related Questions in Basic Finance

Question - analyze cash budgets inventory management and

Question - Analyze Cash Budgets, Inventory Management and Accounts Receivables Instructions - Assume the role of a manufacturing financial controller where you are making a presentation to the board of directors. Create ...

Brenda wants to invest in a bank cd that will pay her 626

Brenda wants to invest in a bank CD that will pay her 6.26 percent compounded quarterly. How many years will it take to triple her initial investment?

Groceries inc is specialized in the distribution of

Groceries, Inc. is specialized in the distribution of groceries. NS Groceries is considering expanding into a new line of business by adding coffee shops (the coffee venture) to its existing groceries retail locations. C ...

How can businesses use technology and relationships to

How can businesses use technology and relationships to reduce their environmental impact?

Section a discussion questions1- give two examples related

SECTION A: DISCUSSION QUESTIONS 1- Give two examples related to your discipline that you may face imbalance data in classification techniques. How you approach to handle imbalance data? You need to provide detail explana ...

You need 5000 to buy a new stereo for your car if you have

You need $5,000 to buy a new stereo for your car. If you have $1,500 to invest at 6% compounded annually, how long will you have to wait to buy the stereo? All work and formulas leading up to the answer have to be shown

Based on the data provided here calculate the items

Based on the data provided here, calculate the items requested: Annual depreciation $2,500 Current year's loan interest $650  Insurance $680  Average gasoline price $3.50per gallon Parking/tolls $420  Annual mileage 13,2 ...

How to find efffective annual rate of interest the terms of

How to find efffective annual rate of interest. The terms of sale are 4/10, net 49.  How to find the required rate of return on equity. ABC Inc.'s stock is currently selling for $69.97 per share. The company just paid it ...

A single person with a monthly taxable income of 2800 in

A single person with a monthly taxable income of $2800 in the 15% federal marginal bracket, has a state tax rate of 7.95% and social security taxes at 6.2%. This person forgoes consumption and instead places $230 into a ...

Eggsinc reported earnings available to common stock of

Eggs,Inc. reported earnings available to common stock of $4200000 last year. From these earnings, the company paid a dividend of $1.26 on each of its 1000000 common shares outstanding. The capital structure of the compan ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As