How is data modeling different from database design? -

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
What is Excel:............................................................................................................................2
Version 1 (V1.0):.......................................................................................................................2
Version 2 (V1.1):.......................................................................................................................4
Version 3 (V1.2):.......................................................................................................................4
Version 4 (V1.3):.......................................................................................................................4
Bibliography:..............................................................................................................................6

DATA MODELLING AND DATABASE DESIGN
2
What is Excel:
Microsoft excel is a special type of tool or software from Microsoft. Ms excel is
included in the Microsoft Office suite (Hubalovsky & Musilek, 2014). Ms Excel can perform
several tasks, and this is the best tool where a person or an organization can use for this
application for storing information.
Any person can edit or delete the data. Excel store every data in a spreadsheet. The
cell-based calculation can be done in excel, pivot table and many graphical tools are available
in Excel. With the help of a spreadsheet, a person can store their monthly budget, and track
every business expenses. Basically, with the help of excel, an organization can keep its data
in a structured format.
In this project, MS excel is used to develop a database for Torrens University
Australia. They want to develop a student record management system that can perform store
every student information, staff information and enrollment information. This information
will help the university to keep every essential detail and maintain the workflow. This system
can add, delete or modify any information.
To develop the university database, creating four spreadsheets to store every
information, version 1, version 2, version 3 and version 2. The details description of this three
spreadsheet are described below:
Version 1 (V1.0):
In Version 1, storing every information of student, course, enrollment information and
staff information. Every student is uniquely identified with their student id number. This
sheet stores student’s first name, last name, address, and date of birth. Every course has its
course id number. And course name store at the course name column. Every enrolment