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.

Reviews

Write a Review

 

Database Management System Questions & Answers

  One of the needs that your client has is a databaseto

one of the needs that your client has is a database.to design a database a database planner should spend a considerable

  Root cause of problem if databse doesn-t give information

Company's databases do not give them with information required for market planning, lead generation, and account management. What does author say is root cause of this problem?

  How database solve multiple concurrent data management issue

Investigate how databases solve multiple concurrent data management issues comprising lost updates, deadlocks and different kinds of lock management styles.

  Create an actual web page document

Modify the XML document in Exercise 2 to include a namespace URL from which the elements of the XML document in Exercise 3 will be associated with. Make any changes to the XML document that are necessary as a result of the namespace URL inclusion.

  Explain good strategy for processing queries

Explain a good strategy for processing each of following queries. Determine all machines at Almaden plant. Determine employee 1 machine.

  Ensure the security of organizations distributed database

How can you make your database more hacker proof? How do you ensure the security of an organizations distributed database?

  Design a high-level conceptual view of a data warehouse by

an organization has several operational systems customer relationship management crm for marketing and sales enterprise

  Use of dictionary-managed tablespaces in database

our current database uses dictionary-managed tablespaces. In running various performance tuning scripts, you have discovered that one of these tablespaces seems to have run out of space long before you calculated that it would.

  Explain how the web user interfaces help donors

Explain how the Web user interfaces help donors to make decisions

  Create a use case diagram for osceolas operations

Use MS Visio to create a use case diagram for question 1, a selected class diagram for question 2, and a sequence diagram for question 3.

  What is the key value of the 4th index

What is the key value of the 4th index record on the top level, assuming each index record points to the record with the highest key value in a block of the next level down?

  Explain issues to convert relationship for new cardinality

Using example of vehicles and drivers, explain issues to convert relationship for new cardinality including new relationships and attributes for the tables.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd