SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 04 Jan 2018 My Price 10.00

database table structures, via your selected RDBMS

Hi Harrikelie,

This assignment will due on 04/10/2017.  I have attached a Module 5 CT with this assignment.  Please, reply back in word document. Thank you

DML SQL and Advanced SELECT Queries (70 Points)

Enhance your Module 5 CT database table structures, via your selected RDBMS, as you wish.

Then, using SQL and an SQL script file, add at least five more rows of data to each of your tables.

Then, using SQL and an SQL script file, create and execute advanced queries of your choice that demonstrate each of the following:

  1. The use of a GROUP BY clause, with a HAVING clause, and one or more group functions
  2. The use of UNION operator
  3. The use of a subquery
  4. The use of an outer join

Then create and execute at least one SQL UPDATE and at least one SQL DELETE query.

Finally, create and use an SQL view and in a SELECT query.

Submit the following outputs of your SQL script file processing, in this order and appropriately labeled, in a single Word file:

  1. The SQL and results of your INSERT statements to further populate your tables
  2. The SQL and results of your 4  advanced SELECT queries
  3. The SQL and results of your UPDATE and DELETE queries
  4. The SQL and results of your view creation and its use in a SELECT query

You must show all of your SQL as it executed in Management Studio or other development environments. This includes the results returned by your selected RDBMS.

 

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 04 Jan 2018 02:01 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)