Reference no: EM13751873
ONLINE ORDER INFORMATION SYSTEM
A common business document is and order form. Orders are an integral part of any sales data base. In this exercise we will build an ER Diagram to represent the entities, attributes and relationships of a common order.
Consider the following sample order
Sample order form
ORDER NUMBER: __0500260____ DATE 01/24/2015
FROM: Acme Manufacturing Cust ID: A231
240 Broward Boulevard
Yuma, Arizona 89026
C/o Wiley Coyote
SHIP TO:
ITEM # QTY Cat. # DESCR. UNIT PRICE
1 16 135608 Canon Balls $ 54.99
2 100 982345 dynamite sticks $ 5.89
3 1 359265 Road Runner trap $249.99
Total Price $1718.83
In this sample we can see that there is;
1. Information about the order
2. Information about the customer
3. Information about the items ordered.
Exercise:
1. List the entities and their attributes.
2. List any relationships that may exit. Name the entities and the relationship
3. Assign cardinality to each relationship.
4. Draw the ER diagram.
|
Purpose of human-made genetic recombinations in food
: Genetically modified food. What is the purpose of human-made genetic recombinations in food? Are foods that contain genes resulting from artificial genetic recombinations really safe? What foods in your supermarket result from genetic recombination? ..
|
|
Write essay on ulrich von liechtenstein service of ladies
: Write essay on Ulrich von Liechtenstein Service of Ladies. In your own words, what do the key themes of this document tell us about values of the society that produced it?
|
|
Presentation of heb store loyalty program
: Three (3) Slides PowerPoint presentation of HEB store Loyalty Program. Include bullet point with a speaker notes and references
|
|
Application base was manufacturing overhead under
: Sinclair Company manufactures a line of lightweight running shoes. CEO Andrew Sinclair estimated that the company would incur $3,198,890 in manufacturing overhead during the coming year. Using direct labor hours as the application base was manufactur..
|
|
List the entities and their attributes
: A common business document is and order form. Orders are an integral part of any sales data base. List the entities and their attributes
|
|
Job order costing system
: Lucy Sportswear manufactures a line of specialty T-shirts using a job order costing system. In March the company incurred the following costs to complete Job ICU2: direct materials, $13,100, and direct labor, $4,000. The company also incurred $1,330 ..
|
|
Taxable income and the tax rate remains
: In 2014, its first year of operations, Kimble Corp. has a $770,000 net operating loss when the tax rate is 35%. In 2015, Kimble has $320,000 taxable income and the tax rate remains 35%.
|
|
Review the project management email
: Review the Project Management email, Write an email response in which you address the following points:
|
|
In regards to a business combination
: IN regards to a business combination, in which all the assets and all the liabilities (asset acquisition of a company are obtained, in "Investment - xxx" account is not debited in the initial journal entry, by the acquirer to record the business comb..
|