Question: Using the REA model in Figure and your answers to Discussion Questions create a database for HIS in the software package of your choice. This

Using the REA model in Figure and your answers to Discussion Questions create a database for HIS in the software package of your choice. This will require that you do the following:

a. Create tables for each of the relations you identified in Discussion Question that include the attributes you identified in Review Question.

b. Insert a few tuples of sample data that you devise.

c. Print the data from each of the relations to test for successful implementation.

FIGURE 6.18 Partially Completed REA Model of the Hera Industrial Supply Sales

FIGURE 6.18 Partially Completed REA Model of the Hera Industrial Supply Sales Business Employees (Salespersons) Sales Orders Inventory Customers Sales Cash Receipts

Step by Step Solution

★★★★★

3.43 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Your solutions will vary depending on which database softwar... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

353-B-A-I-S (4484).docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

Your Block 1 for your Business Plan will require that you develop the following objectives which will be integrate part of the first five sections of the business plan. As a model and guide use the...

Consider the information in Problem 4-7 and your answers to that question. Suppose that the market clearing price of Pakistani wheat in the absence of price supports is equal to $0.10 per kilogram....

Review Figure 42, which shows the smart phone attributes identified by Consumer Reports. Which attributes are important to you? What other attributes might you consider? Which brand would you prefer?

\f \f11TH EDITION STRATEGIC MANAGEMENT THEORY 11TH EDITION Strategic Management THEORY Charles W. L. Hill University of Washington - Foster School of Business Gareth R. Jones Melissa A. Schilling New...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

Please help with the assigned discussion. The hyperlinks are attached. MY COMPANY IS WALMART Assigned Discussions: 1. Develop and explain a recommended corporate strategy for the selected company....

Overview This assignment requires you to convert a UML class diagram into a relational model, physically create tables in Microsoft Access, and enter data into the tables. The main purpose of this...

Resolving agency issues in client-contractor relationships Resolving agency issues in client-contractor relationships Resolving agency issues in client-contractor relationships A FACELIFT FOR A...

What is the optimal division of work between Pia and the accountant? Should Pia outsource all the accounting tasks, use selective outsourcing, or keep all tasks to herself? Evaluate each accounting...

SLHS 2890 School-Age Child Language Analyses Report Name: Directions: Review the two transcripts below and answer the questions that follow for each one. Type your answers directly onto this document...

The average zinc concentration recovered from a sample of measure- ments taken in 36 different locations in a river is found to be 2.6 grams per milliliter. Find the 95% and 99% confidence intervals...

_ accounting employs a body of standards known as generally accepted accounting principles. ( Enter only one word. )

Studies indicate that the price elasticity of demand for cigarettes is about 0.5. If a pack of cigarettes currently costs Rs.200 and the government wants to reduce smoking by 22 percent, by how much...

A piece of material is subjected to a tensile stress of 50 N/mm2 in one direction and compressive stress of 30N/mm2 in a direction perpendicular to the previous one. Find the stress on a plane the...

Consider a 1.2-m-high and 2-m-wide double-pane window consisting of two 3-mm-thick layers of glass (k=0.78W/m-C) separated by a 12-mm-wide stagnant air space (k=0.026 W/m-C). Determine (a) total...

Consider a large plane wall of thickness L=0.4 m, thermal conductivity k=2.3 W/m-C, and surface area A=30 m2. The left side of the wall is maintained at a 2. k constant temperature of T1=90C while...

Distinguish the standard of extrinsic force from the intrinsic force standard in the law of rape.

Listed below are several types of accounting data that might be coded. For each data item, recommend a type of code (mnemonic, sequence, block, or group) and support your choice. a. Employee...

Novelty Gadgets is a marketer of inexpensive toys and novelties that it sells to retail stores, specialty stores, and catalog companies. As an accountant working for the company, you have been asked...

Figure is a system flowchart for P. Miesing and Companys purchase order event. Prepare a narrative to accompany the flowchart describing this purchase order event. Include in your narrative the...

The OASDI program pays disability benefits to a disabled worker and eligible family members. Explain whether each of the following persons would be eligible for disability-income benefits. In each...

I need the solution please You just started your first job. You want to start saving so that you can be ready for marriage in four years. To determine how much you should save, you calculate the...

Phoenix Industries has pulled off a miraculous recovery. Four years ago it was near bankruptcy. Today, it announced a $2 per share dividend to be paid a year from now, the first dividend since the...