Discuss how and when aggregates are used.

a. When are they introduced on our diagram?

b. How many relationships are allowed in an aggregate?

c. What is the difference between a many to many relationship with attributes on our diagram vs an aggregate? Give examples

d. Illustrate the following scenario. Final year undergraduate students are required to undertake a capstone research project. Each project is proposed by one or more lecturers and each student undertaking a project has to be supervised by a lecturer however not every lecturer supervises a project though he/she may propose one. Of course the grade a student received for a project needs to be recorded along with the academic year undertaken.

database management