Create the structure for the records in the customer file

Assignment Help Computer Engineering
Reference no: EM131356958

REQUIRED: Using the database software indicated:

a. Create the "structure" for the records in the customer file. Use given Figure 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 given Figure (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.

382_Figure 00.jpg

Reference no: EM131356958

Questions Cloud

What is the bottleneck time : A production process at Kenneth Day Manufacturing is shown in Figure. The drilling operation occurs separately from, and simultaneously with, sawing and sanding, which are independent and sequential operations. What is the bottleneck time
Explain which approaches you would be most comfortable using : Identify the six possible approaches to the way in which the design work can be organized. Explain which approaches you would be most comfortable using.
Compute the? bond yield to maturity : ?(Bond valuation? relationships) The 17?-year, ?$1,000 par value bonds of Waco Industries pay 7 percent interest annually. The market price of the bond is ?$1,135?, and the? market's required yield to maturity on a? comparable-risk bond is 4 percent...
Calculate the predetermined overhead rate : Calculate the predetermined overhead rate that would be used under traditional overhead costing - Calculate the product cost per unit for the Basic and Advanced products under traditional costing
Create the structure for the records in the customer file : Create the "structure" for the records in the customer file. Use given Figure as a general guide to the data elements to be included in the customer records. However, observe the following specific requirements:
How the selected company can establish hrm strategies : Determine which HR job positions you would prefer and explain why. Analyze how the selected company can establish HRM strategies to improve competitive advantages.
What is the throughput time of the new work cell : The Pullman Mfg., Inc., three-station work cell illustrated in Figure has two machines at station 1 in parallel. What is the throughput time of the new work cell? What is the bottleneck time of the new work cell
What must the risk-free rate be : A stock has an expected return of 15.9 percent, a beta of 1.70, and the expected return on the market is 10.10 percent. What must the risk-free rate be?
What is target variable cost per mouse : A company believes it can sell 5,600,000 of its proposed new optical mouse at a price of $10.00 each. There will be $8,000,000 in fixed costs associated with the mouse. If the company desires to make a profit $2,000,000 on the mouse, what is the targ..

Reviews

Write a Review

 

Computer Engineering Questions & Answers

  What protocol information would be in one packet

Will the protocol packet used to transfer the video be identical to the protocol packet used for data transmission? What protocol information would be in one packet and not the other?

  Factors for building a server room

Explain the factors you must consider for each of the following given topics: Walls and doors, Access control

  Determining average degree of vertex

For the random geometric graph, G(n, r), determine the average degree of the vertex: At least distance r from the boundary,

  Create set of use case for an university registration system

Create a set of use cases for an online university registration system. The system should enable the staff of each academic department to examine the courses offered by their department.

  What changes arc needed in figure to convert

What changes arc needed in Fig. to convert it to a serial subtractor that subtracts the content of register B from the content of register A?

  What is the idea to observe multiple print queues

What is the idea to observe multiple print queues

  Design a combinational verilog module

The starter code from the course web page includes test benches for each problem below. For each of the following, please submit the source code for your Verilog module along with a printout or screen capture of waveform plots indicating a success..

  Assigning the link password

Bob has forgotten his password. Allocate him a password of LINK and require that the Bob change his password next time he logs on.

  What is largest and smallest number that can be represented

What is the value n, the smallest number of bits needed to represent all of these numbers in 2's complement representation? What is the largest and smallest number that can be represented?

  What constitutes a well-maintained system

What constitutes a well-maintained system, in terms of function, utility, and reliability and how does the truly effective SysAdmin ensure success?

  Take a position on the idea of ipv6 being hailed as the

take a position on the idea of ipv6 being hailed as the next generation of the internet. support your response with

  How is the approach in health informatics and health

how is the approach in health informatics and health information technology different and how is this difference

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd