Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Modeling And Relational Databases

Authors: Terry Halpin, Tony Morgan

2nd Edition

0123735688, 978-0123735683

More Books

Students also viewed these Databases questions