List the entities and their attributes

Assignment Help Management Information Sys
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.

Reference no: EM13751873

Questions Cloud

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..

Reviews

Write a Review

 

Management Information Sys Questions & Answers

  Define each of the following- mis tps dss and ai

Information systems typically support different work models. You have been asked to create a report on what work models exist, and which model is most applicable to your organization. Define each of the following: MIS, TPS, DSS, and AI

  Check the existing supply chain management process

Check the existing supply chain management process in Starbucks and Describe the flow materials , the organizations functions and the customers it serves.

  Differences between operating systems for personal

differences between operating systems for personal computerswhat are the fundamental differences between windows macos

  Explain what are major forms of computer crime

What are major forms of computer crime and What are some of the current ways that police and other officials are using to track the criminals and enforce the laws?

  Explain factors necessary to ensure referential integrity

Determine and explain the factors necessary to ensure referential integrity. Create an object-oriented model to show how the tables are interrelated through the use of graphical tools such as Microsoft Visio, or an open source alternative such as D..

  Forecasting methods explained in this solutionhello thank

forecasting methods explained in this solutionhello thank you for taking the time to look and consider my posting on

  Personal computers in business

PDAs will replace personal computers in business -  information appliances like PDAs will replace personal computers in business applications? Explain.

  Expenditure and production cyclesresearch the fundamental

expenditure and production cyclesresearch the fundamental processes that occur within the expenditure and production

  Using the following data regarding hospital monthly

1. using the following data regarding hospital monthly expenditures in 000s of dollars evaluate normality. are the

  Show the developments in telecommunications

This solution shows the major developments in telecommunications technologies and describes their effects on the industry.

  Cio and implementing changehow is the cio responsible for

cio and implementing changehow is the cio responsible for implementing change in the business units? what role should

  Does it matter what data is stored on your disk drive

Suppose you lose your company laptop at an airport. What should you do? Does it matter what data is stored on your disk drive

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd