Write appropriate connectivities and cardinalities in erd

Assignment Help Management Information Sys
Reference no: EM13756965

1. Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. For each rule below, You may create one ER diagram (total 5 separate ER diagrams).

a. An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. The INVOICE table has the following fields: invoice_id, invoice_date, and inv_amount. the Salesrep table consists of salesrep_id, salesrep_last_name, salesrep_first_name, and salesrep_email.

b. The INVOICE is writtEsen for a single CUSTOMER. However, each customer can have many invoices. the CUSTOMER table consists of the following attributes: cust_id, cust_lasdt_name, cust_first_name, cust_email and cust_zip_code.

c. An INVOICE can include many detail lines (INV_LINE), which describe the products bought by the customer. The INV_LINE table consists of INV_LINE_NUM, INV_LINE_PRICE, INV_LINE_QUANTUTY, AND INV_LINE_TOTAL.

d. The product information is stored in a PRODUCT table, which consists of PRODUCT_CODE, PRODUCT_DESCRIPTION, PRODUCT_PRICE, and PRODUCT_QUANTITY.

e. The product's vendor information is found in a VENDOR table, which consists of VENDOR_ID, VENDOR_NAME, VENDOR_PHONE, and VENDOR_EMAIL. VENDOR supplies PRODUCT.

Reference no: EM13756965

Questions Cloud

Fundamentals of database systems : Now that the ERD is completed for your selected project, you are anxious to create the database and setup the tables. Before that step you remind everyone that the 2nd phase in the Database development process has not been completed yet
As part of an assessment for navigation : As part of an assessment for navigation, a professor has his students take a written test. He teaches two sections of the class. The variance and standard deviations for test 1 and test 2 scores are shown below. What do the results say about the rela..
What was the impact of human mutations on maize and wheat : What was the impact of human mutations on maize, wheat, and rice?
Evaluate the economic cost to the us : Evaluate the economic cost to the U.S. due to investigating Mad Cow Disease, and determine whether or not diligent monitoring can safeguard against damaging the U.S. meat supplies. Provide at least two (2) examples to support your rationale.
Write appropriate connectivities and cardinalities in erd : Use the following business rules to create a Crow's Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. For each rule below
Understanding of the major differences in reported financial : Demonstrate an understanding of the major differences in reported financial results when using US GAAP vs. IFRS and the impact on analysis.
Decision making be the same as for mass merchandising : Describe how what was learned in this mass merchandising industry could be applied to the logistics challenges in some other industry.
Translate business requirements into systems : Perform modelling to assist with analysis and decision making, Translate business requirements into systems by applying appropriate SDLC methodologies and incorporating industry best practices
The current database section found through the office button : In the Current Database section found through the Office Button, add Add Messages-Operator's Version as the application title. Make the start-up form Unread Messages open automatically when the application starts.

Reviews

Write a Review

Management Information Sys Questions & Answers

  Information technology and the changing fabric

Illustrations of concepts from organizational structure, organizational power and politics and organizational culture.

  Case study: software-as-a-service goes mainstream

Explain the questions based on case study. case study - salesforce.com: software-as-a-service goes mainstream

  Research proposal on cloud computing

The usage and influence of outsourcing and cloud computing on Management Information Systems is the proposed topic of the research project.

  Host an e-commerce site for a small start-up company

This paper will help develop internet skills in commercial services for hosting an e-commerce site for a small start-up company.

  How are internet technologies affecting the structure

How are Internet technologies affecting the structure and work roles of modern organizations?

  Segregation of duties in the personal computing environment

Why is inadequate segregation of duties a problem in the personal computing environment?

  Social media strategy implementation and evaluation

Social media strategy implementation and evaluation

  Problems in the personal computing environment

What is the basic purpose behind segregation of duties a problem in the personal computing environment?

  Role of it/is in an organisation

Prepare a presentation on Information Systems and Organizational changes

  Perky pies

Information systems to adequately manage supply both up and down stream.

  Mark the equilibrium price and quantity

The demand schedule for computer chips.

  Visit and analyze the company-specific web-site

Visit and analyze the Company-specific web-site with respect to E-Commerce issues

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