2(40 points : 25 for a, 5 for b, c, d) Physical database design: indexed cluster! Write SQL statements of the steps below in one script file and upload both the input script file and the runscript output to Blackboard. Add comments in your script for better readability; points will be deducted for a script with inadequate comment. a) Create an indexed cluster of the tables Department, Dept locations, and Project in the textbook Figure 5.7 (page 164). Specifically, cluster Dept locations and Project under Department using dnumber as the clustering key. Omit the foreign key constraint for mgrssn in the Department table, since the table Employee is omitted in this exercise. b) Insert the tuples shown in the textbook Figure 5.6 (page 162) into the clustered tables. Insert null for the column mgrssn of the Department table, since the table Employee is omitted in this exercise. c) Execute the following queries against the clustered tables: (1) retrieve tuples from each clustered table (i.e., Department, Dept locations, Project), (2) retrieve the location and the project (name) of a department named dministration. Note that, although the files of the three tables have been merged into one, we still see them as separate tables at the logical level d) Drop the index, clustered tables, and the cluster. 2(40 points : 25 for a, 5 for b, c, d) Physical database design: indexed cluster! Write SQL statements of the steps below in one script file and upload both the input script file and the runscript output to Blackboard. Add comments in your script for better readability; points will be deducted for a script with inadequate comment. a) Create an indexed cluster of the tables Department, Dept locations, and Project in the textbook Figure 5.7 (page 164). Specifically, cluster Dept locations and Project under Department using dnumber as the clustering key. Omit the foreign key constraint for mgrssn in the Department table, since the table Employee is omitted in this exercise. b) Insert the tuples shown in the textbook Figure 5.6 (page 162) into the clustered tables. Insert null for the column mgrssn of the Department table, since the table Employee is omitted in this exercise. c) Execute the following queries against the clustered tables: (1) retrieve tuples from each clustered table (i.e., Department, Dept locations, Project), (2) retrieve the location and the project (name) of a department named dministration. Note that, although the files of the three tables have been merged into one, we still see them as separate tables at the logical level d) Drop the index, clustered tables, and the cluster