Please see the attachment memos, it has all the information that you need for this project for now. I will add more when it is available.
your mission is to supply the usual database deliverables at the end of the project, i.e.,
• List of ( charts of) functional dependencies
• A relational database design (SNF) - a Logical Data Model (LDM), and a corresponding Physical Data Model (PDM)
(this is the important part for now, use ERwin diagram, see the example in attachment "this my try but I am not sure of it)
• Results, from the prototype database, for typical queries (questions)