The submission requirement for the case study include

1- The ER diagram of the database showing tables, attributes relations and any constraints such primary keys, foreign keys or defaults.

2- The script of database tables creation for the system database.

3- A description of the system scope the database is designed to address. Along with any assumptions or constraints.

I did like the first question and I'm stuck in second and third question. Actually I ain't really getting the meaning of the other two questions so if you could please help I'll really appreciate that!