---Check IF DB By The Name INDEX_TST_DB Exists? -- If Exists Drop The Database -- If Not Create A New DataBase By The Name INDEX_TST_DB --1-- --Create New Table By The Name Students: -- Columns: -- Stu_ID (Id value should be from 1 to 5) -- Stu_Name -- Stu_Grade_Avg -- Insert At least 5 Rows Of Data Into The Table. --2-- --Create UNIQUE CONSTRAINT and Nunclusterd index On The Stu_ID Column. --Run A Query From The sys.indexes Tabel: /* select * from sys.indexes where name = */ --3-- --Create primary key and clusterd index On The Stu_ID Column. --4-- --Drop the Primary Key You Just Created --5-- --Create primary key and nonclustered index On The Stu_ID Column. --6-- --Create A Clustered Index For The Stu_ID Column (With Your Name Of Choice). -- Run The Query With Display Estimated Execution Plan: -- Select * from students where stu_id between 1 and 5 -- --7-- --Drop the Clustered Index -- Run The Query Again With Display Estimated Execution Plan -- Select * from students where stu_id between 1 and 5 -- Drop The Clustered Index --8-- -- Run The Query With Display Estimated Execution Plan: -- Select * from students where stu_name = --9-- -- Create A Non Clustered Index On The Stu_Name Column (With Your Name Of Choice). -- With the include statement --10-- -- Run Again The Query With Display Estimated Execution Plan: -- Select * from students where stu_name = --11-- -- Drop The Students Table -- Create Partitions For The Stu_Grade_Avg Column.