Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2 We keep track for each student on what course sections he/her serves as a TA. TAs are hourly paid jobs. Depending on work load,
2 We keep track for each student on what course sections he/her serves as a TA. TAs are hourly paid jobs. Depending on work load, a student taking such a job may be paid by 5 hours/week, or 10 hours/week, or 15 hours/week, or 20 hours/week as the maximum. A student may serves for multiple sessions as far as the total number of hours is not beyond 20 hours/week. In addition, a course section may have multiple TAs taken by different students, but the total number of hours offered to TAs should not be beyond 20 hours. We also need to know if a student takes no TA jobs For example, the following is a TA assignment for Spring 2017 CS 101 CS 291 Session 1 Robert Li,Debora KumarNo TA 10 hours Ken Choi 5 hours Total: 15hours Session2 Session Scsion 2 Session Ken Choi 15 hours Debora Kumar Patrick Sutton 5 hours 0 hours Total 20 hours Total: 20 hours ota 15hours 0 hours Plcase Draw an ER diagram that represents this problem. More specifically, you need to (1) decide how many tables you would ike to use and what are they, (2) decide the fields used in each table, you may create necessary fields of your own. (3) identify the primary key for each table and its foreign keys if needed, (4) show the degree of participation for each relationship (5) include the following fields into a your relevant tables: . the email address of each student, . the Name of each student, * the phone number of each student, whether a student is taking a TA job if a student takes a TA job, how many hours for each session he serves . professor's evaluation on each TA who works for his her sessions
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started