1) Select a software application and select one module of that application.

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

3) Create the ER diagram for the module (refine the relations if needed) including any integrity constraints (handwritten or anything else).

4) Write the SQL queries that create the designed module.