Question

ID name dept_name salary 10101 Srinivasan Comp. Sci. 65000 12121 Wu Finance 90000 15151 Mozart Music 40000 22222 Einstein Physics 95000 32343 El Said History 60000 33456 Gold Physics 87000 45565 Katz Comp. Sci. 75000 58583 Califieri History 62000 76543 Singh Finance 80000 76766 Crick Biology 72000 83821 Brandt Comp. Sci. 92000 98345 Kim Elec. Eng. 80000 Figure 2.1 The instructor relation.

          ID
name
dept_name
salary
10101
Srinivasan Comp. Sci.
65000
12121
Wu
Finance
90000
15151
Mozart
Music
40000
22222
Einstein
Physics
95000
32343 El Said
History
60000
33456 Gold
Physics
87000
45565 Katz
Comp. Sci.
75000
58583
Califieri
History
62000
76543 Singh
Finance
80000
76766 Crick
Biology
72000
83821 Brandt
Comp. Sci.
92000
98345 Kim
Elec. Eng.
80000
Figure 2.1 The instructor relation.

ID
name
deptname
salary
10101
Srinivasan Comp. Sci.
65000
12121
Wu
Finance
90000
15151
Mozart
Music
40000
22222
Einstein
Physics
95000
32343 El Said
History
60000
33456 Gold
Physics
87000
45565 Katz
Comp. Sci.
75000
58583
Califieri
History
62000
76543 Singh
Finance
80000
76766 Crick
Biology
72000
83821 Brandt
Comp. Sci.
92000
98345 Kim
Elec. Eng.
80000
Figure 2.1 The instructor relation.

Added by Stephen V.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Shaik Dadasaheb

Step 1

The question asks if we can conclude that the name can be used as a superkey or primary key of the instructor. Show more…

Show all steps

Thanks for your feedback!

In the instance of the instructor shown in Figure 2.1, no two instructors have the same name (at this time). From this, can we conclude that the name can be used as a superkey (or primary key) of the instructor? ID name dept_name salary 10101 Srinivasan Comp. Sci. 65000 12121 Wu Finance 90000 15151 Mozart Music 40000 22222 Einstein Physics 95000 32343 El Said History 60000 33456 Gold Physics 87000 45565 Katz Comp. Sci. 75000 58583 Califieri History 62000 76543 Singh Finance 80000 76766 Crick Biology 72000 83821 Brandt Comp. Sci. 92000 98345 Kim Elec. Eng. 80000 Figure 2.1: The instructor relation.