Onsider the following two relations for Millennium College: STUDENT(StudentID, StudentName, CampusAddress, GPA) REGISTRATION(StudentID, CourseID, Grade) Following is a typical query against these relations: SELECT Student_T. StudentID, StudentName, CourseID, Grade FROM Student_T, Registration_T WHERE Student_T. StudentID = Registration_T. StudentID AND GPA > 3.0 ORDER BY StudentName; On what attributes should indexes be defined to speed up this query? Give the reasons for each attribute selected.

Problem 1 - hashing we would like to use initials to locate an individual. for instance, mel should locate the person mark e. lehr. note: this is all upper case. generate a hash function for the above using the numbers on your telephone. you know, each letter has a number associated with it, so examine your telephone keypad. generate 512 random 3 letter initials and take statistics on a linked list array size 512 to hold this information report how many have no elements, 1 element, 2 elements, does this agree with the hashing statistics distribution?

Why should the technician watch for signs of contamination in the oil when recovering refrigerant from a system

3.12: the speed of sound the speed of sound depends on the material the sound is passing through. below is the approximate speed of sound (in feet per second) for air, water and steel: air: 1,100 feet per second water: 4,900 feet per second steel: 16,400 feet per second write a program class the speed of sound that asks the user to enter “air”, “water”, or “steel”, and the distance that a sound wave will travel in the medium. the program should then display the amount of time it will take. you can calculate the amount of time it takes sound to travel in air with the following formula: time = distance/1,100 you can calculate the amount of time it takes sound to travel in water with the following formula: time = distance/4,900 you can calculate the amount of time it takes sound to travel in steel with the following formula: time = distance/16,400