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.

This link is associated with the Extra Credit: Create Single Table Query Assignment Topic Request link.  In order to participate in this Extra Credit Assignment. Students must first submit a topic that they are interested in a Create Single Table Query Assignment.  The request for a topic must be placed in the link above this assignment link named Extra Credit: Create Single Table Query Assignment Topic Request. If the topic is approved in that link, a confirmation message will be sent to you.  If it is not approved, a message will be sent indicating to select a different topic for your request. Approved student submissions to this link will be processed.   Unapproved Topics will not be processed. 

This Submission Link is associated with the Create a Single Table Query Assignment.  In order to qualify to participate in the Create a Single Table Query Assignment, students must first submit their topic idea to this link.  Once approved, students' submissions to the Create a Single Table Query Assignment will be processed.  If the topic is not approved, submissions to the Create a Single Table Query Assignment  Link will not Be processed. 

This assignment is an opportunity for some students to act as Teaching Assistants (TA).  Good TAs are given the opportunity to create assignments and teach lessons to the class.  This Extra Credit Assignment provides the opportunity for some students to attempt to make a homework assignment for a future class.  The Homework Assignment is a Single Table Query Assignment.  Students in the course have been exposed to the framework of a Single Table Query Assignment.  They include a combination of Metadata, Information Requests, and a  SQL text file containing SQL statements to create a sample database with sample data.  To be granted an opportunity to participate in this Extra Credit Assignment, a student must submit an idea for a Single Table Query Assignment Topic and get it approved. After being approved, the student must then successfully create and submit all of the components for the Single Table Query Assignment  

Important Requirement

To participate in this assignment, you must first me an email with your database topic.  I will reply with a confirmation of approval.  Once you get approval, you may begin the 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 
2. A document containing at least five information requests for the assignment.
3. An SQL text file containing the SQL statements to create a testing database that creates and uses a database to create a table, and inserts 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 includes both an AND and an OR 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 each of the information requests.  This means that for each information request, the sample data should be able to return a result set with rows/tuples that match the information request.  

The Sample Data must include at least 10 rows of Sample Data

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 to 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.

You May Also Combine the two SQL Text Files into a Single SQL Text File