Question: Problem: For a long time the university tutoring program has used a paper schedule to sign students up for tutoring. Tutors identify their schedule for

 Problem: For a long time the university tutoring program has used

Problem: For a long time the university tutoring program has used a paper schedule to sign students up for tutoring. Tutors identify their schedule for a two-week period, and then a schedule is printed and placed in the computer lab. Students look through the schedule for sessions that match courses they are taking and the times they have available (see Figure 1 sample signup sheet). This system has worked and continues to work, but it has several significant problems. For one, it can be difficult for students to find appropriate tutoring sessions. The paper forms are difficult to navigate and understand. Additionally, it is very difficult for the tutoring program to track the students using the tutoring. It is difficult or impossible to track demographic information. It is also difficult to assure that students are enrolled in the courses they receive tutoring in. Even tracking tutors' hours can be difficult. A database with a client application could significantly improve the situation, by providing a flexible, searchable schedule for students; better tracking of demographics and eligibility, and better tracking of hours tutored. Scope: The tutoring database will manage data for the tutoring program at the university. It will track available tutors and the courses they can tutor. It will also track each tutor's tutoring schedule. The database will store demographic information for students who register for tutoring. This information will be private and used only to generate general reports which include no personal information (see Figure 2). Students who have registered will be able to sign up for available tutoring sessions for courses in which they are enrolled. The database will track whether students attended their scheduled sessions. It will also track student requests for tutoring in additional courses and subjects. Constraints: The database can be used to get the hours worked for each tutor, but it will not process any payroll information. The database will not validate student information against the school's registration database. Objectives Streamline the process by which the tutors enter their schedules and students sign up for them. Improve tracking of demographic data of students using the tutoring program. Improve tracking of tutors' hours and students' use of tutoring sessions. Track student requests for additional tutoring. Please conduct the database conceptual design Conceptual design --E-R Diagram/Cardinality/business rules Problem: For a long time the university tutoring program has used a paper schedule to sign students up for tutoring. Tutors identify their schedule for a two-week period, and then a schedule is printed and placed in the computer lab. Students look through the schedule for sessions that match courses they are taking and the times they have available (see Figure 1 sample signup sheet). This system has worked and continues to work, but it has several significant problems. For one, it can be difficult for students to find appropriate tutoring sessions. The paper forms are difficult to navigate and understand. Additionally, it is very difficult for the tutoring program to track the students using the tutoring. It is difficult or impossible to track demographic information. It is also difficult to assure that students are enrolled in the courses they receive tutoring in. Even tracking tutors' hours can be difficult. A database with a client application could significantly improve the situation, by providing a flexible, searchable schedule for students; better tracking of demographics and eligibility, and better tracking of hours tutored. Scope: The tutoring database will manage data for the tutoring program at the university. It will track available tutors and the courses they can tutor. It will also track each tutor's tutoring schedule. The database will store demographic information for students who register for tutoring. This information will be private and used only to generate general reports which include no personal information (see Figure 2). Students who have registered will be able to sign up for available tutoring sessions for courses in which they are enrolled. The database will track whether students attended their scheduled sessions. It will also track student requests for tutoring in additional courses and subjects. Constraints: The database can be used to get the hours worked for each tutor, but it will not process any payroll information. The database will not validate student information against the school's registration database. Objectives Streamline the process by which the tutors enter their schedules and students sign up for them. Improve tracking of demographic data of students using the tutoring program. Improve tracking of tutors' hours and students' use of tutoring sessions. Track student requests for additional tutoring. Please conduct the database conceptual design Conceptual design --E-R Diagram/Cardinality/business rules

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!