Description Following are examples and syntax of index: CREATE INDEX index$\_$name ON Table$\_$Name$($column name$)$; $1.$ Create a nonclustered index for the column emp$\_$on of the table employee $.$ USE Company CREATE INDEX i$\_$empno ON employee$($emp$\_$on$)2.$ Create a unique nonclustered index on i$\_$empName for the column Fname on the Employee table. USE Company CREATE UNIQUE INDEX i$\_$empName ON Employee $($Fname$)3.$ Create a composite unique index i$\_$empno$\_$prno for the column emp$\_$on and project$\_$no on the works$\_$on table $.$ The compound values in both columns must be unique. Eighty percent of each index leaf page should be filled. USE Company CREATE UNIQUE INDEX i$\_$empno$\_$prno ON works$\_$on$($emp$\_$on$,$project$\_$no$)$ IMAM ABDULRAHMAN BIN FAISAL UNIVERSITY Practical Session Plan College Department Course College of Computer Science and Information Technology Computer Information Systems Database Concepts and Design CIS $321$ CIS $321$ Lab manual $55|$ Page WITH FILLFACTOR$=804.$ Create a clustered index for the column DNum of the table Project. USE Company CREATE INDEX i$\_$DNum ON Project$($Dnum ASC$)5.$ Drop Index Syntax : DROP INDEX IndexName ON TableName; $6.$ Create a non$-$unique index for each foreign key $.$ USE Company CREATE INDEX i$\_$emp$\_$deptno ON employee$($dept$\_$on$)$ CREATE INDEX i$\_$works$\_$empno ON works$\_$on$($emp$\_$on$)$ CREATE INDEX i$\_$works$\_$prno ON works$\_$on$($project$\_$on$)7.$ Create a composite index that includes all the columns specified in the WHERE clause of the SELECT statement. SELECT $*$ FROM works$\_$on WHERE emp$\_$no$=29346$ AND enter$\_$date$=1/4/1997$ USE Company ; CREATE INDEX i$\_$works ON works$\_$on $($emp$\_$no$,$enter$\_$date$)$; IMAM ABDULRAHMAN BIN FAISAL UNIVERSITY Practical Session Plan College Department Course College of Computer Science and Information Technology Computer Information Systems Database Concepts and Design CIS $321$ CIS $321$ Lab manual $56|$ Page Tasks$/$Assignments$($s$)1.$ Create a nonclustered index for the Plocation column of the Project table. Sixty percent of each index leaf page should be filled. Index Name :i$\_$Ploc. $2.$ Create a unique composite index for the DNumber and DName columns of the Department table. Index Name i$\_$Dep $3.$ Create a clustered index for the DNO column of the Employee table. Index Name i$\_$Dno $4.$ Delete index i$\_$Dno from Employee table.