Blog

Instructions……. Please take the time to read the attached ‘Clarification’ d

Instructions…….

Please take the time to read the attached ‘Clarification’ document which explains the difference between Weeks 1,2,5 SQL Check Assignments (grading and feedback) vs Week 6-8 SQL assignments.

This assignment is composed of two deliverables, a Word document (fill in the attached template) and an SQL Check online quiz to verify your answers. The directions for both deliverables are in the attached document.

  • The first deliverable guides you to produce a Word document with SQL code and screenshots of execution. You will attach that here.
  • The second deliverable, Week 1 SQL Check Mythical Creatures I, is verification of your SQL results using our automatically graded online quiz.
    • You may take the Week 1 SQL Check three times and your highest score will be posted to the Grades area. You are given multiple attempts so you can rework the SQL on the questions you miss. Do NOT attempt the quiz again without spending some time with your SQL queries; this is central to the learning process.

In order to earn full credit, you MUST do them both! Note if the first deliverable, the submitted Word document is incomplete, your posted grade for the Week 1 SQL Check will be modified. You should consider that a complete Word document, with SQL queries and screenshots is 50% of your grade on this assignment.

In this Week 1 assignment, we introduce you to a single-table database. It requires you to

  • download and run an SQL script to set the database up on your work area
  • write and execute several SQL queries to demonstrate mastery

Attached to this assignment is the Word document containing your instructions, plus a script (“MythicalCreatures.sql”) containing instructions your computer will need to create the database so you can do this week’s assignment.

In other tutorials this week, you use the Khan Academy website to work through tutorials, create databases and queries and test code. In this assignment and in other assignments in the course, we’ll be using a different website called SQLiteonline.com.

Instructions for how to access SQLiteonline.com, create a database, run queries and check output of the queries are found in the attached file Setting_Up_SQLiteonline_com.docx. Those instructions will provide information on how to take snippets of your output to cut and paste into Word for submission.

If you have questions, ASK.

MythicalCreatures.sql (19.44 KB)
Setting_Up_SQLiteonline_com_v2.docx (466.81 KB)
Assignment Mythical Creatures I for students.22… (55.63 KB)
Clarification_SQL_checks_Weeks1_2_5_vs_SQL_Week… (14.32 KB)

Related posts:

  1. Research Project Instructions: Sustainable Development: Research Paper: Each student should identify an area overburdened by pollution, applying EPA’s EJScreen: Environmental Justice Screening and Mapping Tool (https://www.epa.gov/ejscreen), which combines environmental and socioeconomic information in the area. Then, she needs to write a paper between six and eight pages (including figures, tables, and references). See the required format below. EJSCREEN is an environmental justice mapping and screening tool that provides EPA with a nationally consistent dataset and approach for combining environmental and demographic i
  2. The Assignment: Choose one historical concept about the Dahomey women warriors addressed in Edna Bay’s “Women in Combat,” a review of Stanley B. Alpern’s text Amazons of Black Sparta: The Women Warriors of Dahomey. Then in a five-page critical analysis – using a Womanist, Afrofuturist framework – that discusse
  3. explain what you see as a key problem or problems with the role of the class action in modern civil litigation. In doing so, make sure you explain how class actions differ from ordinary civil litigation, and create additional challenges.
  4. complete two discussion forums during the course.  Each consists of an initial post of 400-500 words addressing an instructor-provided topic.  The forums also require responses to the posts of at least two classmates. Each response should be 150-300 words.