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

Select the correct answerCourse(course_id,sec_id,semester)Here the course_id,sec_id and semester are __________ and course is a _________.OptionsAttributes, RelationRelations, AttributeTuples, SetTuples, AttributesFinish ClearPrev Next (1)

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.

Consider following relationsInstructor(id, name, dept_name,salary)Teaches (id,course_id,sec_id,sem(even/odd),year)1) Find the number of instructors who teach a course in even semester of 2016.2) List the instructors who ar not teaching in CE Department

INSERT INTO Courses (CourseID, CourseName, Credits, InstructorID) VALUES (102, 'Data Mining', 3, 10);Group of answer choicesNo ViolationEntity integrity constraintKey constraintReferential integrity constraint

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