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 Laude B+ 75 3.50 Magna Laude A- 80 3.67Summa Laude A 90 4.00 SCHOOL OF TECHNOLOGY & MATHEMATICSDepartment of Information Technology Page 2 of 5documentation Begin each page of SQL code with the followingdocumentation as comments: - Author: - Date Created: - Course:ITT304 - Purpose: PART I (20%) 1. Determine and represent theinitial relations for the database from the case study, includingprimary key. 2. Based on the initial relations, perform necessary3NF normalization on any relation(s). 3. Construct an E-R diagramfor the Registry Department.