Show the resulting table when the following operation has be

Show the resulting table when the following operation has been performed on table 6 on page 588: Project onto Department and Room

TABLE 6 Class schedule. Course number Department 518 Computer Science 575 Mathematics 611 Mathematics 544 Physics Psychology 501 617 Psychology 335 Zoology Zoology 412 Room N521 N502 N521 B505 A 100 A110 A100 A 100 Time 2:00 P.M. 3:00 P.M. 4:00 P.M. 4:00 P.M. 3:00 P.M. 11:00 A.M. 9:00 A.M. 8:00 A.M.

Computer Science

Mathematics

Physics

Psychology

Zoology

projection operation outputs particular attributes removing the duplicates. Zoology 100 is duplicate . So it will be displayed once .

DepartmentR	Room
Computer Science	N521
Mathematics	N502
Mathematics	N521
Physics	B505
Psychology	A100
Psychology	A110
Zoology	A100

Show the resulting table when the following operation has been performed on table 6 on page 588: Project onto Department and Room TABLE 6 Class schedule. Course

Show the resulting table when the following operation has be

Solution

Get Help Now

Submit a Take Down Notice