Explain what requirements this ER diagram is implementing 2- Draw an ER diagram (relationships) for the following
Question:
Explain what requirements this ER diagram is implementing
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).
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris