make this +-------------+ | Campus | +-------------+ | CampusID (PK)| | Name | | Address | +-------------+ | | | +-------------+ | Department | +-------------+ | DepartmentID(PK)| | Name | +-------------+ | | +-------------------+-------------------+ | | +------v------+ +---------v--------+ | Student | | ExamAdministrator| +------------+ +------------------+ | StudentID(PK)| | AdminID (PK) | | FullName | | Name | | DateOfBirth| | PhoneNumber | | ContactNumber| | DepartmentID(FK) | | Address | +------------------+ | AdmissionDate| |DepartmentID(PK)| | ParentID(FK)| +------------------+ +------------+ | | | | | | +------v------+ +---------v--------+ | Parent | | DepartmentCampus | +------------+ +------------------+ | ParentID(PK)| | DepartmentID (PK)| | FullName | | CampusID (PK) | | ContactNumber| +------------------+ | Address | +------------+ | | | +------v------+ |Specialization| +--------------+ | SpecializationID(PK)| | Title | | NQFLevel | +--------------+ | | | +------v------+ | Subject | +------------+ | SubjectID(PK)| | Name | | Units | +------------+ | | | +------v------+ | Exam | +------------+ | ExamID(PK) | | Description| | ExamDate | | Mark | | SubjectID(FK)| | AdminID(FK)| +------------+ | | | +------v------+ | ExamHistory| +------------+ | ExamHistoryID(PK)| | ExamDate | | Mark | | StudentID(FK) | | SubjectID(FK) | +------------+
Palette Description
Color Palette:
1. Color Name: Midnight Blue
Hex Code:
#191970
Description: Represents the primary information and data tables in the database schema.
2. Color Name: Dark Slate Gray
Hex Code:
#2F4F4F
Description: Represents the secondary information and tables related to departments and campuses.
3. Color Name: Teal
Hex Code:
#008080
Description: Represents the tertiary information related to students and exam administrators.
4. Color Name: Steel Blue
Hex Code:
#4682B4
Description: Represents the parent information and their relationships with students and departments.
5. Color Name: Dark Olive Green
Hex Code:
#556B2F
Description: Represents the specialization and subject tables in the schema.
6. Color Name: Dark Orange
Hex Code:
#FF8C00
Description: Represents the exam-related information and history logs in the database.