jimena15
jimena15
22.07.2020 • 
Mathematics

Assuming that no new n-tuples are added, find the primary key(s) for the relations displayed in the following tables: A) Student, Major, Course
Glauser, Biology, BI 290
Glauser, Biology, MS 475
Glauser, Biology, PY 410
Marcus, Mathematics, MS 511
Marcus, Mathematics, MS 603
Marcus, Mathematics, CS 322
Miller, Computer Science, MS 575
Miller, Computer science, CS 455
B) Professor, Department,Course_number
Cruz, Zoology, 335
Cruz, Zoology, 412
Farber, Psychology, 501
Farber, Psychology, 617
Grammer, Physics, 544
Grammer, Physics, 551
Rosen, Computer Science, 518
Rosen, Mathematics, 575
C) Department, Course_number, Room, Time
Computer Science, 518, N521, 2:00 P.M.
Mathematics, 575, N502, 3:00 P.M.
Mathematics, 611, N521, 4:00 P.M.
Physics, 544, B505, 4:00 P.M.
Psychology, 501, A100, 3:00 P.M.
Psychology, 617, A110, 11:00 A.M.
Zoology, 335, A100, 9:00 A.M.
Zoology, 412, A100, 8:00 A.M.
D) Airline, Flight_number, Gate, Destination, Departure_time
Nadir, 122, 34, Detroit, 08:10
Acme, 221, 22, Denver, 08:17
Acme, 122, 33, Anchorage, 08:22
Acme, 323, 34, Honolulu, 08:30
Nadir, 199, 13, Detroit, 08:47
Acme, 222, 22, Denver, 09:10
Nadir, 322, 34, Detroit, 09:44

Solved
Show answers

Ask an AI advisor a question