CS340Practice Problems.docx - CS340 Practice Problems...

This preview shows page 1 - 2 out of 8 pages.

CS340 Practice Problems Exercise 3.8 Answer each of the following questions briefly. The questions are based on the following relational schema: Emp( eid: integer, ename: string, age: integer, salary: Works( eid: integer, did: integer, pcttime: integer) Dept( did: integer, dname: string, budget: real, managerid: integer) 1. Give an example of a foreign key constraint that involves the Dept relation. What are the options for enforcing this constraint when a user attempts to delete a Dept tuple? real)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture