Extra Credit Assignment: Create a Multiple Table Query Assignment

Extra Credit Assignment: Create a Multiple Table Query Assignment

This is a 300 point Extra Credit Assignment.

This assignment is an opportunity for some students to act as Teaching assistants (TA).  Good TA's 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 to create a Multiple Table Query Assignment.  Students in the course have been exposed to the framework of a Multiple Table Query Assignment.  They include a combination of Metadata, Information Requests, an ER Diagram in PDF format, 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 Multiple 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 Multiple Table Query Assignment.  There is a link in this module above this assignment link to submit a topic request.  

Important Requirement

To participate in this assignment, you must first submit your database topic request in the appropriate link to request to use your topic. .  I will reply with a confirmation of approval in the Comment Section of the Request Assignment.  Once you get approval, you may begin the assignment

At this point in the semester, you have been exposed to the format of Multiple TableTable 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 Multiple Table Query Homework Assignment.  The Multiple Table Query Assignments that you were given in the course have contained the following documents.

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 creates a table, and insert sample data into the table
4. An ER Diagram of your database in PDF Format

This Assignment Cannot Duplicate any Multiple 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 a testing database that creates a table, and inserts sample data into the table
3. ER Diagram in PDF Format

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

ER Diagram should contain the following requirements

• At Least two tables
• At least one relationship between two table
• Underlined Primary Keys
• Identifiable Foreign Keys
• Illustrated Cardinality

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

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.
   
   
4. ER Diagram in PDF Format
   
   
5. Relational Schema in Word Processing Format