TUA Data Modelling and Database Design

Running head: DATA MODELLING AND DATA BASE DESIGN
Data Modelling and Data Base Design
Name of Student-
Name of University-
Author’ Note-

DATA MODELLING AND DATA BASE DESIGN1
Experience after completing the assignment
Using of spreadsheets have always been a strong tool used in the database. Database
includes tables that can be considered as one spreadsheet. After completing the spreadsheets. I
have learnt about how to handle data in the spreadsheets. The titles that are stated on the top are
the field names of the database table. In the given case study of Torrens University Australia
(TUA), there are different entities and those are mentioned in the spreadsheet. There are rows in
the spreadsheet and data of a person is entered in the spreadsheet as row and those shows the
rows of the spreadsheet (Jo et al., 2016). The user interface of the spreadsheet can be used for
representing the actual spreadsheet and only by viewing the data in the spreadsheet working
system can be followed. Spreadsheet helps to view the dataset in the database system and helps
to do things in a better way. Data can be browsed, sorted, entered as well as edited with the help
of spreadsheet.
I have designed spreadsheet of Torrens University Australia and have entered different
rows of data associated with the university. The university has different entities and all those are
mentioned in the spreadsheet. There are four version of spreadsheet that I have created for the
university (Borthick, Schneider & Viscelli, 2017). The spreadsheets that I have created can help
to analyze the data and help to sort list the items. But as per my view spreadsheets are not
appropriate to store data for long term. Spreadsheets are generally used to crunch numbers and
storage for single list of items. This helps in keeping the number of records, the statistical data
modeling and the computing data. There are range of functions that are applicable for
spreadsheets and those functions can help to manipulate, filter as well as sort data. Spreadsheets
are basically used for simple and basic calculations including automated functions and the

DATA MODELLING AND DATA BASE DESIGN2
spreadsheet can be used by people who does not have experience about database and does not
have technical knowledge.
For the version 1 in the spreadsheet, I have entered columns and rows in the spreadsheet.
For entering the columns in the spreadsheet, I have entered the name of the tables that are
included in the database of the university. The tables include rows of 30 students who are
enrolled in the university and their associated staffs teaching the courses. The tables also
includes the details of the course and the timing for the course that are included in the university
and rows are included accordingly in the spreadsheet. Entering data in the spreadsheet is an easy
task and that would help to manage the data of the university efficiently (Morris, 2016). Entering
of data in the spreadsheet is entered one by one and without any technical knowledge the data of
the student can be entered in the spreadsheet. There are total of 12 columns that are inserted in
the spreadsheet to enter the details of the students and their related course and staffs associated
with the course and the students.
After the version 1 sheet been created in the excel spreadsheet, I have created second
version of the spreadsheet. I have copied all the data from the version 1 spreadsheet in the
version 2 sheet. In that sheet I have updated 2 records in the excel file and have added five
additional records in the file. This have helped me to learn about how to add data in an existing
spreadsheet. I have also learnt about how to update some information if necessary in the
spreadsheet (Nurdiantoro, Asnar & Widagdo, 2017). This has helped me to know more about
spreadsheet functions and how those can be applied in managing the database of the university.
Use of spreadsheet helps to include large amount of tabular data and also can use existing data
for making the calculations. Spreadsheet can be used simultaneously by many people at a same