DataBase:

1.

2.

3.

4.

UNIT P" UNIT CODE CHAR (8) UNIT_NAME VARCHAR (50) + ENROLMENT OCPF STU_NBR NUMERIC (8) PF UNIT CODE CHAR (8) PENROL YEAR NUMERIC (4) P ENROL SEMESTER CHAR (2) ENROL MARK NUMERIC 3) ENROL GRADE CHAR 2 STUDENT STU NBR NUMERIC (8) STU_LNAME VARCHAR (50) STUFNAME VARCHAR (50) STU DOB Date If we are going to create a database based on the above diagram, how many foreign key constraints do we need to create? Select one: O a. 2 O b. 4 O c. 3 O d. 6 A table can be deleted from the database by using the TABLE command. Select one: a. MODIFY O b. DELETE O c. DROP O d. ERASE The specification creates an individual index on a respective attribute; use it to avoid having duplicated values in a column. Select one: a. VARCHAR b. NOT NULL C. UPDATE d. UNIQUE UNIT - UNIT CODE CHAR (8) UNIT NAME VARCHAR (50) ++ ++ ENROLMENT OCPF STU_NBR NUMERIC (8) PF UNIT CODE CHAR (8) PENROL YEAR NUMERIC (4) - ENROL SEMESTER CHAR (2) ENROL_MARK NUMERIC 13) ENROL GRADE CHAR (2) STUDENT STU NBR NUMERIC (8) STULNAME VARCHAR (50) STU FNAME VARCHAR (50) * STU_DOB Date Which of the entities on the above diagram will be implemented as a table with a composite primary key? Select one: a. ENROLMENT O b. UNIT O c. UNIT and STUDENT d. STUDENT