Data management on wilmington university

Student database management model provides information on students course schedule and their basic information. Course schedule homogeneous their major and minor names, courses Ames, 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. in the lead this data is farm animald is books and printed on paper. If there is a change in schedule or exam It would be difficult to r separately 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 tantrum 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 schoolbook subject matter. This is very easy model to use and we will bring out current data and will be secure.Therefore my design mainly foc uses on 2 antithetic users 1) Student 2) administrator Background 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 bespeak of this is that the make a marrow regarding he 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 Sec re Scalability Compatible with other systems necessitate large information of student data infobase expansion and maintenance. Secure backup and recoery 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 beget the capacity to hold 80,000 customer records at any time. The system should have the capacity to add 1 00,000 records a year for 10 years.The system should intrust 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 flesh out Student name, Student ID, USN number, Address, Phone Number, Date of Birth, Sex. Department details Department Name, Department code, College, off ice Number Course Details Course old. Course Name, Course level Attendance Total classes, No. Of classes present, No Of classes absent, Student ID psychometric test type Midterm exams, Final exams, Weekly Quiz, Exam IDText message phone number, reason for delay, time of class, date of class, addresses of the class Schedule Student ID, Course ID, Course name, class room no, Date, Time Supports Data attention for finding Student data in each Department Internal Average Marks Scored of a student. Attendance Shortage of pupil. Text message to each student Exam Result of student. Report Requirements 1. User feedback report. 2. Individual or Group Attendance Report. 3. Student wise Examination Report. 4. Student Detail. 5. Text message sent report 6. Examination time-table for different examinations.