Charles Sturt University ITC556 Data Modeling Report

This report, prepared for the ITC556 Database Systems course, delves into the core concepts of data modeling. It begins with a historical overview of databases, tracing their evolution from the 1950s to modern systems, including the development of relational models, the introduction of SQL, and the emergence of NoSQL databases. The report then explores the Entity-Relationship (ER) model, a crucial tool for database design. Furthermore, the report includes a table of contents, and references, providing a structured and comprehensive analysis of the subject matter. This assignment provides a comprehensive understanding of data modeling principles and database system evolution. The report covers essential topics like database history, ER diagrams, and different database types.

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.