What is the name of the connection you used to connect

Assignment Help Database Management System

Reference no: EM131901609

Lab

In this assignment, you will use the database you created for Lab Part 5 to write a variety of queries demonstrating your understanding of summary and aggregate queries; set operators, functions and formatting query results.

Business situation

You continue to respond to a variety of request that require you to use the database you created for Lab Part 5 (DDL attached to create the DB).

As you complete each task below, answer the questions that follow. Write all answers to the questions on this document.

1. You will use the tables from Lab Part 5 (DDL attached to create) to complete this assignment. Use the connection you used to complete Lab Part 5 to connect to the Oracle database using SQL Developer.

a. What is the name of the connection you used to connect to the Oracle Database?

2. For each query shown in the screen clipping below, write a question that the return set of the query answers. See the notes at the end of this assignment. Show evidence you successfully ran the queries.

3. Write original seven queries using the database you created for Lab Part 5 (DDL attached). Write one demonstrating your understanding of aggregate functions and set operators: AVE, CUBE ROLLUP, GROUPING, UNION, INTERSECT and MINUS.

a. For each query, write a question that the return set of the query answers in the space below. Place the sql for each query in a file named LabPart6.sql. Include a description of the query in the file.

4. List at least three resources in APA style that you used to complete the tasks in this assignment.

5. List three things that you learned from this assignment.

Attachment:- Lab.rar

Reference no: EM131901609

Questions Cloud

Why did you include or exclude data from the research : Specifically, AI can enhance and streamline hospital operations from diagnosis to treatment and from surgical procedures to therapy.

Tax codes economic impact on fiscal policy : What do you think of our super complicated tax system in relationship with the tax codes economic impact on fiscal policy?

How department will promote accountability more effectively : Develop a 1 page memo to your staff discussing how the department will promote accountability, reliability and integrity more effectively.

The higher irr-the two projects npv profiles will cross : Clifford Company is choosing between two projects. Since the smaller project has the higher IRR, the two projects’ NPV profiles will cross.

What is the name of the connection you used to connect : Write a variety of queries demonstrating your understanding of summary and aggregate queries; set operators, functions and formatting query results.

How would sociological perspectives view gay marriage : How would each of the three sociological perspectives view gay marriage? Which of the three would have the most positive view of non-traditional family.

Explain what emotional connection is there to the behavior : Explain what emotional connection is there to the using/behavior? Define and describe your personal standards of behavior for alcohol and drug use.

Write a report on stake holder analysis tool : You are asked to research a tool and write a little report on this tool. Tool is stake holder analysis. Create a report and present it to class

Determine which alternative has larger percentage of spread : The Wrigley Corporation needs to raise $38 million. The investment banking firm of Tinkers, Evers & Chance will handle the transaction.

User Account

All Pages