CASE STUDY UCC’s Registry Department maintains data on the following entities: 1. Students, which includes identificatio
Posted: Tue Jul 12, 2022 8:05 am
CASE STUDY UCC’s Registry Department maintains data on thefollowing entities: 1. Students, which includes identificationnumber, name (first, middle and last), personal and student email,contact numbers (mobile, home and work), home address, next of kinand their contact number, program of study, and GPA. 2. Lecturers,which includes, identification number, name (title, first andlast), department, and position (adjunct or staff lecturer). 3.Courses, which includes course code, title, credits, degree level,and prerequisites. 4. Course schedule, which includes course code,semester, year, section, lecturer(s), day, time, and location. 5.Course enrolment, which includes course code, studentidentification number, course work grade (60% weighting), finalexam or project grade (40% weighting). 6. Course grade and programGPA are based on the following scale: Grade Grade Scale QualityPoints Award F 0 0.00 D 40 1.67 C 50 2.00 Pass C+ 55 2.33 Credit B-60 2.67 B 65 3.00 Com Laude B+ 75 3.50 Magna Com Laude A- 80 3.67Summa Com Laude A 90 4.0 PART II (20%) Using SQL statements: 1.Create the Registry Department’s database, schema, andrelationships. The database and tables must be appropriately named.2. Populate the tables with the records of 25 students, 10lecturers and 10 courses.