Data modeling and Database design

Running head: Data modeling and database design
Data Modelling & Database Design
Name of the Student
Name of the University
Author Note

1Data modeling and database design
Experience Description
Torren University Australia manages wide amount of student. Therefore there is a need
of new student record management system that will be capable of storing all the essential details.
The new record management system will be capable of organizing and managing the data for all
the enrolled student, stars and courses associated with them. It is expected that the new system
will allow the staff to add update and delete the records of the students based on their data. In
this assessment the main concern was to develop a proper information system that will store the
details of the student within the Torrens University. The university needs a new record
management system for improving the overall performance of the college. This will also
facilitate the students with proper access towards their data. With the help of database is
knowledge it became easy to develop the information system. In this paper we have focused on
developing different tables for different entities so that it becomes easy to store the details. The
tables that I created includes department, employees, salary. All the tables are being filled with
sufficient amount of data so that it becomes easy to display the essential requirements. This
assessment has helped me in obtaining knowledge about the way database are developed. Every
entity in the SQL is being populated with certain amount of data. In addition to these we have
also performed altar function, no selection function, add function for understanding the different
anomalies. Thus it can be stated that with proper knowledge of database which will become easy
to organize the data. Moreover with the help of new record management system it will become
easy to organize the data. Thus the above details related to the assessment will help in
understanding the activities that are carried out for designing the new system. The SQL
statements are designed effectively for the purpose of understanding the different components.

2Data modeling and database design
The student record management system is very important for the university because large
number of students takes admission in the university and the university needs to manage the
records of the students. The record of the students include students enrolled, courses in which the
students are enrolled and the staff those are facilitating the courses. The Torrens University has a
very strong system of information and the in-house students will develop the management
system for the university.
Managing the record of the student’s needs planning and management of time and
therefore the system those are automated is a necessity for the university. There are significant
advantages of the student record management system for the university. The advantages include:
 Smart management of data of student
 Avid the performance of the student
 Simplify and streamline everyday tasks
 It upgrades the communication between the students and the teachers
 Increased security of data
 Report management
 Simplified procedure of admission.
The system will permit the staff of the university to add, update and then delete the student
records, staffs those are assigned to the various courses and the courses of the students. The
staffs of the university should be able to view the list of the students that have enrolled in a
specific course that is facilitated by a specific facilitator.
The experience of creating the database for the students is very good and it was very
enjoyable when creating the databases of the students. The main activity includes creation of the