Database Design and Implementation

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

1DATABASE DESIGN AND IMPLEMENTATION
Table of Contents
Task 1: Understanding of database..................................................................................................2
1.1 Difference between RDBMS and File Based System:..........................................................2
1.2 Hierarchical, Network and Relational Database:...................................................................3
1.3 Top-Down and Bottom-Up approach:...................................................................................6
Task 2: Conceptual Modelling.........................................................................................................7
Task 3: Logical Modelling...............................................................................................................7
3.1 Normalization:.......................................................................................................................7
3.2 Database Model:..................................................................................................................13
Task 4: SQL Script........................................................................................................................13
4.1 Create Database:..................................................................................................................13
4.2 Create Tables:......................................................................................................................14
4.3 Insert Data:...........................................................................................................................16
Bibliography:.................................................................................................................................18

2DATABASE DESIGN AND IMPLEMENTATION
Task 1: Understanding of database
1.1 Difference between RDBMS and File Based System:
Difference Factor RDBMS File System
Definition The relational database
management system is a set of
interconnected data and various
functions for processing those
data.
The file based system can be
referred to the abstraction for
retrieving, storing, handling and
modifying a collection of files.
Data Redundancy The RDBMS systems provide
strong mechanisms for handling
redundancy. The database
provides referential integrity
constraints for handling the data
redundancy (Connolly and Beg
2015).
The file base system can have
redundancy as the user will be in-
charge of defining and
implementing the files needed to
run an application. There is no
specific process for handling
redundancy.
Sharing Data The data sharing mechanism of
file based system is extremely
complex. It limits the capability of
a system in modern day IT.
The RDBMS has took the
opportunity of data sharing and
implemented a centralized system
architecture which is suitable for
data sharing (Vangoor, Tarasov and
Zadok 2017).
Data Consistency Redundant data goes through very
complex update processes. Taken
As the amount of redundancy is
less in relational database, the data

3DATABASE DESIGN AND IMPLEMENTATION
as an example, if the application
wants to change the name of the
user then it has to track every
place where name is stored and
change the name every time.
consistency is extremely high.
Atomicity The atomicity refers to the
situation where a transaction is
either complete or incomplete. The
file based system does not follow
the rules of atomicity (Connolly
and Beg 2015).
The RDMBS strongly follows the
concept of atomicity. In terms of
RDBMS, data is only changed
when the transaction is complete. If
the transaction gets interrupted then
data will be restored.
Concurrent access
anomalies
The file based systems are not
capable of providing support for
preventing anomalies that can be
caused by concurrent access.
In order to handle the concurrency,
the RDBMS is highly
recommended (Liao et al. 2018).
1.2 Hierarchical, Network and Relational Database:
Hierarchical Network Relational
Advantages This data model
promote data sharing
feature
Supports parent child
relationship (Niazi et
The model’s concepts
are simple enough to
be equal to
hierarchical model
The network model
The relational model
promotes
independency in
terms of structure by
allowing creating