Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 . File containing the step by step description for normalization process. 2 . ERD Diagram. 3 . A file containing all SQL commands. 4
File containing the step by step description for normalization process. ERD Diagram. A file containing all SQL commands. 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, EntityRelationship 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 studentrelated 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 NFNF and NF
Ensure that each table is structured properly to eliminate redundancy and maintain data integrity.
Create an EntityRelationship 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started