Question

Would you please help me with this homework ?

1- Explain what requirements this ER diagram is implementing

address driver-id Спате model license year location person person a owns s car con report-number report-number Cdate date driver participated accident ( damage-amount)

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 a 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).

Answer 1

1.

• A person owns many cars where as a car is owned by only one person
• Person is identified by driver-id and has name and address
  A car is identified by license and has model and year
• A person(driver) can participate in many accidents and a accident can be participated by many person where each participation has a damge-amount
• accident is identified by report-number and has location and a date

2.

salesperson customer order orders agent manages lists Supplies part assembled TA Inventory item Supplier

########################################################

Give a ThumbsUp if you found this answer Helpful :)
#######################################################

In the Case of multiple questions,we(Experts) should answer only certain number of sub-parts\questions.So kindly ask the remaining sub-parts\questions as a new query. Sorry for the inconvenience caused.

################################################################
............ Still having trouble understanding the answer ? Feel free to ask in the comment section.......