Data Modelling & Database Project: University Database Design Project

This project involves the design and implementation of a university database using MS Excel, focusing on student, course, and staff information. The project begins with an introduction to the database's purpose, which is to manage student enrollment, course details, and staff assignments. It then detai...Read More

Running Head: Data Modelling & Data base
DATA MODELLING & DATABASE
Name of the Student
Name of the University
Author Note

1Data Modelling & Data base
Introduction:
This project is developed in the Excel spreadsheet. This database can manage every
information of students, course information and staff information. In this database. By using this
database, a student can store and manage every information of enrolled student and the staff
information who are assigned for a student and this database is developed according to ERD. MS
excel is appropriate to develop this database.
Version 1(V1.0):
Version 1 (V1.0) spreadsheet is the 1nf version of this database. In this sheet, every
information of student, course and staff information is stored. The first column in this
spreadsheet is student name. Next column is student id. This column stores every student id.
Student id stores the unique ID of a student. Next to the student id, the age column is available.
Age column stores the age of the student. Next to the Age column, the date of the birth column is
present. This column can store every date of birth of a student. Contact number column can store
the phone number of a student and address table keep every address of students.
Course id column can keep every id of a specific course. Next to the course id column,
course name column is presented. This column can store every name of the course. Next to the
course name column, department id column is available. This column can store every id of the
department. The lecturer is the staff of the university, and every staff is assigned to a student.
Every lecturer can be identified with their unique lecturer id number. Next to the lecturer id
column, lecturer name column are available. In this column, every name of the lecturer is stored.
Next to the lecturer column, date of the birth of a lecturer is stored. And calculated age is stored
in the age column. And their gender is saved in the gender column. Version 1 is the complete
database that can save every necessary information for the university.

2Data Modelling & Data base
Version 2 (V1.1):
Version 2 (V1.1) is the copy of version 1, though few changes were made. In this sheet,
the last two records were updated and added new five records. Each row was highlighted in red
after changes.
Version 3 (V1.2):
Version 3 is the same sheet as version 2. In version 3 spreadsheet, lecturer address and
lecturer date of joining attribute were added. After adding these two attribute, the name of the
rows are highlighted in red colour.
Version 4 (V1.4):
Version 4 is a copy of version 3. In this version, removing five existing data and adding
fie new rows and changes were highlighted in the red colour.
Identification of data types:
Student name – Text
Student ID – Text
Age - Whole Number
Date of birth – Date
Contact Number – Whole Number
Address – Text
Course ID – Whole Number
Course Name – Text
Department ID - Whole Number
Lecturer ID – Whole number
Lecturer Name – Text

3Data Modelling & Data base
Date of birth – Date
Age – Whole number
Gender – text
ERD relationship diagram:
ERD relationship diagram to show their relations
(Source: Created by author)