Print a list of classes that mary calahan will be taking

Assignment Help Database Management System

Reference no: EM13751622

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.

Reference no: EM13751622

Questions Cloud

How witchcraft and discussion of witchcraft change in europe : Write a paper on how witchcraft and the discussion of witchcraft changed in Europe between the years 1300 and 1400.

Policy for business continuity for white house securitystaff : Create a three page policy for business continuity for the White House security staff. Prepare a plan based on the critical nature of information that is presented within the executive department and military strategies that are reviewed for actio..

Promoting partcipative management : What it takes to sell project managment. Promoting partcipative management

Compensation manager and the plant manager : You have received a memo from the firm's compensation manager that the salary survey of the local labor market for positions under your supervision has been tabulated and there is concern that wages paid within your department are 25 percent above..

Print a list of classes that mary calahan will be taking : Print a list of classes that Mary Calahan will be taking and Make a class list for Ocean Ecosytems. Include the instructors name

Disability culture compared to other cultural identities : How do you think the nature of disability, where disabilities can either be apparent or non-apparent, affects America's disability culture compared to other cultural identities Can you think of other non-apparent identities that are similar to dis..

Challenges in the global business environment : According to the textbook, ongoing challenges in the global business environment are mostly attributed to unethical business practices, failure to embrace technology advancements, and stiff competition among businesses. Use the Internet to researc..

Determine the range of meaning for bible and james : determine the range of meaning for Bible and James. List its possible meaning with each possible meaning list all the verses that all the verses that correspond to that meaning.

Iinterpersonal communication skills : Iinterpersonal communication skills and effective project management that helped me thrive in the workplace.

User Account

All Pages