Data Modeling - History of Databases and ER Diagram

This document provides an overview of the history of databases and the ER diagram. It covers the evolution of databases from the 1950s to the present day, including the development of the relational database model and the introduction of SQL. The document also includes an ER diagram.

Running Head: DATA MODELING
DATA MODELING
Name of the Student:
Name of the University:
Author Note:

1DATA MODELING
Table of Contents
Assessment 2...................................................................................................................................2
Part A...........................................................................................................................................2
Part B...........................................................................................................................................3
References........................................................................................................................................5

2DATA MODELING
Assessment 2
Part A
History of databases
Database is the systematic assembly of many data. The databases provide the storage and
manipulation of these data. The management of data is made simple using the database. The
concept of storing and sorting the data is very old and the idea of databases dates back to the
1950s and in organizations, the database system were used (Jukic, Vrbsky & Nestorov, 2016).
In the 1960s, the computer systems gained popularity and the private organizations
started using the computers to store more organizational data (Berg, Seymour & Goel, 2012).
Computers increased the data storing capacity. The term database came into consideration
through the introduction of direct-access storages, like the disks and drums. Tape based storages
were not so convenient to use required a lot of effort to store and process the data. In this period
two data models were established, one is the network model CODASYL (Conference on Data
System Language) and the other one is the hierarchical model IMS (Information Management
System). The primitive way of accessing the data from these databases were done by using
pointers from one record to the other.
In the 1970, the relational database model was developed by E.F Codd. The searching of the data
in these databases were by done by using the contents. These databases included tables. In the
year 1976, P. Chen proposed a new database model which is popularly known as Entity
Relationship or just ER. During this period, the term RDBMS (Relational Database Management
System) was coined (Băzăr & Iosif, 2014).

3DATA MODELING
After this the SQL (Structured Query Language) was introduced and it became a standard
medium of storing and processing data. With the same time the concept of ‘object-oriented
database system’ was also introduced. Introduction of World Wide Web provided remote access
to the then computer systems. Since then, there are many notable developments in the field of
database. Some of them are NoSQL, UnQL. The databases can be categorised into four major
types which are relational database management system, after that object databases,
graph databases, another one is the network databases and the last one is the document db.
Part B
ER Diagram

4DATA MODELING

5DATA MODELING
References
Băzăr, C., & Iosif, C. S. (2014). The transition from rdbms to nosql. a comparative analysis of
three popular non-relational solutions: Cassandra, mongodb and couchbase. Database
Systems Journal, 5(2), 49-59.
Berg, K., Seymour, T., & Goel, R. (2012). History Of Databases. International Journal of
Management & Information Systems (IJMIS), 17(1), 29. doi:10.19030/ijmis.v17i1.7587
Jukic, N., Vrbsky, S., & Nestorov, S. (2016). Database systems: Introduction to databases and
data warehouses. Prospect Press.