Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
Expert Solution & Answer
100%
Book Icon
Chapter 4, Problem 4P

Explanation of Solution

Entity Relationship (ER)  Diagram:

The following figure illustrates the ER Diagram for given business rules using Crow’s Foot notation:

Explanation:

The above ERD, contains several entities such as “Customer”, “Invoice”, “Vendor”, “Product”, “Salessrep” and “Inv_Line”. Each entity has its own attributes.

  • A customer can generates invoice form several sales representatives...

Blurred answer
Students have asked these similar questions
I need the answer as soon as possible
An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of artwork. Each piece of art has a unique id [ArtID], an artist, year and title. Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a paintType and style. Sculptures have a material, height and weight. Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate. A listing of the artwork displayed at an exhibition is also retained. Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1 and relationship type RT1. Start_date End_date E1 E1 11 RC1 PaintType Style E3 13 A1 Title Year A/ A A/ A/ A/ A/ A/ A/ A A/ A/ E2 12 A/ E2 E3 E4 11 12 13 14 A1 A2 RC1 RT1 RT1 A2 Height Weight E4 14 Activate Go to Settin
Create an ERD based on the Crow’s Foot notation with Microsoft Visio, using the following business rules or requirements: An INVOICE is written by aSALEREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. The INVOICE is written for a single Customer. However, each customer can have many invoices. An INVOiCE can include many detail lines (LINE), each of which describes one product bought by the customer. The product information is stored in a PRODUCT entity.  The product's vendor information is found in a VENDOR entity.
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage