Question: A new database needs to be developed. You are required to draw the related Entity Relationship Diagram (ERD) that includes the following information: (a) Employee

A new database needs to be developed. You are required to draw the related Entity Relationship Diagram (ERD) that includes the following information:

(a) Employee (the company has several employees)

(b) Department (each employee is assigned to one department)

(d) Customer (employees sell products to customer)

(e) Products (the company offers several products)

Note that an employee can sell products to several customers and that every customer can be served by multiple employees. Include relationship types only if necessary and specify suitable primary keys for all elements. Include all primary keys and all foreign keys in the ERD.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Entity Relationship Dlagram ERD An Entity Relatlonship ER Dlagram Is a type of flowchart that Illust... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Computer Network Questions!

Create an Executive Summary that includes the following information regarding any enterprise: A description of the enterprise, the industry sector, product(s), and intended market an overview of the...

Draw an ERD containing Student and Paper entity types connected by 1-M relationships. The Student entity type should have attributes for StdNo (primary key), StdFirstName, StdLastName,...

Draw an Entity Relationship Diagram for the following scenario: PART A: The state of Georgia is interested in designing a database that will track its researchers. Information of interest includes...

A new database needs to be developed. You are required to draw the related Entity Relationship Diagram (ERD) that includes the following information: (a) Employee (the company has several employees)...

I need someone that is very good at Principles of accounting and finance to answer the attached questions. It is not a one-day job therefore if you do not have the time, please don't attempt it. The...

Hi there I need help answering ASSIGNMENT 1 ONLY by Friday afternoon. I have attached the study pack to help answer the question. Thanks! FIN4802 ASSIGNMENTS ASSIGNMENT 01 Due date: 13 May 2016...

Protecting Your Trademark ENHANCING YOUR RIGHTS THROUGH FEDERAL REGISTRATION Basic Facts About Trademarks United States Patent and Trademark Office MESSAGE FROM THE USPTO Thank you for requesting a...

ATC 14-1 (Pg. 686) 1.(Follow the cash) In a narrative format, answer the questions posed in the case. 2.What is meant by "presentation of financial statement information in common-size amounts rather...

Each separate response must have approximately 200 words. Assignments vary widely; however, essays should be written in APA style, with in-text citations and a separate reference listing as...

Review the consolidated balance sheets and the related disclosures and respond to the following questions. Debt: As of June 30, 2015, what is the dollar amount of the current portion of the long-term...

Allegra Inc. has one million shares outstanding. The company is considering the issue of debt of $15 million. The interest rate on this new debt issue will be 8%, and the number of shares after the...

Why do dideoxynucleotides function as chain terminators?

2. If clear-cutting continues in primary forests and the Endangered Species Act is not repealed, then either the Endangered Species Act will be repealed or thousands of animal species will become...

In Corollary 4.18, we showed that the set of all languages is uncountable. Use this result to prove that languages exist that are not recognizable by an oracle Turing machine with an oracle for A TM .

When a wire loop is rotated in a magnetic field, the direction of the current induced in the loop reverses itself twice per rotation. Why?

Martin S. Albert (Social Security number 111-11-1111) is 39 years old and is married to Michele R. Albert (Social Security number 123-45-6789). The Alberts live at 512 Ferry Road, Newport News, VA...

Zoning is defined as the distribution of vacant land to residential and nonresidential uses via policy set by local governments. Although the negative effects of zoning have been studied (e.g.,...

The piston/cylinder shown in Fig. P3.169 contains 18 ft 3 of R-410a at 300 psia, 300 F. The piston mass and atmosphere gives a pressure of 70 psia that will float the piston. The whole setup cools in...

give me excel directions for this- Run a 2 sample t-test (unequal variances) comparing X1 and X2

Modeling Basics- College Park Apartment Rentals General Instructions Read the Case Description below. Once you understand the case start formulating your entities and attributes. You can draw these...

Please help me with this, Thank you. I want ERD for this. Modeling Basics~ College Park Apartment Rentals General Instructions Read the Case Description below. Once you understand the case start...

PLEASE ONLY NEED THE SQL AND THE TABLES FOR THIS WOULD TRULY APPRECIATE UNDERSTANDING THIS! MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and...

CS 112 Project 5 Dictionaries and File IO Due Date: Sunday, April 23rd, 11:59pm Last chance to use tokens! (P6 won't allow late submissions) The purpose of this assignment is to explore dictionaries...

What SQL statement lists only the EmployeeID, LastName, and FirstName fields of all employees in the Employees table? a. SELECT * FROM Employees; b. SELECT EmployeeID, LastName, FirstName FROM...

What data types would you assign to the City and Zip fields when creating the Zips table? a. TEXT to City and SHORT to Zip b. LONGTEXT to City and TEXT to Zip c. TEXT to City and TEXT to Zip d. SHORT...