DB SQL Server Admission Office

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.)