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