c$)$ ALTER TABLE WORKS$\_$ON ADD CONSTRAINT FK$1$ FOREIGN KEY $($Essn$)$ REFERENCES

EMPLOYEE $($Ssn$)$;

d$)$ None of the above.

Consider the following relation schema:

PRODUCT

Which of the following statements creates the above relation?

a$)$ CREATE TABLE PRODUCT $($

PID INT CHECK$($PID BETWEEN $1$ AND $1000),$ UNIQUE$($Name$),$

Name VARCHAR$(20)$ NOT NULL $,$ PRIMARY KEY $($PID$),$

Color VARCHAR$(5)$ DEFAULT 'White' CHECK$($Color IN$(\text{'}$Red$\text{'},$ 'Green', 'Blue',

'White'$)))$;

b$)$ CREATE TABLE PRODUCT $($

PID INT PRIMARY KEY CHECK PID $>0,$

Name VARCHAR$(20)$ NOT NULL UNIQUE,

Color VARCHAR$(5)$ DEFAULT 'White' CHECK$($Color IN$(\text{'}$Red$\text{'},$ 'Green', 'Blue',

'White'$)))$;

c$)$ CREATE TABLE PRODUCT $($

PID INT PRIMARY KEY CHECK$($PID$>0$ AND PID

Name VARCHAR$(20)$ REQUIRED UNIQUE,

Color VARCHAR$(5)$ DEFAULT 'White' CHECK$($Color IN$(\text{'}$Red$\text{'},$ 'Green', 'Blue',

'White'$)))$;

d$)$ None of the above.

Consider the following database state and SQL query.

SALESMAN

SELECT NAME

FROM SALESMAN

WHERE CITY IN $(\text{'}$Paris$\text{'},$ 'Cairo' $)$;

Which of the following represents the result of the above SQL query?

a$)$

b$)$

c$)$