1. Consider the following two relations for Millennium College: STUDENT(StudentID, StudentName, CampusAddress, GPA) REGISTRATION(StudentID, CourselD, Grade) Following is a typical query against these relations: SELECT Student_T.StudentID, StudentName, CourselD, Grade FROM Student_T, Registration_T WHERE Student_T.StudentID = Registration_T.StudentID AND GPA > 3.0 ORDER BY StudentName; a. On what attributes should indexes be defined to speed up this query? Give the reasons for each attribute selected. b. Write SQL commands to create indexes for each attribute you identified in part a.

1. Consider the following two relations for Millennium College: STUDENT(StudentID, StudentName, CampusAddress, GPA) REGISTRATION(StudentID, CourselD, Grade) Following is a typical query against these relations: SELECT Student_T.StudentID, StudentName, CourselD, Grade FROM Student_T, Registration_T WHERE Student_T.StudentID = Registration_T.StudentID AND GPA > 3.0 ORDER BY StudentName; a. On what attributes should indexes be defined to speed up this query? Give the reasons for each attribute selected. b. Write SQL commands to create indexes for each attribute you identified in part a.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

computer How would you rate Ada Lovelace?
Explain the importance of file retention and transfer.
Explain how patent rights may be used economically and protected.
Explain the implications of plagiarism in technical writing and how to prevent it.
Explain the steps involved in data processing.
A case study of an existing MIS is required. (MIS)
Computer science why electronic transactions including credit card numbers are risky.
Describe the many forms of electronic signatures.
Data communication , plz fast
Data refers to the format in which data is stored, processed, and transferred.
Explain the benefits and drawbacks of storing data in the cloud.