Database 1

Quiz1_7 - Compatibility Mode - Saved to my Mac ut References Mailings Review View Tell me ***211 ABCODE " Aa A APA ABCDE No Soncino No T 1) Consider the following relation and then answer the questions that follow: SECTION SEC_ID 101 201 202 201 202 CRS ID GEIT 3341 GEIT 3341 GEIT 3341 GEIT 1311 GEIT 1311 TIME 10:00 13:00 14:00 10:00 13:00 DAYS UT UT UT MW MW LOCATION FO52 GOSO G049 F052 G049 1.1 Give an example of a superkey, (0.5 point) 1.2 Give an example of a key (0.5 point) 1.3 How many candidate keys are there and what are they? (0.5 point) 1.4 Which candidate key above you would choose as the primary key? (0.5 point) United States Focus 8 7 U A lil OF A TAI 21 AaBCcDdte AaBbccbdte AaBbCcD A Heading 1 Normal No Spacing 2) Consider the following relation and then answer the questions that follow: COURSE CRS_ID TITLE CRD_HOURS GEIT 1311 GEIT 1411 GEIT 1412 GEIT 2291 GEIT 3341 Computer Organization 3 Computer Science ! 3 Computer Science II Professional Ethics 2 Database 3 | | 2.1 What is the name of the primary key? (0.5 point) 2.2 Does this relation satisfy the entity integrity constraint? If no, explain why. (0.5 point) 2.3 In the SECTION relation in the first question, what is the name of the foreign key that corresponds to the primary key in this relation? (1 point) 2.4 Does the SECTION relation satisfy the referential integrity constraint? If not, explain why. (1 point) State) C Focus 2 Quiz1_7 - Compatibility Mode - Sivu References Mailings Review View Tell me FC 21 ABCDE AaCeDdle AaBCCD Aa A Abend Heading 2 Normal No Sotong Heading 1 3) Express the following queries in Relational Algebra making sure that your queries always work even if the contents of the corresponding relations change: 3.1 Find the employee first name, last name, and salary of all male employees. (2 points) 1 3.2 Find the first name and last name of all employees who have no dependents (3 points) O Focus I 111 E to