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

Could you please explain this question for me pretty

Could you please explain this question for me? Pretty struggle with it right now.    "The biggest four banks in Australia are too big to fail. With reference to financial system stability, critique this statement."

Information provided on the stockholders equity section of

Information provided on the Stockholder's Equity section of a balance sheet: Common Stock; $10 stated value, 200,000 shares authorized, 100,000 shares issued and ?? shares outstanding $1,000,000 Market value per share of ...

Franks is looking at a new sausage system with an installed

Franks is looking at a new sausage system with an installed cost of $375,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped ...

Discuss the basic registration requirement for doing

Discuss the basic registration requirement for doing business with government contracting.

Cowcor copr makes yummy cheeseburgers and fries it has 16

COWCOR COPR makes yummy cheeseburgers and fries. It has $1.6 million in debt outstanding, equity valued at $2.3 million, and pays corporate income tac at a 39% rate. Its cost f equity is 13% and its cost of debt is 5%. A ...

A perpetual bond sells for 885 and pays a semiannual coupon

A perpetual bond sells for $885 and pays a semiannual coupon in the amount of $34. What is the annualized yield for the bond?

The books definition of financial leverage is nbspthe use

The Books definition of financial leverage is "  The use of debt in a firm's capital structure is called  financial leverage . The more debt a firm has (as a percentage of assets), the greater is its degree of financial ...

A financial system comprises financial institutions

A financial system comprises financial institutions, financial instruments and financial markets. In the context of the Australian financial system explain the role of each of the major regulators (the RBA, APRA, ACCC, a ...

Tcs company has just started to deposit 225 at the end of

TCS company has just started to deposit $225 at the end of each month into its employees retirement fund (i.e., the first deposit will take place one month from now). These deposits will continue for each employee until ...

If a stock has a beta coefficient of 8 and a required rate

If a stock has a beta coefficient of .8 and a required rate of return equal to 11%, while the market return is equal to 12.5%, what is the risk-free rate of return?

  • 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