A university registrar’s office maintains data about the following entities: (a)courses, including number, title, credits, syllabus, and prerequisites; (b) courseofferings, including course number, year, semester, section number, instructor(s),timings, and classroom; (c) students, including student-id, name, and program;and (d) instructors, including identification number, name, department, and title.Further, the enrollment of students in courses and grades awarded to studentsin each course they are enrolled for must be appropriately modeled.Construct an E-R diagram for the registrar’s office. Document all assumptionsthat you make about the mapping constraints.

t a university, 3 courses are offered: "Programming", "Databases" and "Software Engineering".Each course is offered by a lecturer.Create for each course an instance of type COURSE (=class) using a constructor (parameters: name of the course and the lecturer).The lecturer is stored in a data member of type LECTURER (=class). The class LECTURER should have at least the data member academic_title.The courses have a maximum of 10 and a minimum of 3 course participants.The courses can be attended not only by our own students, but also by students from other universities.The class STUDENT should have at least the following data members: Matriculation numberUniversityStudents from their own university may take any course.Students from other universities may only take one course.The classes LECTURER and STUDENT should derive from the class PERSON.The class PERSON should have at least the following data members:SurnameFirst nameEmailTask: Create a program with a menu that covers the following situation:1. Registration for a course (including querying student data). Each student has a unique email, meaning there can't be two or more students with the same email in the same course.2. Output of one/all courses with data of the participants.    Please note that if there are fewer than 3 participants in a course, an additional message must be displayed - "Course will not take place".3. Output of all courses that are not fully booked yet. The output must include the number of free places, the name of the course and the academic name of the lecturer with its academic title.4. End of program: A message will be displayed stating which participants (=all data members of the class PERSON) have to be notified because your course is not taking place.If necessary (creation, search, and so on), corresponding messages are to be displayed.Permanent storage of the data is not required. The data must only be available at the runtime of the program.Use comments in the source code to document your program.

The registrar does all of the following except:A.register students for school.B.maintain students' personal records.C.mail out documents such as transcripts.D.issue reports of grades.

Course(course_id,sec_id,semester)Here the course_id,sec_id and semester are __________ and course is a _________.OptionsRelations, AttributeTuples, SetTuples, AttributesAttributes, Relation

Consider an application for a training institute. Here, a participant can enroll for multiple courses. A course can be enrolled by many participants. Assessments are conducted for courses and marks are awarded to participants. A participant is allowed to take assessment only once for a course. A participant can enroll for a course only if he/she has undertaken the prerequisite course. The below relations are created for the application.Participant (ParticipantId, Name, Address)Course (CourseId, Desc, Duration, Prerequisite)Assessment (CourseId, Marks, ParticipantId)Identify the Primary key for Course relation.CourseIdDescDurationPrerequisite

Define a class Student that keeps track of academ icr ecord of students in a school. The class should containthe follow ing data m em ber s:rollNum – Roll num ber of studentname – Nam e of studentmarksList – List of m arks in fiv e subjectsstream – A: Ar ts, C: Com m er ce, S: Sciencepercentage – Per centage com puted using m arksgrade – Grade in each subject com puted using m arksdivision – Div ision com puted on the basis of ov erallper centageThe class should suppor t the follow ing m ethods:1 . __init__ for initializing the data m em ber s.2 . setMarks to take m arks for fiv e subjects as aninput from the user .3 . getStream for accessing the str eam of thestudent.4 . percentage for com puting the ov erallper centage for the student.5 . gradeGen that generates grades for each studentin each cour se on the basis of the m arksobtained. Cr iter ia for com puting the grade is asfollow s:Marks Grade>= 90 A<90 and >=80 B<80 and >=65 C<65 and >=40 D<40 E6. division for computi ng di v i si on on the basi s of the fol l ow i ngc r iter i a based on ov er al l per centage of mar k s scor ed:Percentage Division>= 60 I<60 and >=50 II<50 and >=35 III7 . __str__ that di spl ay s student i nfor mati on.