| 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. 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. Select all columns and all rows from one table. Select 5 columns and all rows from one table. Select all columns and all rows from one view. Using a join on 2 tables, select all columns and all rows from the tables without the use of a Cartesian product. Select and order data retrieved from one table. Using a join on 3 tables, select 5 columns from the 3 tables. Use syntax that would limit the output to 10 rows. Select distinct rows using joins on 3 tables. Use GROUP BY & HAVING in a select statement using one or more tables. Use IN clause to select data from one or more tables. Select length of one column from one table (use LENGTH function). 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. 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. Perform 8 additional advanced (multiple table joins, sub-queries, aggregate, etc.) SQL statements.
|
