Consider a mail order business in which employees take orders or parts from customers. Create a conceptual using the following i
nformation.
a. The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code.
b. Each customer of the company is identified by a unique customer number, first and last name, and Zip Code.
c. Each part sold by the company is identified by a unique part number, a part name, price and quantity in stock.
d. Each order placed by a customer is taken by an employee and is give a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded.
Required:
Design an ER (Entity-Relationship) diagram for the mail order database and build the design using a data modeling tool such as ERwin or Rational Rose.
a. The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code.
b. Each customer of the company is identified by a unique customer number, first and last name, and Zip Code.
c. Each part sold by the company is identified by a unique part number, a part name, price and quantity in stock.
d. Each order placed by a customer is taken by an employee and is give a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded.
Required:
Design an ER (Entity-Relationship) diagram for the mail order database and build the design using a data modeling tool such as ERwin or Rational Rose.
1 answer:
You might be interested in
Answer:
$4.00
Explanation:
Data provided:
Direct material costs in beginning Work-in-Process Inventory = $500
worth of materials is added during the month = $1,500
Equivalent units for direct materials = 500 units
Now,
the total cost incurred
= Direct material costs in beginning Work-in-Process Inventory + worth of materials is added during the month
= $500 + $1,500
= $2,000
Now,
The Cost per equivalent unit for direct materials
=
The Cost per equivalent unit for direct materials =
or
The Cost per equivalent unit for direct materials = $4.00