Textbook http://www2.fiit.stuba.sk/~kvasnicka/Mathematics%20for%20Informatics/Ro
ID: 3775825 • Letter: T
Question
Textbook http://www2.fiit.stuba.sk/~kvasnicka/Mathematics%20for%20Informatics/Rosen_Discrete_Mathematics_and_Its_Applications_7th_Edition.pdf
(3) (8 points) Show the resulting table when the following operation has been performed on table 6 on page 588: Project onto Department and Room
Table 6
Department
Course Number
Room
Time
Computer Science
518
N521
2.00 PM
Mathematics
575
N502
3.00 PM
Mathematics
611
N521
4.00 PM
Physics
544
B505
4.00 PM
Psychology
501
A100
3.00 PM
Psychology
617
A110
11.00 AM
Zoology
335
A100
9.00 AM
Zoology
412
A100
8.00 AM
Department
Course Number
Room
Time
Computer Science
518
N521
2.00 PM
Mathematics
575
N502
3.00 PM
Mathematics
611
N521
4.00 PM
Physics
544
B505
4.00 PM
Psychology
501
A100
3.00 PM
Psychology
617
A110
11.00 AM
Zoology
335
A100
9.00 AM
Zoology
412
A100
8.00 AM
Explanation / Answer
projection is a unary operation.
upon projection on a table, the projected attributes exist and remining will be discarded.
New table
Department | Room
Computer Scinece | N521
Mathematics | N502
Mathematics | N521
Physics | B505
Psychology | A100
Psychology | A110
Zoology | A100
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.