Requirements for the report on the physical design
 
The report on the physical design will have to contain at least the following elements:

1. A list of indexes to be defined on the main tables of the database.
2. A description of the design of indexes, aimed at optimizing the execution of the main and most expensive queries.
   
3. A description of how integrity constraints are to be implemented (use of stored procedures, implementation at application level,...).
4. An anlysis of the required transactions on the database, including the choice of their level of isolation.
5. A schema describing the structure of the Web application interacting with the database. This includes
   • the structure of the pages and their connections,
   • a description of how different users interact with the application.