БД Приёмная комиссия SQL Server

In the downloaded archive will be a database implemented for the subject: "Admissions Committee at the university". Inside the archive there are ready queries to the database:
1) insert a new applicant
2) insert a new specialty,
3) insertion of a specialty from an applicant (chosen by him from 3),
4) a list of selected specialties by an applicant;
5) a trigger that tracks the addition of specialties from the applicant (does not allow to add, if there are more than three)
6) removal of specialty
7) formation of a list of enrollment points
7) 3 DB versions (SQL Server)
8) report for a more complete understanding of this topic (diagrams, entities, relationships, etc.)

-