Michael Ferree Assignment 6
Michael Ferree Assignment 6
Complete Exercise 5 on page 284 Write SQL commands for the following: a. Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the Student table. b. Now write a command that will remove Lopez from the Student table. c. Create an SQL command that will modify the name of course ISM 4212 from Database to Introduction to Relational Databases
Complete Exercise 6 on page 284 Write SQL queries to answer the following questions: a. Which students have an ID number that is less than 50000? b. What is the name of the faculty member whose ID is 4756? c. What is the smallest section number used in the first semester of 2008?
Complete Exercise 9 on page 284 Write SQL queries to answer the following questions: a. What are the courses included in the Section table? List each course only once. b. List all students in alphabetical order by StudentName. c. List the students who are enrolled in each course in Semester I, 2008. Group the students by the sections in which they are enrolled. d. List the courses available. Group them by course prefix. (ISM is the only prefix shown, but there are many others throughout the university.)
Tutors complete a certification class offered by the agency. Students complete an assessment interview that results in a report for the tutor and a recorded Read score. When matched with a student, a tutor meets with the student for one to four hours per week. Some students work with the same tutor for years, some for less than a month. Other students change tutors if their learning style does not match the tutor’s tutoring style. Many tutors are retired and are available to tutor only part of the year. Tutor status is recorded as Active, Temp Stop, or Dropped.
Complete Exercise 11 on page 284 11. List the tutors who took the certification class in January.
Complete Exercise 13 on page 284 Which student has the highest Read score?
Complete
Complete Exercise 5 on page 284 Write SQL commands for the following: a. Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the Student table. b. Now write a command that will remove Lopez from the Student table. c. Create an SQL command that will modify the name of course ISM 4212 from Database to Introduction to Relational Databases
Complete Exercise 6 on page 284 Write SQL queries to answer the following questions: a. Which students have an ID number that is less than 50000? b. What is the name of the faculty member whose ID is 4756? c. What is the smallest section number used in the first semester of 2008?
Complete Exercise 9 on page 284 Write SQL queries to answer the following questions: a. What are the courses included in the Section table? List each course only once. b. List all students in alphabetical order by StudentName. c. List the students who are enrolled in each course in Semester I, 2008. Group the students by the sections in which they are enrolled. d. List the courses available. Group them by course prefix. (ISM is the only prefix shown, but there are many others throughout the university.)
Tutors complete a certification class offered by the agency. Students complete an assessment interview that results in a report for the tutor and a recorded Read score. When matched with a student, a tutor meets with the student for one to four hours per week. Some students work with the same tutor for years, some for less than a month. Other students change tutors if their learning style does not match the tutor’s tutoring style. Many tutors are retired and are available to tutor only part of the year. Tutor status is recorded as Active, Temp Stop, or Dropped.
Complete Exercise 11 on page 284 11. List the tutors who took the certification class in January.
Complete Exercise 13 on page 284 Which student has the highest Read score?
Complete