Develop sql select statements to query your tables

Assignment Help PL-SQL Programming

Reference no: EM131145545

Create SQL INSERT statements (DML) to populate each table with sample data. Then develop SQL SELECT statements to query your tables.

- INSERT statements - each table should have a minimum of 10 rows unless you have specific business rules that prevent it from having that many records.

- SELECT Statements - minimum 20 Queries.

Note: You should have a minimum of 20 SQL select statements. Query 1 to 12 (see below) are required, plus at least 8 advanced queries. Each query should have comment/description to explain its business purpose, as well as which requirement item you are satisfying (i.e., --1. Select all columns and all rows from one table).

Please submit both query statements and query results.

1. Select all columns and all rows from one table.

2. Select 5 columns and all rows from one table.

3. Select all columns and all rows from one view.

4. Using a join on 2 tables, select all columns and all rows from the tables without the use of a Cartesian product.

5. Select and order data retrieved from one table.

6. Using a join on 3 tables, select 5 columns from the 3 tables. Use syntax that would limit the output to 10 rows.

7. Select distinct rows using joins on 3 tables.

8. Use GROUP BY & HAVING in a select statement using one or more tables.

9. Use IN clause to select data from one or more tables.

10.Select length of one column from one table (use LENGTH function).

11.Use the SQL DELETE statement to delete one record from one table. Add select statements to demonstrate the table contents before and after the DELETE statement. Make sure to use ROLLBACK afterwards so that the data will not be physically removed.

12.Use the SQL UPDATE statement to change some data. Add select statements to demonstrate the table contents before and after the UPDATE statement. You can either COMMIT or ROLLBACK afterwards.

13.Using Coronel, Morris and Rob's definition of Advanced SQL (Chapter 8), perform 8 additional advanced (multiple table joins, sub-queries, aggregate, etc.) SQL statements.
Once all objects have been created in the database, create SQL INSERT statements (DML) to populate each table with sample data. Then develop SQL SELECT statements to query your tables. ? INSERT state

Reference no: EM131145545

Questions Cloud

Explain type of economy that exists in your selected country : Determine the type of economy that exists in your selected country - closed, mixed, or market. What is the difference between these types of economies and how might this affect your expansion?

Define and give an example of the curse of knowledge : Define and give an example of the "Curse of Knowledge" in communication? List, define and give example of 3 way to reach a conflict resolution

Find the average value above which only 15 percent would lie : The average and standard deviation of the amount of Goods and Services tax remitted by performance artists in a twelve month period were $5.042 thous and $1.551 thous respectively. If a sample of 110 artists was taken, find the average value above wh..

What is the nature of the process fluid : (a) What is the nature of the process fluid?(b) What are the objectives of the two sample points and in what way do the samples reaching the instruments differ?(c) Could the effectiveness of the second sample probe be improved and if so how?

Develop sql select statements to query your tables : Create SQL INSERT statements (DML) to populate each table with sample data. Then develop SQL SELECT statements to query your tables.

Paper - sexism in the workplace : Management Final Paper- Topic: Sexism In the Workplace

Explain analysis of impact that government policies address : Explain An analysis of the impact that government policies addressing income inequity and poverty could have on Libor demand or supply.

Find high quality research report related to green computing : Prepare a responsibility assignment matrix in RACI chart format based on the WBS you created earlier and the information you have on project team members and other stakeholders. Use the template (ram.xls) and samples in the text. Document key assu..

How can macy corporation apply cultural change orginization : How can Macy’s corporation apply cultural change to the organization to improve overall growth of the company as a whole?

User Account

All Pages