Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Explain what requirements this ER diagram is implementing 2- Draw an ER diagram (relationships) for the following business rules in a company: A salesperson

Explain what requirements this ER diagram is implementing

student submitted image, transcription available below

2- Draw an ER diagram (relationships) for the following business rules in a company:
• A salesperson manages one or many other salespeople while a salesperson is managed by only one salespeople.
• A salesperson can be an agent for many customers but a customer is managed by only one salesperson.
• A customer can place many orders. But an order can be placed by one customer.
• An order lists many inventory items. An inventory item may be listed on many orders.
• An inventory item is assembled from many parts. A part may be assembled into many inventory items.
• Many employees assemble an inventory item from many parts. A supplier supplies many parts. A part may be supplied by many suppliers.

3- Draw a full ER diagram for the following requirements: The university database stores details about university students, courses, the semester a student took a particular course (and his mark and grade if he completed it), and what degree program each student is enrolled in. Consider the following requirements list:
• The university offers one or more programs.
• A program is made up of one or more courses.
• A student must enroll in a program.
• A student takes the courses that are part of her program.

• A program has a name, a program identifier, the total credit points required to graduate, and the year it commenced.
• A course has a name, a course identifier, a credit point value, and the year it commenced.
• Students have one or more given names, a surname, a student identifier, a date of birth, and the year they first enrolled. We can treat all given names as single object—for example, “John Paul.”
• When a student takes a course, the year and semester he attempted it are recorded. When he finishes the course, a grade (such as A or B) and a mark (such as 60 percent) are recorded.
• Each course in a program is sequenced into a year (for example, year 1) and a semester (for example, semester 1).
 

driver-id address person name driver owns license model car year participated damage-amount report-number accident location date driver-id address person name driver owns license model car year participated damage-amount report-number accident location date

Step by Step Solution

3.44 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation and Management

Authors: Carlos Coronel, Steven Morris

13th edition

1337627909, 978-1337627900

More Books

Students also viewed these Accounting questions