Reference no: EM131357249
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.
|
What is the minimum cost of crashing
: What is the minimum cost of crashing the following project that Roger Solano manages at Slippery Rock University by 4 days
|
|
What is the importance of an e-r diagram
: What is the importance of an E-R diagram in facilitating event-driven systems and the integration of data between business processes?
|
|
Write a summary of the implications for nursing practice
: DNP graduates are expected to apply research findings and integrate nursing science into evidence-based practice. To develop your ability to engage in this high level of nursing practice, you will analyze the strengths and weaknesses of a research..
|
|
Relate the notion of ontological shock
: Relate the notion of ontological shock to a time when your worldview was shaken. How did you respond to the shock? Did it make you morally sensitive and more likely to act upon your moral beliefs?
|
|
Create the structure for the records in the customer file
: 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 n..
|
|
Analyze your target audience
: Analyze your target audience. Who do you need to share your professional brand with in order to achieve your professional goals? Is it a specific company?
|
|
Explain the main purpose and scope of the cited work
: A total of four annotated bibliographies are to be submitted (not to exceed one page each). The articles must come from nursing scholarly literature and may not be older than 5 years since publication. Please note that the articles must be researc..
|
|
Write a procedural email message to employees
: Write a procedural email message to employees reminding them of standard operating procedures or organizational changes that take the form of step-by-step instructions
|
|
Write the 3 quality problems and what led to issue at hand
: Read the article.- The article is : "Chipotle Eats Itself" - write the 3 quality problems and what led to the issue at hand?
|