3. Let I be the set of math instructors at EWU, C the set of MATH course numbers
ID: 3196851 • Letter: 3
Question
3. Let I be the set of math instructors at EWU, C the set of MATH course numbers, S the set of possible section numbers, T the set of possible starting times, and R the set of classrooms at EWU. Let M be the subset of 1 × C × S × T × R containing the following 5-tuples Instructor Cour Section Tim Room Dempsey 141 Dempsey 141 Dempsey161 Graham 142 Graham161 107 107 107 161 161 301 107 107 141 142 142 141 9:00 SNR 204 10:00 SNR 204 8:00 SNR 204 9:00 KGS 233 12:00 HAR 117 Noon Noon Noon Riggs Riggs Riggs Stuart Stuart Stuart Wehr Wehr Wehr 200 HAR 117 8:00 KGS 227 12:00 ISL 137 1:00 KGS 233 9:00 PAT 144 11:00 KGS 228 12:00 SNR 201 9:00 KGS 334 10:00 KGS 334 12:00 KGS 234 10:00 KGS 333 1:00 KGS 234 2:00 KGS 234 10 3 Display the table produced by applying the following projections to M a. 3 2,3,4 e. Find all composite keys of M consisting of only two fieldsExplanation / Answer
For P3
Section
2
3
1
2
4
1
6
10
2
3
2
3
4
5
3
5
6
For P(1,2)
Instructor Course
Dempsey 141
Dempsey 141
Dempsey 161
Graham 142
Graham 161
Noon 107
Noon 107
Noon 107
Riggs 161
Riggs 161
Riggs 301
Stuart 107
Stuart 107
Stuart 141
Wehr 142
Wehr 142
Wehr 141
P1,5
Dempsey SNR 204
Dempsey SNR 204
Dempsey SNR 204
Graham KGS 233
Graham HAR 117
Noon KGS 227
Noon ISL 137
Noon KGS 233
Riggs PAT 144
Riggs KGS 228
Riggs SNR 201
Stuart KGS 334
Stuart KGS 334
Stuart KGS 234
Wehr KGS 333
Wehr KGS 234
Wehr KGS 234
P2,3,4
141 2 9:00
141 3 10:00
161 1 8:00
142 2 9:00
161 4 12:00
107 1 8:00
107 6 12:00
107 10 1:00
161 2 9:00
161 3 11:00
301 2 12:00
107 3 9:00
107 4 10:00
141 5 12:00
142 3 10:00
142 5 1:00
141 6 2:00
To find all composite keys of M consists of only two fields
Dempsey 141
Dempsey 141
Noon 107
Noon 107
Noon 107
Riggs 161
Riggs 161
Stuart 107
Stuart 107
Wehr 142
Wehr 142
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.