Design a relational database for a university register office || E-R diagram for a university register office .
Underlined attributes indicate primary
student(studentid,name,program)
course(courseno,title,syllabus,credits)
course-offering(courseno,secno,year,semester,time,room)
instructor(instructorid,name,dept,title)
enrols(studentid,courseno,semester,year,grade)
teaches(courseno,secno,semester,year,instructorid)
requires(maincourse,prerequisite)