- May 15, 2020
Student Management SystemI want you to design, implement, populate, and produce 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 you are adding, dropping, and completing classes.RequirementsYou can use the attached .sql file to create the database. However, you are welcome to use your judgement and creativity and alter the .sql file or create your own. In any case, you must show your create/alter statements to create the database. You must have a student management database that you can retrieve information from that you would see when you register for classes, view your schedule, and run a degree audit. This includesStudent InformationFaculty InformationClass InformationCollege InformationClasses per semesterSemestersGrades per classYou must show your insert statements to insert the data into your database which includes at least the following2 distinct students2 distinct faculty members2 distinct colleges4 distinct classes2 distinct semesters1 class per student complete with a grade in a past semester1 class per student currently being taken in a current semesterYou must show your select statements to retrieve result sets for the followingClasses available in the current semester.Class Number, Class Name, Class Description, Section, Semester, Time/day offered,Faculty Name teaching, College Name Offering, Credit HoursClasses each student is currently enrolled.Student Name, Student Program, Class Name, Class Section, Faculty Name teaching, Credit hours, Credit Level (grad or undergrad)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 takenIf you are in the IT6060 course, you must complete research into how to make a stored procedure in your database and create a stored procedure for the following.I want a stored procedure to accept a student name and if it already exists in the students table, return the student ID and if it doesn’t already exist in the students table, insert the student and return the student ID.In your Kaltura Video for the final project, you must clearly show and explain your database design, create/alter statements to implement your database, insert statements to add the data, and select statements, result sets, and stored procedure.