Unformatted text preview:

Part FourDescriptionWhat to Hand InPart FourTotal Points: 50 Total Weight: 5% Due: Tuesday, March 25, 2003, in class DescriptionIn this part, you will use Oracle SQL*PLUS environment to manipulate your database. The specifics are given below. 1. Try to query your database using SQL statements. You should try typing commandsdirectly, running commands from a .sql command file, and running commands from thecommand buffer.2. You should write at least one query from each of the following SQL query types. Some ofyour queries may be in more than one of these types. Your should write at least 10 queriesand they should be interesting in your application domain, that is, they shoulddemonstrate non-trivial ways of using the data in your database.a) Multiple table queryb) Nested query (both correlated and not correlated)c) Subquery connected by Union, Intersect, minusd) Query using exist, not exist, IN, NOT IN, ALL, etc.e) Query with aggregate functions, group by, sort by, havingf) Query that has a complex from clauseg) Query using a view3. You should issue at least two update commands of each of the following types:a) Insert tuples to a table (both single tuple and by a query)b) Delete tuples from a table (both single tuple and by a query)c) Update tuples (both single tuple and by a query)d) Update that activates a trigger.4. Design at least one view that is defined over multiple tables.5. Design at least one trigger.6. Design and perform experiments to investigate view update.While you are doing this part, keep in mind the following: - Test queries that your application may require. Think about how to retrieve the data that are needed to provide the functionality or services of your application program.- Specify each query in different ways. It is well known that SQL allows a query to be expressed in more than one way. Pay attention to whether the result contains duplicate.- Make sure that more than 95% of your non-trivial queries do get non-empty answers. Add more data to your database if necessary.- Come up with each query in English first and then translate it into SQL.What to Hand InHand in a hard copy of the extended report and including the following items:1. Everything in Part Three including any revisions (highlighted).2. For each query:a) a description in Englishb) the SQL required to perform the queryc) a brief explanation as to what makes this query useful and applicable. - The queries will be graded on the complexity, appropriateness, and applicability.3. A list of view and trigger definitions.4. A spool file showing the successful execution of your queries. Do not include long answers. Also, show the execution of your update


View Full Document

UTSA CS 3743 - Project

Download Project
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Project and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Project 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?