DB Design Overview: $(50$ points$)$

Write a summary of the key changes and improvements made from Part$1.$ If you received some feedback in Part $1$ and were asked to fix some issues, please point them out clearly in this section.

Write a description of the ER model, highlighting the key decisions taken and their reason when coming up with this design.

Point out the strong $/$ weak entities, strong $/$ weak relationships, and optional $/$ mandatory participation

DB data model: Draw a fully developed ER model using Crow$-$foot notation. The following elements must be clearly shown: $(75$ points$)$

Entities, their attributes, primary keys, foreign keys.

Relationships with cardinalities.

Entity super$-$type and sub$-$type where applicable with sub$-$type discrimination, disjoint$/$overlapping constraint, complete$/$partial constraint.

Conclusion and key take aways: Summarize your key learnings from this case study, and how could your design be further improved in future. $(25$ points$)$