Answer the following

Discuss how and when aggregates are used.

How many relationships are allowed in an aggregate?

When are they introduced on our diagram?

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

Illustrate the following scenario.

A third-year undergraduate students are required to undertake a mapstone 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.