Student Data Base Exercise

 

After you have successfully created all the tables given, load the following data.

Students

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           

 

Instructors

Norm Salvadori will be teaching sect 1 of the Wetlands Critters course and the Ocean Ecosystems course.  Terry Smith will be teaching Section 2 of Wetlands Critters.  John Wagner will teach Endangered Habitats course.

 

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

 

 

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