SQL Server Management Studio | Report

Running head: SQL SERVER MANAGEMENT STUDIO
SQL SERVER MANAGEMENT STUDIO
Name of the Student
Name of the University
Author Note

SQL SERVER MANAGEMENT STUDIO
1
Table of Contents
Enrolment System............................................................................................................................2
Entity Relationship Diagram...........................................................................................................2
Description.......................................................................................................................................3
Procedures....................................................................................................................................3
Trigger.........................................................................................................................................3
View.............................................................................................................................................4
Strength and Weakness....................................................................................................................4
Query...............................................................................................................................................4
Bibliography....................................................................................................................................6

SQL SERVER MANAGEMENT STUDIO
2
Enrolment System
The Enrolment system is a Database management system where the students’ enrolment
for the courses have been recorded. The Database records the student information consisting of
student name, contact, age, gender, email and contact. On other hand the course details are
recorded in form of course name, duration and fees. The enrolment is stored with the help of
student, course and enrolment date. The system is a relational system; hence the entities have
relationship between them. Each student can enroll to one or many courses, where each course
can have one or many students enrolled.
Entity Relationship Diagram
Figure 1: Entity Relationship Diagram of Enrolment System
Source: created by author