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
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).
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started