1.

Design A Relational Database For A University Registrar's Office. The Office Maintains Data About Each Class, Including The Instructor, The Number Of Students Enrolled, And The Time And Place Of The Class Meetings. For Each Student-class Pair, A Grade Is Recorded?

Answer»

UNDERLINED attributes indicate the primary key.

student (student-id, NAME, PROGRAM)
course (courseno, title, syllabus, credits)
course-offering (courseno, secno, year, semester, time, room)
instructor (instructor-id, name, dept, title)
enrols (student-id, courseno, secno, semester, year, GRADE)
TEACHES (courseno, secno, semester, year, instructor-id)
requires (maincourse, prerequisite)

Underlined attributes indicate the primary key.

student (student-id, name, program)
course (courseno, title, syllabus, credits)
course-offering (courseno, secno, year, semester, time, room)
instructor (instructor-id, name, dept, title)
enrols (student-id, courseno, secno, semester, year, grade)
teaches (courseno, secno, semester, year, instructor-id)
requires (maincourse, prerequisite)


Discussion

No Comment Found

Related InterviewSolutions