Data Modelling & Database Design

Running head: DATA MODELLING & DATABASE DESIGN
DATA MODELLING & DATABASE DESIGN
Name of the Student
Name of the University
Author Note

Table of Contents
Introduction......................................................................................................................................2
Database System - File based..........................................................................................................2
Data and Data attributes...................................................................................................................3
Versions...........................................................................................................................................4
Conclusion.......................................................................................................................................8
References........................................................................................................................................9

Introduction
Data modeling is the initial phase of the database design, considered as the high level
design phase. The main of the modeling is to define data related to the entities inspired from the
real word objects. The structure of the database is developed in the modelling phase with the
help of entities, attributes and relationship between them. However, the flat file based databases
are developed using normal text or excel files (Bowcock & Bayfield, 2014). These files are also
helpful in storing information earlier than the Structured databases (SQL). Attributes are
essential for the data storing where it defines the column that what kind of data will be saved. In
this document, the data modelling of a student course enrolment scenario will be explained with
the help of excel. It will allow the staff to add, update and delete the data from the files whenever
required. Lastly the document will finalize with the results of the Excel assessment.
Database System - File based
The database system that uses data files to organize and manage data is known as file-
based database management system. It is supposed to handle only one data file at a time. It is the
easiest form of database system to handle as structure is consistent and software for handling
these files are inexpensive (Winston, 2016). It is mainly used in smaller organizations or by
home users. It best for storing less amount of data which makes the data retrieval faster and easy.
However, the data security, integrity and management of large data is not suitable for file based
system. Each domain data is stored in separate files which is accessible by other software also.
The main functionalities of the file-based database system is given below:
i. The data can be managed by any user as it is simple to get access and use.
ii. All the basic management can be done using data files including add, delete, update
and other computations (Ose, 2016).