Data Modelling and Database Design | Assignment

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

DATA MODELLING AND DATABASE DESIGN
1
Table of Contents
Introduction......................................................................................................................................2
File-Based Database....................................................................................................................2
Identification of Data and Data Attributes.......................................................................................2
Attributes.....................................................................................................................................2
Data..............................................................................................................................................3
DB Versions and Operations...........................................................................................................3
Conclusion.......................................................................................................................................7
References........................................................................................................................................8

DATA MODELLING AND DATABASE DESIGN
2
Introduction
Database is referred as a collection of information. For the management of the databases,
modelling is done to define a proper structure for the data, attribute etc. Data modelling is the
method of developing the model in which the data can be stored structurally (Groom et al.,
2016). It represents the real-world object as conceptual objects and association between them.
File based database is a type of database which uses the flat files for basic management system
such as adding, updating, deleting etc. This report discusses the modelling of file based database
system for Torrens University Australia (TUA). It also covers the identification of the data and
data attributes along with the operations on the data file.
File-Based Database
File based systems are one way of marinating and keeping track of the records. Many
programs are designed to manipulate some certain variety of files. For example, Microsoft Excel
can manipulate a wide variety of data files which can be used as database (Toups, 2016). The
whole system of operating file is known as the file based system. The data are stored in these flat
files along with the attributes. The data can be stored permanently on computer using these flat
file applications. However, the file based database have several disadvantages such as
redundancy, integrity, concurrency and other security problems.
Identification of Data and Data Attributes
Attributes
Attributes are the properties or characteristics of a particular domain. For example full
name is an attribute for a student domain (Stonebraker et al., 2018). In this scenario the identified