Draw an rea diagram of the computer warehouses revenue cycle

Assignment Help Management Information Sys

Reference no: EM132328729

Part I

Complete problems 17.3 and 17.4; please use VISIO to devise your solution and submit a VISIO File.Hint: Use the example of Figure 17-6 screenshot below to guide your solution for these problems. Following this format, you are not required to label any relationship between two entities. (In other words, no label need be written on the line drawn between two entities. You must include cardinalities.)

Problem 17.3: Sue's Gallery sells original paintings by local artists. All sales occur in the store. Sometimes customers purchase more than one painting. Individual customers must pay for purchases in full at the time of sale. Corporate customers, such as hotels, however, may pay in installments if they purchase more than 10 paintings. Although Sue's Gallery has several bank accounts, all sales monies are deposited intact into the main checking account.

Required>Draw an REA diagram for the gallery's revenue cycle. Be sure to include cardinalities.

Problem 17.4: Sue's Gallery only purchases finished paintings (it never commissions artists). It pays each artist 50% of the agreed price at the time of purchase, and the remainder after the painting is sold. All purchases are paid by check from Sue's main checking account.

Required>Draw an REA diagram, complete with cardinalities, of the gallery's expenditure cycle.

Part II

Complete problems 17.8, 17.9, and 18.6; please use VISIO to devise your solution and submit a VISIO File.

Problem 17.8:Prepare an integrated REA diagram that covers both the revenue and expenditure cycles for Computer Warehouse (as described in Problems). Pay close attention to cardinalities.

The Computer Warehouse sells computer hardware, software, and supplies (such as paper). Individual customers just walk into the store, select merchandise, and must pay for their purchases in full before leaving the store. Corporate customers, however, call in orders in advance, so that the items are waiting to be picked up. Corporate customers may charge their purchases to their account.

The Computer Warehouse mails corporate customers monthly statements that summarize all purchases made the prior month. Corporate customers pay the entire balance, as listed on the monthly statement, with one check or EFT transaction.

Problem 17.9: Draw an REA diagram of the Computer Warehouse's revenue cycle, complete with cardinalities.

The Computer Warehouse purchases its inventory from more than a dozen different vendors. Orders are placed via telephone, fax, or on the supplier's website. Most orders are delivered the next day. Most orders are filled completely in one shipment, but sometimes a supplier is out of stock of a particular item.

In such situations, the bulk of the order is shipped immediately and the out-of-stock item is shipped separately as soon as it arrives (such shipments of back orders are never combined with any new orders placed by the Computer Warehouse).

The Computer Warehouse pays for some of its purchases C.O.D. but usually pays by the 10th of the month for all purchases made the prior month. None of its suppliers allow it to make installment payments.

Problem 18.6: Draw an REA diagram for this database. State any additional assumptions you need to make about cardinalities.

Refer to Problems 17.8 and 17.9 for information about the revenue and expenditure cycles for the Computer Warehouse and use that information to draw an integrated REA diagram for both cycles.

Part III

Using the diagram you prepared in Part II, complete problem 18.7

Problem 18.7: Develop a set of tables to implement the integrated REA diagram you developed in Problem 18.6 for the Computer Warehouse in a relational database. Specify a primary key for each table, and suggest at least one other attribute that should be included in each table.

Reference no: EM132328729

Questions Cloud

What is expected value from buying a used car : If all cars of both kinds are sold, what is your expected value from buying a used car? Let µ denote the probability of buying a good car

Imposed a temporary ban : Russian state television has imposed a temporary ban on all TV commercials. Your firm specializes in exports to Russia.

Federal reserve as an independent agency : Why did the U.S. Congress establish the Federal Reserve as an independent agency?

Hat supportive interventions within cc model address issues : What supportive interventions within the CC/IC model address such issues? In addition, consider how successful health care models assume an understanding.

Draw an rea diagram of the computer warehouses revenue cycle : The Computer Warehouse mails corporate customers monthly statements that summarize all purchases made the prior month.

Discuss the pros and cons of psychosurgery with patients : Discuss the pros and cons of psychosurgery with patients who might be violent, antisocial, or capable of criminal acts.

Define reliability and generalizability of research findings : Prior to beginning work on this written assignment, be sure to carefully review the instructions for the Final Assignment, which is due at the end of Week Six.

What challenges you face conducting a family therapy session : What is your experience conducting a family therapy session? What did you learn from that experience? If you have not conducted a family therapy session.

Health information portability and accountability act : Compare the positive and negative elements of Health Information Portability and Accountability Act. Define the health care system in your own words.

User Account

All Pages