Question: PLEASE ANSWER b part . PLEASE ANSWER ASAP!!! ecording Q.1. (14 pts) Consider the following table with the give assumptions. Student (StudentID, FirstName, LastName, Gender,

PLEASE ANSWER b part . PLEASE ANSWER ASAP!!!
ecording "Q.1. (14 pts) Consider the following table with the give assumptions. Student (StudentID, FirstName, LastName, Gender, Age, DepartmentID) Assumptions: There is no index. There are total 150,000 rows. 2,000 rows fall within the 35 to 40 age range. There 40 rows for each page. 100 index rows fit on a non-clustered index leaf page. a) (7 pts] Create Nonclustered Index Ixl on Student (Age); Select Student ID from Student Where Age>=35 and Age=35 and Age
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
