2046_Harry Potter ERD

ERD Diagram

Tables (5)

Course (hr_course)

  • Course ID (hr_course_id) — NUMBER — Primary key — NOT NULL
  • Course Name (course_name) — VARCHAR
  • Professor ID (hr_professor_id) — NUMBER — Foreign key → Professor.Professor ID — NOT NULL

Dormitory (hr_dormitory)

  • Dormitory ID (hr_dormitory_ID) — NUMBER — Primary key — NOT NULL
  • Name (dormitory_name) — VARCHAR
  • Professor ID (hr_professor_id) — NUMBER — Foreign key → Professor.Professor ID — NOT NULL

Professor (hr_professor)

  • Professor ID (hr_professor_id) — NUMBER — Primary key — NOT NULL
  • First Name (professor_first_name) — VARCHAR
  • Last Name (professor_last_name) — VARCHAR
  • Hire Date (professor_hire_date) — DATE
  • Working Status (professor_working_status) — Boolean — NOT NULL
  • Contact Number (Field) — NUMBER

Registration (hr_registration)

  • Student ID (hr_student_id) — NUMBER — Foreign key → Student.Student ID — NOT NULL
  • Course ID (hr_course_id) — NUMBER — Foreign key → Course.Course ID — NOT NULL
  • Registration Date (Field) — DATE

Student (hr_student)

  • Student ID (hr_student_id) — NUMBER — Primary key — NOT NULL
  • First Name (student_first_name) — VARCHAR
  • Last Name (student_last_name) — VARCHAR
  • Dormitory ID (hr_dormitory_ID) — INT(4) — Foreign key → Dormitory.Dormitory ID
  • Contact Number (student_contact_number) — NUMBER