Torrens University Student Management System Database Design

Desklib provides solved assignments and past papers to help students succeed.

MIS602 Data Modelling &
Database Design
1

Table of Contents
Introduction................................................................................................................................3
Entity Relationship Diagram (ERD)..........................................................................................4
Assumptions...............................................................................................................................4
Conclusion..................................................................................................................................7
References..................................................................................................................................8
2

Introduction
This is the report regarding the system of the student management for the Torrens University,
located in Australia. The database or the records of the various students and the staff
members is stored in the database in the form of records. It also includes the information
about the course and its fee structure. It also includes that which staff member is able to teach
which course and what is the time period of the course. Here the data is manged by the use if
normalization which helps in removing the redundancy in the data. The structure table is also
included in the report which is able to represent the work flow of the system. The
relationships used in the structure represent the connections between the attributes and the
tables. The excel workbook includes the four sheets. Each of the sheets contains the different
task. The tasks that were involved are the updating and deletion of the records.
3

Entity Relationship Diagram (ERD)
Assumptions
 A student is able to get the admission for more than one course but after the
completion of the current course.
 Similar course can be opted by multiple students.
 A single member of staff is able to teach the course more than one.
 In the table of students, the StudentID is acting as the primary key which helps to
identify the students uniquely. The attributes of this table are First name, last name,
gender, MailID, contact, address, date of birth.
 In the table of staffs, the StaffID acts as the primary key for the unique identification
of the staff member. The attributes in this table are name, designation, age,
qualification, contact, MailID, and address.
 In the table of Course, the CourseID is the primary key and the attributes are Course
name, time period, and fees.
 The CourseID, StudentID, and the StaffID acts as the foreign key.
4

 In the table of the staff course table, the CourseID and Staff ID are the foreign keys
and the extra attribute is the shift.
 In the table of student course table, the CousrseID and the StudentID are the foreign
keys and the attributes added is the year of pursuing the course.
The database management system for the Torrens University of Australia should be such that
it can store the information related to the staffs of the university, student studying in the
university, and the types of course the university offers. It should also contain the information
regarding the fee structure of each course and should contain that which staff will teach will
teach which subject. In order to do this, the tables are created with the suitable attributes
names. The tables which are mentioned in the database are given below along with the
description:
1. Table of student
In this the table the records of the students are stored. In this the primary key is the
StudentID so that each student can uniquely identify. This is done to avoid the
duplicity in the data. The student table and the student course table have the one to
many relationships between them. This means that one student can be enrolled in
many courses.
Student (StudentID, Firstname, Lastname, Date of birth, Address, mailID, Contact,
Gender)
2. Table of staff
In this the table the records of the staffs are stored. In this the StaffID is the primary
key to make the unique identification of each staff. It has many attributes and also it
has the one to many relationships with the staff course table. It means that on teacher
can teach multiple subjects.
Staff (SatffID, Name, Designation, Age, Qualification, ContactNo, MailID, Address)
3. Table of course
This table consists the information regarding the course and its duration. In this the
CourseID is the primary key which helps for the unique identification of the course
and also consists many attributes. It has the one to many relationships with the table
of student course.
Course (CourseID, TimePeriod, Name, Fee)
4. Table of student course
5

In this the table the records of the student and the course information is stored. In this
the StudentID and the CourseID is made as the composite primary attributes so that
the redundancy can be removed. They are also made as the foreign keys as well. The
one to many relationships is made between this table and the student table and the
course table. StudentCourse (CourseID, StdntID, Year)
5. Table of staff course
In this table the records of the staff and the course information is stored. The
information tells us about the teaching of the course by the particular staff. It has the
one to many relationships with the course table and the staff table. The CourseID and
the StaffID are made as the composite primary attributes and the foreign key as well.
StaffCourse (CourseID, StaffID, Shift)
6

Conclusion
For the successful completion of this project, the five tables are made which contains the
details of the university students and staff records. It also includes the course information and
the related information according to it. The work is done on the excel workbook where the
records are stored and the different operation are performed. The main operations that are
performed on the records are the stored in different sheets of the same workbook. The
operation are updating of the record and the deletion of the record. It also includes the
addition of the more records. The entity diagram for the database management system is
drawn which shows the entities and their attributes along with the relationships among them.
It is done for the process of normalization so that the duplicities in the data can be removed.
7

References
Agrawal, S., Khan, A., & Kumar, K. (2018). U.S. Patent Application No. 15/700,363.
Held, B., Moriarty, B., & Richardson, T. (2019). Microsoft Excel Functions and Formulas.
Stylus Publishing, LLC.
Kosaraju, S., Nagisetty, H. B., Hiatt, J. D., & Allbright, J. A. (2019). U.S. Patent Application
No. 10/346,376.
Morris, C. A., Deochand, N., & Peterson, S. M. (2018). Using Microsoft Excel® to build a
customized partial-interval data collection system. Behavior analysis in practice, 11(4), 504-
516.
8