Assignment 1: ER Model & Relational Schema

ASSIGNMENT 1: ER
MODEL & RELATIONAL
SCHEMA

Table of Contents
Introduction................................................................................................................................2
Entity Relationship Diagram......................................................................................................2
Normalization.............................................................................................................................2
Relational Schema......................................................................................................................3
References..................................................................................................................................7
1

Introduction
In this report, entity relationship diagram of the proposed system for GPS track logs system
has been designed. Along with this, normalization has been performed for all the relations
and relational schema has been provided for the system which includes relationships,
columns, primary keys and foreign keys of the entities.
Entity Relationship Diagram
Normalization
Track (trackID, trackName, trackDate, trackLocation) –
The TRACK relation has a primary key – trackID and it identifies every record of the
TRACK table. The trackName, trackDate and trackLocation cannot be used to uniquely
distinguish each record of the relation because two tracks can have same name, tracking date
and tracking location. This depicts that TRACK relation is in 1st Normal Form.
Apart from trackID, no other attribute can ensure the uniqueness of the records of the
relation. Hence, it is the only attribute which can functionally determine the rest of the
attributes of the relation. This depicts that relation is in 2nd Normal Form.
2