Management information system 301
Q1) Design a table that will collect applications from XYZ students who wish to become tutors. Call this table "tutor applications." A tutor applicant must specify hisher studentID and the code of the courses s /he wants to serve as a tutor for. Q2) Design a query that will list eligible tutors for a particular course, say MGIS 301. Students with a GPA of 3.0 or higher are eligible to become tutors. A student must have earned a grade of at least B+ in the course s/he wants to tutor. You may assume grade/ GPA information is available in the Academic Information System of the University, or if you prefer, you may define them as fields in your tutor applications table. Q3) Assume that LTO has reviewed all tutor applications, verified and determined the approved tutors for each course. LTO assigns each tutor to one course only. Design a table that will collect schedule information from hired tutors based on a flexible schedule. A flexible schedule means that the tutor will report hisher times as specific dates/times (e.g. December 5 Monday, 14:00, December 7 Wednesday 12:00, etc.). Q4) LTO needs a mechanism to book available tutoring sessions. Each tutoring session can be attended by up to three students. If a tutoring session is booked by a student and is attended, both the student and the tutor provide completion information to the system. The student enters a confidential evaluation for the session (chooses one of the following: not helpful at all=0/helpful=1/very helpful =2 ). The tutor simply verifies that the session took place and enters any comments she might have. Build the necessary table(s) to track offered and realized sessions. Use the templates below to build your tables and queries. Replicate them as needed. Indicate relationships among your tables. You may also state any assumptions you have to make or any limitations of your design. Q1) Design a table that will collect applications from XYZ students who wish to become tutors. Call this table "tutor applications." A tutor applicant must specify hisher studentID and the code of the courses s /he wants to serve as a tutor for. Q2) Design a query that will list eligible tutors for a particular course, say MGIS 301. Students with a GPA of 3.0 or higher are eligible to become tutors. A student must have earned a grade of at least B+ in the course s/he wants to tutor. You may assume grade/ GPA information is available in the Academic Information System of the University, or if you prefer, you may define them as fields in your tutor applications table. Q3) Assume that LTO has reviewed all tutor applications, verified and determined the approved tutors for each course. LTO assigns each tutor to one course only. Design a table that will collect schedule information from hired tutors based on a flexible schedule. A flexible schedule means that the tutor will report hisher times as specific dates/times (e.g. December 5 Monday, 14:00, December 7 Wednesday 12:00, etc.). Q4) LTO needs a mechanism to book available tutoring sessions. Each tutoring session can be attended by up to three students. If a tutoring session is booked by a student and is attended, both the student and the tutor provide completion information to the system. The student enters a confidential evaluation for the session (chooses one of the following: not helpful at all=0/helpful=1/very helpful =2 ). The tutor simply verifies that the session took place and enters any comments she might have. Build the necessary table(s) to track offered and realized sessions. Use the templates below to build your tables and queries. Replicate them as needed. Indicate relationships among your tables. You may also state any assumptions you have to make or any limitations of your design
