Select a software application and select one module of that application (For example, UniversitySystem -> Courses registration Module).

Create the scenarios of using that module and determine the semantics of the information needed to be stored.

Create the ER diagram for the module (refine the relations if needed) including any integrity constraints.

Write the SQL queries that create the designed module.

This is the question, I choosed Hospital Database ER model(in above picture). It is my project hw so need explanation. Can you help urgent pls?

ER Diagram of Hospital Management System