. Consider the following ER diagram. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible.

name

ssn

s

cost

Policy uyyih

pname

age

Employee

Dependent s

B. Assume we have the following instances for two tables Employee and Dept-Policy:

Dept-Policy

Homework 2 will focus on problems from chapters 3, 4 and 5 of the book. (30 points) Q1. A. Consider the following ER diagram. Write SQL statements to create the corresponding relations and capture as many of the constraints as possible name ssn cost pname age Employee olicy Dependent B. Assume we have the following instances for two tables Employee and Dept-Policy: Dept-Polic,y Employee ssn pnameage cost 5381 Jack 5381 Sara 5382 Jill 100 SSnname 100 60 12 5380 Emily 5381 John 5382 Ali 5 What will be the new instances of the tables Employee and Dept-Policy after running the following query? DELETE FROM Employee E WHERE E.sSn5381