Purchase Solution

SQL Scripts for Data Manipulation

Not what you're looking for?

Ask Custom Question

I do not understand how to provide scripts that would build tables, insert data and query data from tables. Please get me started with this and I will add the data if someone can get me in the right direction. Our instruction states, "Bypass the Oracle Database requirement and only provide
scripts that simulate the activity required by the assignment.  Hopefully this will eliminate the frustration typically encountered with trying to gain
access to the Oracle database.   If you elect this option, you should provide the scripts that you "would" execute to build your tables, insert the data, and query data from the tables."

Also this is project 2 of our assignment. To give you an idea of this assignment, attached is project one which I have completed several weeks ago.

Purchase this Solution

Solution Preview

I believe what you are looking for are SQL scripts that would do the building of table, inserting of data and querying of data. These scripts are simple text files and are usually saved with the extension .sql. See my examples below of scripts that do those three things.

Create Table - This script would create a table called ...

Purchase this Solution

Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Javscript Basics

Quiz on basics of javascript programming language.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

C++ Operators

This quiz tests a student's knowledge about C++ operators.