Homework Answers
For all one to many relationship create one table for each relation
Customer
| CustomerID | Name | Address | Phone |
Sale clerk, shipping clerk and cash receipts clerk have same properties, so one table Clerk is created for them. Each of the role is identified using Role.
Clerk
| ClerkID | Name | Address | Phone | Salary | Role |
Inventory
| ProductID | Name | Price | Descreption |
Relationship between take order and Inventory is many to many, so split details into two tables Order and ProductOrder as shown below
Order
| OrderID | OrderDate | CustomerID | ClerkID |
ProductOrder
| OrderID | ProductID | Quantity |
Reciept
| ReceiptID | Cash | ClerkID |
Relationship between ship order and Inventory is many to many, so split details into two tables Shipment and ProductShipment as shown below
Shipment
| ShipmentID | OrderID | ReceiptID |
ProductShipment
| ShipmentID | ProductID | ShipmentDate | ClerkID |
Add Answer to:
2. Convert the following REA diagram to tables by applying the conversion rules described in this...
At Kingston Industries, the revenue processes are conducted by five employees. The five employees are the...
At Kingston Industries, the revenue processes are conducted by five employees. The five employees are the sales clerk, warehouse clerk, accountant 1, accountant 2, and the collection clerk. A description of their duties is as follows: The sales clerk receives customer orders by phone. She prepares a four‐copy sales order form. She files one copy, one copy goes to the warehouse clerk, one copy goes to accountant 1, and one copy is mailed to the customer. After receiving a sales...
Identifying eight (8) significant control weaknesses in the process described below. Also, please include the associated...
Identifying eight (8) significant control weaknesses in the process described below. Also, please include the associated risk (i.e. What could go wrong?) of each control weakness. Business Process Description: Their processes rely mostly on manual processes and supported by some individual personal computers (PCs) running various applications. The sales process is described in the following narrative. All sales are made on credit whereby the cash receipt occurs later (not included in this exercise) Ole’s revenue process starts when a salesperson...
At Kingston Industries, the revenue processes are conducted by five employees. The five employees are the...
At Kingston Industries, the revenue processes are conducted by five employees. The five employees are the sales clerk, warehouse clerk, accountant 1, accountant 2, and the collection clerk. A description of their duties is as follows: A. The sales clerk receives customer orders by phone. She prepares a four-copy sales order form. She files one copy, one copy goes to the warehouse clerk, one copy goes to accountant 1, and one copy is mailed to the customer. B. After receiving...
Help with this problem, please. Conceptual Model: Draw an REA model with cardinalities for the operating...
Help with this problem, please. Conceptual Model: Draw an REA
model with cardinalities for the operating events, resources, and
agents in the Formula One inventory acquisition/payment process.
Please be sure to include cardinalities with your relationships on
the relationship lines, similar to the additional attachment I'm
including, thank you for all help. Please keep the resource
entities on the left, and the agents on the right-hand side, with
the events in the middle if you can use the additional attachment...
You are part of an accounting firm Advisory team that has been engaged by a client to assess how ...
You are part of an accounting firm Advisory team that has been engaged by a client to assess how they might make their “sales to order” process more “efficient”, perhaps with the introduction of new technologies. The client has provided a written description of their business, and the process under review, as follows: HHH is a small manufacturer of university based sportswear (a highly competitive market where fast response times are prized by customers). Sales span every region of the...
You are part of an accounting firm Advisory team that has been engaged by a client to assess how ...
You are part of an accounting firm Advisory team that has been engaged by a client to assess how they might make their “sales to order” process more “efficient”, perhaps with the introduction of new technologies. The client has provided a written description of their business, and the process under review, as follows: HHH is a small manufacturer of university based sportswear (a highly competitive market where fast response times are prized by customers). Sales span every region of the...
Heavy Equipment and Machinery Inc. Trial Balance At December 31, 2019
What is the answer to these tables? here is all the information that had been given to me and my answers to the question that I think needs to be answered to complete the two tablesYou have been hired as a Financial Consultant by Heavy Equipment and Machinery Inc. (HEMI). HEMI is a private corporation that has finished its first year of operations. HEMI's owners plan to list the business on the Toronto Stock Exchange (TSE) in the next 5 years; accordingly,...
Please read the article and answer about questions. You and the Law Business and law are...
Please read the article and answer about questions. You and the Law Business and law are inseparable. For B-Money, the two predictably merged when he was negotiat- ing a deal for his tracks. At other times, the merger is unpredictable, like when your business faces an unexpected auto accident, product recall, or government regulation change. In either type of situation, when business owners know the law, they can better protect themselves and sometimes even avoid the problems completely. This chapter...
At Kingston Industries, the revenue processes are conducted by five employees. The five employees are the sales clerk, warehouse clerk, accountant 1, accountant 2, and the collection clerk. A description of their duties is as follows: A. The sales clerk receives customer orders by phone. She prepares a four-copy sales order form. She files one copy, one copy goes to the warehouse clerk, one copy goes to accountant 1, and one copy is mailed to the customer. B. After receiving...
Help with this problem, please. Conceptual Model: Draw an REA
model with cardinalities for the operating events, resources, and
agents in the Formula One inventory acquisition/payment process.
Please be sure to include cardinalities with your relationships on
the relationship lines, similar to the additional attachment I'm
including, thank you for all help. Please keep the resource
entities on the left, and the agents on the right-hand side, with
the events in the middle if you can use the additional attachment...
What is the answer to these tables? here is all the information that had been given to me and my answers to the question that I think needs to be answered to complete the two tablesYou have been hired as a Financial Consultant by Heavy Equipment and Machinery Inc. (HEMI). HEMI is a private corporation that has finished its first year of operations. HEMI's owners plan to list the business on the Toronto Stock Exchange (TSE) in the next 5 years; accordingly,...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago