A local university keeps records of their students to track their progress at the institution. The name, student number,

[answerhappygod]

A local university keeps records of their students to track
their progress at the institution. The name, student number,
sponsorship number, physical address and phone, postal address,
date of birth, gender, study mode (full time, part time, distance),
faculty (Computing and Informatics, Engineering and Built
Environment, Commerce and Human Sciences) and degree programme
(Bachelor, Honours, masters, PhD) are recorded. The system used in
the finance department requires the students’ physical address to
clearly specify the erf number, location, street and city name. The
students are uniquely identified by their student number and the
sponsorship number. Each faculty is described by a name, faculty
code, office phone, office location and phone. The faculty name and
code have unique values for each faculty. Each course has a course
name, description, course code, number of hours per semester, and
level at which it is offered. Courses 2 have unique course codes. A
grade report has a student name, programme, letter grade and a
grade (1,2,3,4). A faculty offers many courses to many students who
are registered for a specific programme. A student can enrol for
many courses in a semester but he or she receives only one grade
report.
Question (i) Use appropriate SQL statements to implement the
University’s database on Microsoft SQL Server Management Studio.
Show all statements in your submission. Total marks: 50