$1.$ File containing the step by step description for normalization process. $2.$ ERD Diagram. $3.$ A file containing all SQL commands. $4.$ A file containing the description of the five scenarios and what they signify.

Objective: The goal of this project is to guide students through the process of database normalization, Entity$-$Relationship Diagram $($ERD$)$ creation, SQL database implementation, and practical usage of SQL queries. Students will work with a sample unnormalized student data table to achieve these objectives.

Dataset Description: The provided dataset contains student$-$related information in an unnormalized form, with redundant and repetitive data entries. The key columns in the dataset include:

Registration Number

Student Name

Student Phone Number

Student Address

Student Faculty ID

Faculty Name

Faculty Dean

Faculty Address

Faculty Extension

Course ID

Course Title

Course Credit Hours

Course Grade

Grade Points

Course Status

Student CGPA

Student SGPA

Course taken in semester

Student Status

Project Tasks:

Analyze the Unnormalized Table:

Examine the provided dataset to understand its structure and identify redundancies and anomalies.

Normalize the Data:

Apply the principles of database normalization to transform the unnormalized table into its normal forms $(1$NF$,2$NF$,$ and $3$NF$).$

Ensure that each table is structured properly to eliminate redundancy and maintain data integrity.

Create an Entity$-$Relationship Diagram $($ERD$)$:

Based on the normalized tables, create an ERD to visually represent the database schema.

Identify the entities, their attributes, and the relationships between them.

SQL Database Implementation:

Write SQL queries to create the normalized tables in a relational database.

Define the necessary primary keys, foreign keys, and constraints to enforce data integrity.

Practical Scenarios and SQL Queries:

Identify at least five practical scenarios where the database can be utilized.

Write SQL queries for each scenario to demonstrate how the database can be used to retrieve, update, and manage data.