SYSTEM A: Student Database Management System:

Create a system to store student information like names, courses, grades, and attendance records. You can experiment with data normalization techniques to

Tasks: Design tables with relationships to avoid redundancy.

$1.$ Calculate student grade point averages $($GPA$).$

$2.$ Track student attendance for a specific course.

$3.$ Generate reports on student enrolment by major. Minimize redundancy and ensure data integrity.

Requirements: $1.$ Entities: $(7-10)$ Entities Add Constraints

$-$ Students $($name$,$ ID number, major, year$)$ Courses $($course code, name, instructor$)$

$-$ Grades $($student ID$,$ course code, grade$)$ Attendance $($student ID$,$ date, attendance status$)$

$-$ Add more entities with attributes needed.

$1.$ Provide the following

$1.$ Company Background

$2.$ Business Rules

$3.$ Using SQL DATA MODELER $-$ Create a database schema $($Logical Model$)$ ERD of the company's database system

$4.$ Tables in your database should contains $7-10$ tables

$5.$ Tables should be in Normalize form at least $3$NF

$6.$ ENTITIES NAME should be Related to the database system

$7.$ Add the necessary constraints on each entity

$8.$ Add a table relationship and relationship label Example Logical Database Model for your guide