3) It is desirable to provide a simple class roster for a section. This should include the student id, student name, student rank, and student major for all students in the section. First write an SQL query to provide this. You can use a section number of your choice. Then write a statement creating a view to make this query easier to write. Then rewrite the query using your view.

10. when you create a pivottable, you need to specify where to find the data for the pivottable. is it true

Allison and her group have completed the data entry for their spreadsheet project. they are in the process of formatting the data to make it easier to read and understand. the title is located in cell a5. the group has decided to merge cells a3: a7 to attempt to center the title over the data. after the merge, allison points out that it is not centered and looks bad. where would the title appear if allison unmerged the cells in an attempt to fix the title problem?

Identify an advantage of centralized processing