Question: Question I (70 points total) Consider the following relational database for storing data about employees and projects: employee (employee_id, name, annual salary) project (project_name, budget)

Question I (70 points total) Consider the following relational database for storing data about employees and projects: employee (employee_id, name, annual salary) project (project_name, budget) participates (employee_id, project_name) Assume that (i) each employee is assigned a unique ID, (i) each project is assigned a unique name, (iii) an employee may participate in multiple projects and multiple employees may participate in the same project, and (iv) some employees may not participate in tiny project. Question II (10 points total) Consider the relational database defined in Question I. Indicate whether each of the following is true or false. Clearly justify your answer. (a) (5 points) Due to the referential integrity constraint, any record in the employee relation cannot be deleted (i.e., no record in the employee relation can be deleted). (b) (5 points) The following SQL statement must use the distinct keyword to ensure that each employee ID appears only once in the query result: select distinct employee_id from employee natural join participates where annual salary > 100000 and project_name = 'X
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
