Make This + + | Campus | + + | Campus Id (Pk)| | Name | | Address | + + | | | + + | Department | + + | Department Id(pk)| | Name | + + | | + + + | | + V + + V + | Student | | Exam Administrator| + + + + | Student Id(pk)| | Admin Id (Pk) | | Full Name | | Name | | Date Of Birth| | Phone Number | | Contact Number| | Department Id(fk) | | Address | + + | Admission Date| |Department Id(pk)| | Parent Id(fk)| + + + + | | | | | | + V + + V + | Parent | | Department Campus | + + + + | Parent Id(pk)| | Department Id (Pk)| | Full Name | | Campus Id (Pk) | | Contact Number| + + | Address | + + | | | + V + |Specialization| + + | Specialization Id(pk)| | Title | | Nqf Level | + + | | | + V + | Subject | + + | Subject Id(pk)| | Name | | Units | + + | | | + V + | Exam | + + | Exam Id(pk) | | Description| | Exam Date | | Mark | | Subject Id(fk)| | Admin Id(fk)| + + | | | + V + | Exam History| + + | Exam History Id(pk)| | Exam Date | | Mark | | Student Id(fk) | | Subject Id(fk) | + +
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) | +------------+
About This Color Palette
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.