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 details the creation of multiple versions of the database (V1.0, V1.1, V1.2, and V1.4) to demonstrate the evolution of the database design. Version 1 (V1.0) is the initial 1NF version, with all possible database objects and attributes, including student name, ID, age, date of birth, contact number, address, course ID, course name, department ID, lecturer ID, lecturer name, and related attributes. Subsequent versions (V1.1, V1.2, and V1.4) involve updates, additions, and modifications to the data, with changes highlighted. The assignment also includes an ERD (Entity Relationship Diagram) to illustrate the relationships between the data objects and the identification of data types for each attribute. The assignment brief provides the context and requirements for the database, including normalization, and ERD diagrams. The project demonstrates the practical application of database design principles, including normalization up to 3NF and the use of ERDs to represent the data structure, which is essential for effective database management. The project focuses on creating a relational database in MS Excel to store and manage university data efficiently.

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)