IFSM – Explicitpapers

UMGC IFSM 330 Assignment Mythical Creatures I

This assumes you have worked through the SQL commands referenced in the weekly tutorial(s) and you have prepared the SQLiteonline.com environment (see the Setting_Up_SQLiteonline_com.docx for instructions).

Your basic study trajectory here will be:

Work through this document and write SQL to answer all the questions listed below. As part of your SQL, you will capture screenshots and paste them where indicated below.
Refer to this document as you complete the SQL Check online quiz which verifies your assignment.
You can take the quiz twice. Your highest score will post to the Grades area. Note the questions may change from one attempt to the next.
When you have completed the online quiz, submit the Word document.
You must complete the quiz AND submit a complete Word document with SQL queries and screenshots to receive credit for this assignment.
Remember, you can always reach out for help to your instructor if your SQL is not behaving for you.

For reference, the commands we may use in this assignment include:

SQL Select
SQL Select Distinct
SQL Where
SQL And, Or, Not
SQL ORDER BY
SQL INSERT INTO
SQL Null Values (optional)
SQL MIN and MAX
SQL COUNT
SQL LIKE
SQL WILDCARDS
SQL IN
SQL BETWEEN
SQL ALIASES (Column syntax only)

Name: _________________________________

Single Table Queries

This is where you start to turn things in. Make sure to put your name up top.

Construct SQL to answer each of the following questions. For each query, paste your SQL code below, and also paste a screenshot of the first 10 or so rows the query gives you.

Give an answer to the question based only on what you see in your SQLite database. (Do not use Excel or other tools to answer these questions; since we are trying to learn SQLite here, you should do these exercises in SQLite.)

You will eventually submit this document as part of your week’s assignment.

After you have completed your first draft of this document, you will use the SQL Check online quiz to verify your answers. The SQL Check online quiz uses the same numbering system given here, so you can quickly find the question you need.

You are welcome to update your assignment document with results from the SQL Check, and submit the assignment document after you’ve checked your assignment online.

The first question has been done for you as an example. Note the example database may or may not contain the same information as yours.

NOTE: The question numbering below is in sequential order, from smallest to largest, but some numbers are skipped. Be aware of this when you work through the SQL Check online quiz.

[SQL Week 1 Question 100-001] SELECT just the Name and Gender columns from litcharacters. Order ascending by idLitCharacters (you may display the idLitCharacters if you like but it is not required. You need to sort by that field.)

SELECT Name, Gender FROM LitCharacters ORDER BY idLitCharacters;

[SQL Week 1 Question 100-002] List the different creature types are there in the litcharacters database? For example, if you had three humans and one animal, that would be two types – human and animal.