Student Data Base Exercise
After you have successfully created all the tables given, load the following data.
|
|
|
|
|
Students
|
|
|
|
|
|
|
|
firstName
|
lastName
|
|
|
Marge
|
Trechle
|
|
|
Thomas
|
Newburry
|
|
|
Cindy
|
Crumple
|
|
|
Icculus
|
McMan
|
|
|
Hope
|
McMan
|
|
|
Mary
|
Calahan
|
|
|
Beth
|
Schavinsky
|
|
|
Todd
|
Relve
|
|
|
Belinda
|
Myers
|
|
|
Keith
|
Snyder
|
|
|
Geoff
|
Hamilton
|
|
|
Kenneth
|
Snyder
|
|
|
Hope
|
Wilson
|
|
|
Mary
|
Schneable
|
|
|
Barbara
|
Schavinsky
|
|
|
|
Courses
|
|
|
|
|
|
|
|
|
Course ID
|
Course Name
|
Sec #
|
Instructor Id
|
|
1
|
Wetland Critters
|
1
|
|
|
2
|
Wetland Critters
|
50
|
|
|
3
|
Ocean Ecosystems
|
1
|
|
|
4
|
Endagered Habitats
|
1
|
|
|
Instructors
|
|
|
|
|
|
|
Instuctor Id
|
First Name
|
Last Name
|
|
1
|
Norm
|
Salvadori
|
|
2
|
Terry
|
Smith
|
|
3
|
John
|
Wagner
|
|
|
|
|
1 The following students have elected the course entitled Wetlands Critters;
Marge Trechle Sec 1
Thomas Newburry
Cindy Crumple
Icculus McMan
Hope Wilson
Mary Calahan Sec 2
Beth Schavinsky
Todd Relve
Belinda Myers
Keith Snyder
2 The following students have elected the course entitled Ocean Ecosystems;
Marge Trechle
Todd Relve
Beth Schavinsky
Geoff Hamilton
Keith Snyder
Mary Schneable
Barbara Schavinsky
3 The following students have elected the course entitled Endangered Habitats;
Mary Calahan
Icculus McMan
Hope Wilson
Cindy Crumple
Belinda Myers
QUERIES
1. Print a list of classes that Mary Calahan will be taking.
2. Make a class list for Ocean Ecosytems. Include the instructors name
3. Make a class list for all classes and sort then by class name.
4. Use the query developed in #3 but sort the students by First name , Last name.