Given the following relation table state for PROJECT, where Pnumber is the primary key and Dnum refers to Dnum in another relation DEPARTMENT (Dnum. Dname), use it to answer the next few applicable questions. PROJECT Pname Pnumber Plocation Dnum ProductX 10 Bellaire 5 ProductX 11 Sugarland 5 ProductZ 12 Houston 5 Computerize 20 Stafford 4 Houston 5 Reorganize 40 Newbenefits 50 Stafford 4 Fig. 1: Table Project 1. Which of the following statements is correct about the table PROJECT? a. Pnumber {Pname. Plocation. Dnum) is a functional dependency b. Dnum Plocation is a functional dependency c. Dnum Pnumber is a functional dependency d. all of the above e. none of the above. 2. In Fig. 1, the relation Project is in a. BCNF. b. 3NF. c. 2NF. d. all of the above. e. none of the above. 3. Which of the following create table command is given most correctly for creating the table PROJECT? 1 a. CREATE TABLE PROJECT (Pname VARCHAR2(15), Pnumber. CHAR(1), Plocation VARCHAR2(15), Doum NUMBER(3)); b. CREATE TABLE PROJECT (Pname VARCHAR2(15), Pnumber NUMBER(3) NOT NULL, Plocation VARCHAR2(15), Dnum NUMBER(3), PRIMARY KEY (Pnumber), FOREIGN KEY (Dnum) REFERENCES DEPARTMENT(Dnum)); C. CREATE TABLE PROJECT (Pname VARCHAR2(15), Pnumber DATE, Plocation VARCHAR2(15), Dnum NUMBER(3), PRIMARY KEY (Pnumber), FOREIGN KEY (Dnum) REFERENCES DEPARTMENT(Dnum)); d. All of the above e. None of the above