Student Management System (SQL) Result sets from a relational database for a Student Management System.

Student Management System (SQL)

Result sets from a relational database for a Student Management System. This database will store information about students, classes, semesters, instructors, departments for the University of Cincinnati. This database is what the applications pull information from when you register for courses, look up your schedule, and run your degree audit. Think about all of the pieces of information that need to be stored and added and updated while adding, dropping, and completing classes.

Details

1. A student management database that can retrieve information from that would see when you register for classes, view your schedule, and run a degree audit. This includes

a. Student Information 

b. Faculty Information 

c. Class Information

d. College Information 

e. Classes per semester 

f. Semesters

g. Grades per class

2. Showed insert statements to insert the data into database which includes at

least the following

a. 2 distinct students

b. 2 distinct faculty members

c. 2 distinct colleges

d. 4 distinct classes

e. 2 distinct semesters

f. 1 class per student complete with a grade in a past semester 

g. 1 class per student currently being taken in a current semester

3. statements from the following

a. Classes available in the current semester.Class Number, Class Name, Class Description, Section, Semester, Time/day offered, Faculty Name teaching, College Name Offering, Credit Hours

b. Classes each student is currently enrolled. Student Name, Student Program, Class Name, Class Section, Faculty Name teaching, Credit hours, Credit Level (grad or undergrad)

c. Grades for each student for college career. Student Name, Student Program, Class (sophomore, junior, grad, etc), Cumulative GPA, Each Class taken with grade and semester taken

4.