answers – Ravi

Student
- Attributes:
  - StudentID (Primary Key)
  - Name
  - DateOfBirth
  - Email
  - PhoneNumber
  - Address
Course
- Attributes:
  - CourseCode (Primary Key)
  - Title
  - CreditHours
  - DepartmentID (Foreign Key)
Instructor
- Attributes:
  - EmployeeID (Primary Key)
  - Name
  - Designation
  - DepartmentID (Foreign Key)
  - ContactDetails
Enrollment
- Attributes:
  - EnrollmentID (Primary Key)
  - StudentID (Foreign Key)
  - CourseCode (Foreign Key)
  - EnrollmentDate
  - Grade
Department
- Attributes:
  - DepartmentID (Primary Key)
  - Name
  - HeadOfDepartment (Foreign Key referencing Instructor)
Class Schedule
- Attributes:
  - ScheduleID (Primary Key)
  - CourseCode (Foreign Key)
  - RoomNumber
  - Building
  - Day
  - Time