Torrens University: Data Modelling and Database Design Report, MIS602

This report details the design of a student record management system database for Torrens University, addressing the need for efficient record-keeping of students, courses, and staff. The project aims to create a system allowing staff to manage student data, course assignments, and instructor allocations. It outlines functional and non-functional requirements, including user input validation, email capabilities, and transcript generation. The author discusses their experience creating Excel spreadsheets to model the database, including iterative versions with different attributes and data points. The report emphasizes the importance of such a system for academic progress tracking and administrative efficiency, highlighting benefits such as data independence, efficient data access, and data integrity. The student also reflects on the development process, learning about database creation and functionalities within Excel, and the overall benefits of a student management system for achieving academic goals.

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
Experience:
The Torrens University of Australia is interested in a new record management system
for the student. The system requires a database so that the students those are enrolled in the
university, the courses those are selected by the students and the staffs those are teaching the
courses (Belcher & Belcher, 2017). The system permits the staff to update, delete and add the
student record, the staffs those are allocated to the courses. The staffs of the university can
able to view the list of the students that have enrolled in a specific course by a specific
instructor.
The main objective of the project is to deploy the system and then test and authenticate the
system. The project is designed for the University and provides a student record management
system. The system is able to store the records of the students, the details of the teachers and
the subjects and the teachers those are allocated to the students. The development and the
maintenance of the records associating to the students are important in order to administer the
relationship between the student and the University and controlling the academic progress of
the student and measuring their accomplishment (Livingston, 2019). A student is a person
that can register in order to pursue a course or a program in the University. A data of the
student includes information those are directly associated to the student that consist of name
of the student, ID of the student, phone number, address, course allocated to the student and
the allocated teacher for that particular student. The records of the students should be kept
safely so that the other staffs of the University cannot access them (Livingston, 2017). The
systems have various functional and non-functional requirements. The system will permit the
registrar to send emails, the systems will process and then print out the transcript of the
students and the system will contain all the personal information about the student. The non-
functional requirements of the system include verification and the validation of the input of
the user and the user. The system will permit the admin to delete the records in the record

2Data Modelling and Database Design
management system. The record management system can be linked to a database and it will
be very easy for the administrator to maintain the database (Sullivan et al., 2016). The
administrator of the record management system has the power to add, delete, update, and
delete the records of the students and the staffs those are allocated to the students.
The new student record management system will serve purposes such as managing the
name of students those who are getting enrolled, staffs those who are coordinating with
students and many more. This database will contain data of the students who have been
enrolled in different courses in the university, courses offered as well as the staff assigned to
these courses. The university wants to develop a database management system that can
contain these interrelated data along with a specific set of programs so that that these data can
be accessed as and when required (Rajasulochana, Heggede & Jadhav, 2019). This will help
the university to store as well as retrieve data. The university can thus be benefitted from the
usage of this database in many ways. Firstly it will provide data independence, data can be
accessed efficiently, data integrity as well data security can be ensured and data can be
administered in a proper way. The data that is stored in the database can be accessed by much
number of users at a time.
The DBMS will support different functions which are common to many of the
applications that are accessing the data stored in this system. Centralization of the data will
help the university to access the data when required and make it easy for the users to retrieve
data. The system to be developed will give users the provision to add, update as well as delete
the records that have been stored anytime they want to (Wijekumar et al., 2016). The
university staff will be able to see the list of students in a specific course and the course
coordinator for the same. This database will help the university to organize data in a proper
way with the ease to access theses as and when required. Thus once implemented it will help
the management of the university to arrange the data in a proper way.

3Data Modelling and Database Design
The experience with the task is very good. I have learnt so many things from this task.
I have learnt how the database can be created by excel. For the task I have created four
versions of spreadsheets. The version 1 is consisting of 30 rows and 4 columns. The columns
are including student ID, student name, Student Mobile number and course. I have added that
in the excel sheet version 1. In the version 2 I have updated 2 of the records as well as I have
added 5 additional records. I have highlighted all the changes in the excel file. In the version
3 of the excel sheet I have added 2 more new attributes those are email id and tutor name, the
changes has been highlighted in the excel sheet. Lastly, in the version 4 of the excel database
5 of the attributes have been deleted from the sheet and added 5 more rows of data. The
overall experience with working in the excel was so good. I have learnt some functionalities
that can be performed using excel.
With the help of student management the university will get help for achieving the
academic goals. The management of student management system needs time management
and careful planning on everybody’s part. With the help of smart technologies the efficiency
of the teachers will be improved as well as it will help them to teach their student in the
unique most ways for bringing out the true creativity in them. The system will provide a 360
degree view for the students for managing the various requirements as well as the system will
help in tracking the educational performance of them.

4Data Modelling and Database Design
Bibliography:
Belcher, L. J., & Belcher, L. J. (2017). Does ‘Experience’Matter? Expertise and Voting
Patterns in a Student-Managed Investments Program. Southwestern Finance Association, 1-
27.
Hysmith, R. T. (2017). Impact of Student-managed Investment Fund Participation on
Financial Knowledge, Financial Satisfaction and Financial Behavior (Doctoral dissertation,
Northcentral University).
Livingston, L. (2017). Returns and Attribution from a Student-Managed Peer-to-Peer Loan
Fund. Revista Internacional Administracion & Finanzas, 9(1), 13-28.
Livingston, L. S. (2019). Skewness, Cryptocurrency, and Peer-To-Peer Loans: An Asset
Allocation Exercise for a Unique Student-Managed Fund. Business Education &
Accreditation, 11(1), 29-50.
Rajasulochana, S. R., Heggede, S., & Jadhav, A. M. (2019). Student-managed investment
course: A learner-centric approach to investment management. Cogent Economics &
Finance, 7(1), 1699390.
Roberts, B. S., Roberts, E. P., Reynolds, S., & Stein, A. F. (2019). Dental Students’ Use of
Student-Managed Google Docs and Other Technologies in Collaborative Learning. Journal
of dental education, 83(4), 437-444.
Sullivan, P., Pines, E., Sassenfeld, R., & Nogales, L. (2016). TRANSITING TO A
STUDENT-MANAGED MAKER SPACE. In VentureWell. Proceedings of Open, the
Annual Conference (p. 1). National Collegiate Inventors & Innovators Alliance.
Wijekumar, K. K., Meyer, B. J., Harris, K., Graham, S., & Beerwinkle, A. (2016).
Comparing learning outcomes and implementation factors from student-managed vs. teacher-

5Data Modelling and Database Design
managed intelligent tutoring systems. In Intelligent Tutoring Systems: Structure, Applications
and Challenges (pp. 175-200). Nova Science Publishers, Inc.