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.

User Account

All Pages