Assignment: Single Table Queries: House Table

Follow the instructions in the attached MS Word Document

This assignment is a second attempt at mastering the basic context and syntax single table queries.  Complete the single table queries to respond to written information request in the attached documents.  You should review the document that I released by email outlining the answers and explanations for the first set of single table queries before attempting this second set of single table queries.  Students who did not perform well on the first set of single table queries can use the score from this second set of queries to replace the score of their score in the first single table query assignment.  Once again the assignment is both Word and PDF formats.  You may type your answers in the word document or in the text editor of Canvas

 Examine the Metadata/Data Dictionary in the attached PDF file.  We will review in class what the term metadata means. If you want to get ahead, read the documents named “Using Database Management Systems” in the Database Module.   Write queries to respond to the five information requests in the attached PDF file. We will review and practice in class, how to write and test single table queries in a Relational Database Management System (RDBMS).   Use the metadata in the file to assist you understanding the defined structure of the student table.  Use the metadata to correctly write the queries for the 5 requests for information in the attached PDF document.  Write your queries in a MS Word document and upload the completed document into the drop box in this assignment link. Your answers can be submitted as Text File, or type directly into the submission text area

 Remember that the Single Table Query Assignment is a written assignment.  You are not required to actually execute the queries on an actual Relational Database Management System (RDBMS).  However, a RDBMS will be provided.  For this assignment you should participate in the in class activities to get a framework for writing and testing these types of single table queries. . You will have the opportunity to actually run and test the queries that you write in a relational database management system.  In class, I will review how to start MySQL, a relational database management system (RDBMS).  Additionally, I will review how to setup a test environment in MySQL that you can attempt to run your single table queries.  With the test environment setup, MySQL will provide a result set if the query worked or feedback notifying you that there is a problem with the syntax of your query.  The context of the assignment is for you to write in a text editor what you think the correct syntax is for SELECT queries to perform the specified information request.  To assist you in writing the queries, I have provided two supplement documents. One of the documents is named “Using Database Management Systems”.  It is a PDF file located in the Database Module in Canvas. In provides an overview of database management systems. The second document is a PowerPoint presentation that specifically focuses on writing single table queries.  Additionally, I will review this material in class. The combination of these two documents should provide enough information on writing single table queries.  I am also providing real time relational databases and tables with data to run and test your queries.   Finally, I added links to a Website that provides an excellent tutorial on writing single table queries. The Website is named W3School.The Website also has interactive practice for you to actually write queries in a simulated database environment.    

Database Assignment House Table.docx Download Database Assignment House Table.docx

Database Assignment House Table.pdf Download Database Assignment House Table.pdf

 HouseTable.txt Download HouseTable.txt