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

It is the student's responsibility to determine if they have met the eligibility requirements (pre-requisite/co-requisite) for a course.Group of answer choicesTrueFalse

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.

NSERT INTO Courses (CourseID, CourseName, Credits, InstructorID) VALUES (101, NULL, 3, 1);Group of answer choicesKey constraintNo ViolationEntity integrity constraintReferential int

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

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.