Consider the relational database shown in the exhibit. What is the foreign key in this database?
The exhibit shows a table called Activity Relation that relates a unique student identification
number with a sports activity and a fee for participating in that activity. A student can participate
in only one activity. The key for the relation is Student_ID. What consequence would occur if the
tuple for Student_ID 1001 were removed?
Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship
between the two entities is shown?
The database manager wants to give Rubio and Doe the ability to modify the Project Relation
shown in the exhibit. A temporary employee named Temp needs to access the data in the database
to generate reports. Which group of SQL statements will perform this task?
Which term describes an attribute or combination of attributes that uniquely identifies a row in
a relation?
