DATA MANAGEMENT PROJECT
STUDENT DATA MANAGEMENT ALONG WITH ALERT MESSAGE TO PHONE ALAVALA MANOHAR REDDY
IST 7000 WILMINGTION UNIVERSITY
Database management is used all over the companies, educational institutions, government and private sectors around the world where we need to store and organize the data. Coming to the universities, database management is the essential part where there are large number of departments, courses and students. Student database management model provides information on student’s course schedule and their basic information. Course schedule like their major and minor names, courses names, course id, instructor names, day, time, room number, credits per course and student details like student name, addresses, contact number, date of birth, student id. Before this data is stored is books and printed on paper. If there is a change in schedule or exam it would be difficult to reach about this to the students. Now it is easy store and change information by this we can save time and paper. After the registration the course information is directly stored in the database. Now if we want to view course schedule we can simply go to database of the university and check it out and change in schedule can directly reached to mobile by text message. This is very easy model to use and we will get current data and will be secure. Therefore my design mainly focuses on 2 different users: 1) Student
Wilmington university is a fast growing private non-profit university in u,s. For the convenience of students they added student schedule and exam details to the blackboard and when there is change in the class room, date and time it will informed through text messaging immediately when uploaded in the student database. The main aim of this is that the make a message regarding the class as possible for student convenience. Background Information: Upholding an effective system can be done by using good software and hardware requirements specifications that provide the following: System Needs
User - Accessible
Compatible with other systems
Hold large information of student data
Database expansion and maintenance.
Secure backup and recovery
Facilitate resource sharing through the internet all over the university Business Goals:
Increase the ability of storing data and make it available to users. Provides data to the user in seconds.
It should be helpful to the management to get information to get data of the registered student profiles. Easy to inform the attendance of students and those who are get promoted to next semester. Easy to inform the students about the alerts of the class schedule via text message User Requirements:
Data of the student should be made available and be stored within 3 seconds. The system should be accessible for 24 hours.
The system should have the capacity to hold 80,000 customer records at any time. The system should have the capacity to add 100,000 records a year for 10 years. The system should send Text messages to all students in database. Data Model
For this model I am relational database model through which entities, attributes and relations can expressed Data requirements
Student Details: Student name, Student ID, SSN number, Address, Phone Number, Date of Birth, Sex. Department details: Department Name, Department code, College, office Number Course Details: Course Id, Course Name, Course level
Attendance: Total classes, No. Of classes present, No Of classes absent, Student ID
Exam type: Midterm exams, Final exams, Weekly Quiz, Exam ID
Text message: phone number, reason for delay, time of class, date of class, addresses of the class Schedule:...
References: 1. Kumar, A. S. (2012, November 13). Student Database Management system. Retrievedfromhttp://www.academia.edu/6421360/Student_Database_Management_System
2. Vishnu, S. (n.d.). Student Database Management System. Retrieved from Slideshare.net:http://www.slideshare.net/SnehalVRaut/student-database-management-system-finale-23136675
Please join StudyMode to read the full document