Extra Credit: Create a Single Table Query Assignment

Extra Credit Assignment: Create a Single Table Query Assignment

This is a 200 point Extra Credit Assignment.

In the first half of the semester you were given several Single Table Query Assignments.  This assignment focuses on you becoming a Teaching Assistant (TA) for the class. As a TA you are assigned to create a new Single Table Query Homework Assignment.  The single table query assignments that you were given in the course have contained the following documents

This Assignment Cannot Duplicate any Single Table Query Assignment this semester  

1. A document containing the metadata and five information requests for the assignment.
2. An SQL text file containing the SQL statements to create testing database that creates a table, and insert sample data into the table

The Metadata Should contain the following columns

• Attribute Name
• Description of the Attribute
• Data Type of the Attribute
• Range or Constraints on values of the attribute

The Information request should contain the following categories of requests.

• A request that has a Boolean comparison in the condition
• A request that requires an OR operator in the condition
• A request that requires an AND operator in the condition.
• A request that includes a numeric comparison
• A request that includes a text comparison in the condition
• A request that requires the listing of all tuples in the table

You should also provide a set of successful SELECT queries that can extract data for data for each of the information request.  

Submit the following documents for this extra credit assignment

1. A Word Processing Document containing a table illustrating the metadata and the five-information request for the assignment

2. A SQL Text File containing the SQL commands to DROP the Database if it exists create the Database if it does not exist, create the table, and insert the sample test data into the table.

3. A SQL Text File containing the SQL SELECT Queries for each of the information requests.