Project #27585 - Relational Database Systems-Lab Project

(Part 4 of the Lab)

 

I have included the completed Lab 1-3 as a reference, and the instructions, please do part 4.

 

PART 4 - DML (Data Manipulation Language)

Once all objects have been created in the database, insert statements (DML) are developed using SQL for inserting data into respective entities. SQL select statements (basic & advanced) are developed for selecting and developing reports from the data inserted.

  • Insert statements - each entity (table) should have a minimum of 10 rows
  • Select Statements - minimum 20 Queries / SQL select statements  

Note: You should have a minimum of 20 SQL select statements. Query 1 to 14 (see below) are required, plus at least 6 advanced queries. Each query should have comment/description to explain its business purpose.

Ref: Chapters 7 & 8 (Database Systems Text Book - Coronel, Morris & Rob)

  1. Select all columns and all rows from one table.
  2. Select 5 columns and all rows from one table
  3. Using a Join on 2 tables, select all columns and all rows from the tables without the use of a Cartesian product.
  4. Select and Order data retrieved from one table  
  5. Using a join on 3 tables, select 5 columns and 10 rows from the 3 tables without the use of a Cartesian product.
  6. Select distinct rows using joins on 3 tables without the use of a Cartesian product.  
  7. Using a join on 2 tables, select all columns and 10 rows from the 2 tables without the use of a Cartesian product. 
  8. Use group by & having in a select statement using one or more table(s) (If more than 1 table then, don’t use a Cartesian product).
  9. Use IN clause to select data from one or more tables (If more than 1 table used then, don’t use a Cartesian product).
  10. Select Length of one column from one table (use Length function)
  11. Use a column alias
  12. Perform an advanced query of your choice from chapter 8 (Database Systems Text Book - Coronel, Morris & Rob)
  13. Use an aggregate function and perform another query
  14. Use the UPDATE command and change some data.
  15. Perform additional SQL statements (advanced - Chapter 8 Database Systems Text Book - Coronel, Morris & Rob)

Subject Computer
Due By (Pacific Time) 04/14/2014 06:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy