Reference no: EM132305832

Assignment: Database Concepts and Queries

Objectives: • Recognize and use database terminology

• Enter queries to extract/ select data meeting specified criteria.

• Formulate and create queries to fulfill data specifications/requirements.

Requirements: • For this assessment, you will need to use the information and query application in the Competency 6 Tutorial: Data - Databases -Big Data.

• Part I: Database terminology and query execution:

• Create a Word document and include definitions for the following terms: (You can use the tutorial and research on the Internet. You should have 1-2 sentences for each term.)

• DBMS

• SQL

• SQL WHERE clause

• SQL ORDER BY clause

• Relational Database

For queries 2-6 in the tutorial under Structured Query Language, type each of the queries into the textbox provided and hit return. The query will be executed, then take a snapshot of the query results using your favorite snipping tool and paste it into your Word document . Be sure to include the timestamp at the bottom or your document will not be accepted - timestamps will be used to insure the queries were actually submitted.

Part II: Writing SQL Queries

1. In the tutorial under Advanced SQL, you will find 6 queries listed under Required Competency Part II - Advanced SQL. Query 0 is there for demonstration purposes to show you what your results should look like.

2. For queries 1-5, create the SQL query to get the results needed to answer the question and type it into the textbox.

3. In the Word document, paste the SQL query you used, and the answer to the question (as shown for query 0).