University Course Management

Entities & Attributes

Department (DeptName PK, DeptNo, HeadID, StartDate)

Course (CourseCode PK, Title, CreditValue)

Professor (ProfID PK, Name, ContactInfo, Address, Salary, Gender, DOB)

Student (StudentID PK, Name, ContactInfo, Address, Gender, DOB)

Relationships

Department offers Course (1–M)

Department headed_by Professor (1–1)

Professor teaches Course (M–M, attribute: HoursPerWeek)

Professor supervised_by Professor (recursive)

Student enrolled_in Course (M–M, attribute: Grade)