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

Previous Q& A

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

  What is the balance in agees equity investment account

Agee Corporation acquired a 38% interest in Trent Company on January 1, 2015, for $480,000. At that time, Trent had 1,000,000 shares of its $1 par common stock issued and outstanding. During 2015, Trent paid cash dividends of $154,000 and thereafter ..

  Define the characteristics of the segment

How Argyle did changed the Problem into an Opportunity and define the characteristics of the segment chosen by applying the relevant theory?

  State department of revenue and additional sales taxes

Based on retail sales estimates from the state Department of Revenue, additional sales taxes were accrued in the amount of $40,000.  On December 31, 2014, $500 of interest was accrued on the investment in Treasury notes. Fair market value of these no..

  Taxes receivable-sales-interest receivable on investments

An November 2014, the 3% certificates of deposit matured; the face amount of $1,000,000 plus interest of $15,000 was collected. The interest is considered revenue of the Street Improvement Fund.

  Explain abigail adams views on women rights

Explain Abigail Adams views on women rights. What were her religious views? Compare her religious views with those of Jefferson?

  Manufactures ultra sound equipment

Laconic Company manufactures ultra sound equipment. Based on past experience, Laconic has found that total annual repair and maintenance cost can be represented by the following formula: total annual repair and maintenance cost = $205,000 + $7.50x, w..

Reviews

Write a Review

 

Similar Q& A

  Effectiveness of different software products

The Efficiency and Effectiveness of Different Software Products and I need to include the specific problem that Apple is having and include questions in the problem statement.

  Network topologies and diagnostics

What topology would work best for this project and What network hardware will be needed to accomplish the networking project

  What is the typical it implementation process

What is the typical IT implementation process? What are the roles and responsibilities involved in system implementation, How did the process described in the case study fail to include the fundamental activities identified of Health Care Informati..

  Compare between the various types of information systems

Discuss how Porter's competitive forces model and the value chain model support the organizations in utilizing the information systems as competitive edge.

  Managerial accounting case studies1 the opening paragraph

managerial accounting case studies1. the opening paragraph of an accounting textbook says managers need accounting

  Political aspects of a decision to outsource

Global Information System Organizations and financial and political aspects of a decision to outsource?

  Advantages of increased connectivity

Increased connectivity - advantages of increased connectivity

  Show the production and operations management

Production and Operations Management: change, supply chain, decisions, applications - Write a short essay explaining what you have learned from this course, what aspects of the course benefited you the most

  Change and leadership characteristicsdefine a change

change and leadership characteristicsdefine a change discuss the kinds of leadership characteristics you believe are

  Show the effective application of standard human resource

Show the effective application of standard human resource practices in small to mid-sized manufacturing enterprises (SMEs), and the ways in which they differ from HR practices in large corporations.

  Explain how to maintain database integrity

How to maintain Database Integrity - Explain how database integrity can be maintained

  What is the cycle time

How many gears should be produced in each run and at what minimum cost and what is the cycle time?

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