Database Design and Implementation | Normalization

Running head: DATABASE DESIGN AND IMPLEMENTATION
Database Design and Implementation
Name of the Student
Name of the University
Author’s note:

DATABASE DESIGN AND IMPLEMENTATION1
Table of Contents
Task A – ER Diagram:....................................................................................................................2
Task B – Normalization:..................................................................................................................4
Task C – SQL:.................................................................................................................................6
Bibliography:...................................................................................................................................8

DATABASE DESIGN AND IMPLEMENTATION2
Introduction:
Database is the organized set of data which can be accessed electronically from devices.
Database supports storing, retrieving, modifying and deleting data. In order to perform those
operations on database, system needs a database management system. In simple words, the
purpose of database management system is tracking and controlling operations on database.
Database design the process of determining stricture of a database (Arulraj 2017). Normalization
is an important factor in database design. This approach decomposes database tables so that data
redundancy and data anomalies can be prevented. Mainly three normalization forms are
considered to be standard such as first, second and third normal form. Microsoft SQL Server is a
relational database management system developed and maintained by Microsoft. SQL server is
also called T-SQL (Hashim 2018).
This report has three parts such as database modelling, normalization and database
implementing. The first part will produce an entity relationship model. In second part a database
of grade report will be decomposed up to third normal form. In the final section, a database will
be implemented in MS SQL Server and four queries will be run on the database.

DATABASE DESIGN AND IMPLEMENTATION3
Task A – ER Diagram:
Figure 1: Entity Relationship Diagram
(Source: Created by Author)
The database model has been implemented using chain’s database notation approach.
Above entity relationship diagram has four entities. Each of the entities has names in upper case.