It looks like you need help with your homework. I already have the answers, and can explain them to you if you select me. I can show you how to make the diagram or do it for you.
Relevant Skills and Experience
Various Relational Databases such as MS SQL Server, MySQL, Oracle, etc. I generated these diagrams after I made the database using SQL Server Management Studio
Proposed Milestones
$35 USD - Solution Provided