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
Difference between RDBMS and File-Based System.................................................................2
Advantage of RDBMS.................................................................................................................2
Disadvantages of RDBMS...........................................................................................................3
Limitation of RDBMS.................................................................................................................3
Advantage of File-Based System.................................................................................................3
Disadvantage of File-Based System............................................................................................3
Limitation of File-Based System.................................................................................................4
Advantages of Hierarchical, network and relational database models........................................4
Disadvantage of Hierarchical, network and relational database models.....................................5
Strength of top-down and bottom-up approaches........................................................................6
Weakness of top-down and bottom-up approaches.....................................................................6
Task 2: Conceptual Modelling.........................................................................................................7
Task 3: Logical Modelling...............................................................................................................7
Task 4: SQL Script..........................................................................................................................9
Bibliography:.................................................................................................................................13

2DATABASE DESIGN AND IMPLEMENTATION
Task 1: Understanding of database
Difference between RDBMS and File-Based System
File system is easy to use system which is required for storing files which requires
minimum security and constraints. While database management system is taken into account
when the security constraints are very much high. In file-based system, the redundancy of data is
more in comparison to RDBMS (Arulraj and Pavlo 2017). Data inconsistency is there is more in
file system in comparison to RDBMS. In file-based system, centralization is tough while it is
easy in RDBMS. In file management system, user can locate the physical address while in
RDBMS user is unaware of physical address. In the file management system, the overall security
is considered to be low while it is high in RDBMS(Poerner and Winkelmann 2017). File
management system aims to store unstructured data like isolated data and entries or files.
RDBMS aims to store structured data which comes up with proper constraints and interrelation.
Advantage of RDBMS
There are certain number of advantages of RDBMS like
Control of Redundancy: In file-based system, each of the application comes up with
own private files which cannot be shared between the application (Elmasri and Navathe 2017).
By having centralized database issues of storage waste can be avoided.
Integrity can be enforced: Integrity of data in the database is all about accuracy like
inaccurate data which can be stored in the database.
Inconsistency can be avoided: The same kind of data is duplicated and changed at the
given site which cannot be propagated to another site.

3DATABASE DESIGN AND IMPLEMENTATION
Disadvantages of RDBMS
There are disadvantages of RDBMS like
Complexity: A good RDBMS makes use DBMS which is considered to be an extremely
piece of software.
Performance: File-based systems are generally written for some specific application like
invoicing so that the overall performance is good.
Cost of DBMS: There is huge amount of cost involved in DBMS which totally depends
on environment and overall functionality.
Limitation of RDBMS
There are certain number of limitation of RDBMS like
 RDBMS aims to provide definite processing of data.
 Huge amount of capital investment is required in hardware, software and training.
Advantage of File-Based System
There are certain advantages of File-based system like
 Back of data
 Retrieval of data.
 Remote access.
 Sharing.
Disadvantage of File-Based System
There are certain disadvantages of file-based system like