1- Select a software application and select one module of that application (For example, UniversitySystem -> Courses registration Module). "I choose the diagram down below."

2- Create the scenarios of using that module and determine the semantics of the informationneeded to be stored.

3- Create the ER diagram for the module (refine the relations if needed) including any integrityconstraints.

4- Write the SQL queries that create the designed module. "PLEASE WRITE THE SQL CODE WITH THE ANSWER."

Also, I would be appreciated if you could explain it by steps.

Thank you.