Fluent Essays

Please take the time to read the attached 'Clarification' document which explains the difference between Weeks 1-3 SQL Check Assignments (grading and feedback) vs Week 4-6 SQL assignments.  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.    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 upon 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. CREATE TABLE IF NOT EXISTS LitCharacters ( idLitCharacters INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT Name TEXT Realm TEXT CreatureType TEXT CreatureSubType TEXT Gender TEXT Height INTEGER Weight INTEGER Appearances INTEGER); INSERT INTO LitCharacters (Name Realm CreatureType CreatureSubType Gender Height Weight Appearances) VALUES ('Kaerio' 'Magical' 'Human' 'Merman' 'Male' '67' '194' '10') ('Lituck' 'Magical' 'Other' 'Gargoyle' 'Male' '42' '258' '9') ('Hissing Hornet' 'Real' 'Human' 'Supervillain' 'Male' '61' '205' '5') ('Rugby Defiant Eldon' 'Real' 'Human' 'Pirate' 'Male' '67' '168' '0') ('Belet the Hero' 'Real' 'Human' 'Knight' 'Female' '70' '270' '4') ('Mistress Shaggy Wraith' 'Real' 'Human' 'Supervillain' 'Female' '66' '175' '0') ('Swift Shadow' 'Real' 'Human' 'Supervillain' 'Female' '83' '179' '1') ('Doctor Heavenly Daggers' 'Real' 'Human' 'Superhero' 'Female' '89' '183' '0') ('Carpus Jesterrose' 'Magical' 'Human' 'Fairy' 'Male' '11' '5' '7') ('Wilhelmine Slayer England' 'Real' 'Human' 'Pirate' 'Female' '70' '136' '0') ('Saffron Copperspeck' 'Magical' 'Human' 'Fairy' 'Female' '12' '6' '0') ('Leonore The Wall Clive' 'Real' 'Human' 'Pirate' 'Female' '66' '133' '9') ('Oceane' 'Magical' 'Human' 'Mermaid' 'Female' '60' '112' '0') ('Scarlet Almonddove' 'Magical' 'Human' 'Fairy' 'Female' '14' '5' '5') ('Courage' 'Magical' 'Animal' 'Wolpertinger' 'Male' '11' '8' '0') ('Doria' 'Magical' 'Human' 'Mermaid' 'Female' '67' '124' '5') ('Delmara' 'Magical' 'Human' 'Mermaid' 'Female' '60' '126' '0') ('Cosmos' 'Magical' 'Animal' 'Jackalope' 'Female' '10' '9' '2') ('Dr. Deficit' 'Real' 'Human' 'Mad Scientist' 'Female' '72' '139' '0') ('Truffle' 'Magical' 'Animal' 'Jackalope' 'Male' '13' '8' '0') ('Lula Stormrider Williams' 'Real' 'Human' 'Cowgirl' 'Female' '64' '126' '0') ('Superchelosaurus (Super Claw Lizard)' 'Real' 'Animal' 'Dinosaur' 'Female' '202' '26974' '0') ('Prof. Queasy' 'Real' 'Human' 'Mad Scientist' 'Male' '72' '142' '0') ('The Voiceless Arsonist' 'Real' 'Human' 'Supervillain' 'Female' '58' '184' '9') ('Moonbean Mistyweather' 'Magical' 'Human' 'Fairy' 'Male' '11' '4' '0') ('Solstice' 'Magical' 'Animal' 'Wolpertinger' 'Female' '11' '7' '0') ('Cool Mongoose' 'Real' 'Human' 'Superhero' 'Female' '81' '148' '3') ('Water Raven' 'Real' 'Human' 'Superhero' 'Male' '83' '140' '4') ('James the Friendly Brooks' 'Real' 'Human' 'Cowboy' 'Male' '69' '133' '4') ('Alectrochelodraco (Eagle Claw Dragon)' 'Real' 'Animal' 'Dinosaur' 'Male' '207' '7409' '9') ('Sechec' 'Magical' 'Animal' 'Basilisk' 'Male' '419' '283' '0') ('Pelorospondylus (Monstrous Vertebrae)' 'Real' 'Animal' 'Dinosaur' 'Female' '228' '17477' '0') ('Fern Auger Flowers' 'Real' 'Human' 'Cowgirl' 'Female' '64' '130' '5') ('Lord Eager Shield' 'Real' 'Human' 'Superhero' 'Male' '71' '187' '0') ('Sojisnux' 'Magical' 'Other' 'Gargoyle' 'Female' '39' '103' '0') ('Nugget' 'Magical' 'Animal' 'Jackalope' 'Female' '12' '9' '0') ('Dr. Thunder' 'Real' 'Human' 'Mad Scientist' 'Female' '71' '138' '5') ('Prof. Stitch' 'Real' 'Human' 'Mad Scientist' 'Male' '69' '146' '9') ('Lela Dynamite Lowery' 'Real' 'Human' 'Cowgirl' 'Female' '62' '131' '2') ('Vanessa Birdfog' 'Magical' 'Human' 'Fairy' 'Female' '11' '6' '0') ('Barbara Foxpool' 'Magical' 'Human' 'Fairy' 'Female' '12' '6' '0') ('Prof. Outcome' 'Real' 'Human' 'Mad Scientist' 'Female' '68' '157' '0') ('Eldoris' 'Magical' 'Human' 'Mermaid' 'Female' '64' '124' '0') ('Uzconom' 'Magical' 'Other' 'Gargoyle' 'Male' '31' '249' '9') ('Kawai' 'Magical' 'Human' 'Merman' 'Male' '72' '206' '0') ('Gnevumo' 'Magical' 'Other' 'Gargoyle' 'Female' '38' '164' '0') ('Doctor Spectacular Whiz' 'Real' 'Human' 'Supervillain' 'Male' '65' '164' '1') ('Jade' 'Magical' 'Animal' 'Jackalope' 'Male' '12' '5' '0') ('Vuejezli' 'Magical' 'Other' 'Gargoyle' 'Female' '32' '185' '0') ('Osharus' 'Magical' 'Human' 'Merman' 'Male' '65' '206' '5') ('Amara' 'Magical' 'Human' 'Mermaid' 'Female' '61' '135' '10') ('Prof. Fluke' 'Real' 'Human' 'Mad Scientist' 'Male' '70' '145' '5') ('Bionic First Aid Prototype' 'Real' 'Other' 'Robot' 'Unknown' '48' '139' '0') ('Lethal Lynx' 'Real' 'Human' 'Supervillain' 'Female' '68' '190' '0') ('Manuela No-Tongue Layre' 'Real' 'Human' 'Pirate' 'Female' '69' '146' '3') ('Magnum' 'Magical' 'Animal' 'Wolpertinger' 'Female' '13' '9' '4') ('Odolina the Bold' 'Real' 'Human' 'Knight' 'Female' '75' '265' '0') ('Rational Space Navigation Machine' 'Real' 'Other' 'Robot' 'Unknown' '54' '112' '0') ('Dr. Pungent' 'Real' 'Human' 'Mad Scientist' 'Female' '69' '160' '0') ('Cloud Limelily' 'Magical' 'Human' 'Fairy' 'Female' '10' '6' '0') ('Aldis' 'Magical' 'Human' 'Dryad' 'Female' '64' '119' '0') ('Violent Spider' 'Real' 'Human' 'Supervillain' 'Female' '80' '203' '0') ('Forbes Reaper Spaulding' 'Real' 'Human' 'Pirate' 'Male' '67' '156' '0') ('Arnold Smokes Stevenson' 'Real' 'Human' 'Cowboy' 'Male' '68' '151' '6') ('Richemanus the Shepherd' 'Real' 'Human' 'Knight' 'Male' '62' '310' '0') ('Dr. Boulder' 'Real' 'Human' 'Mad Scientist' 'Female' '71' '155' '6') ('Serissa' 'Magical' 'Human' 'Dryad' 'Female' '62' '123' '0') ('Zaatruarad' 'Magical' 'Other' 'Gargoyle' 'Male' '38' '217' '0') ('Jarrett Reaper Clayden' 'Real' 'Human' 'Pirate' 'Male' '71' '150' '9') ('The Bronze Swan' 'Real' 'Human' 'Superhero' 'Male' '73' '230' '0') ('Strategic Human Protection Golem' 'Real' 'Other' 'Robot' 'Unknown' '33' '156' '0') ('Solace' 'Magical' 'Animal' 'Wolpertinger' 'Male' '12' '5' '0') ('Nireta' 'Magical' 'Human' 'Mermaid' 'Female' '66' '111' '4') ('Wallace the Blind Rich' 'Real' 'Human' 'Cowboy' 'Male' '71' '138' '0') ('Tangy Tigermist' 'Magical' 'Human' 'Fairy' 'Male' '13' '5' '0') ('Shothi' 'Magical' 'Other' 'Gargoyle' 'Female' '36' '252' '10') ('White Oxman' 'Real' 'Human' 'Superhero' 'Male' '61' '173' '0') ('Violet Bear' 'Real' 'Human' 'Supervillain' 'Female' '59' '236' '2') ('The Copper Amazon' 'Real' 'Human' 'Superhero' 'Female' '83' '182' '0') ('Jone the Bane' 'Real' 'Human' 'Knight' 'Female' '71' '207' '0') ('Dr. Goose' 'Real' 'Human' 'Mad Scientist' 'Male' '67' '134' '0') ('The Wacky Wraith' 'Real' 'Human' 'Supervillain' 'Female' '57' '202' '0') ('Raamar' 'Magical' 'Other' 'Gargoyle' 'Male' '33' '286' '0') ('The Fantastic Phoenix' 'Real' 'Human' 'Superhero' 'Female' '70' '174' '3') ('Mister White Sage' 'Real' 'Human' 'Superhero' 'Male' '78' '200' '0') ('Self-Reliant Sabotage Entity' 'Real' 'Other' 'Robot' 'Unknown' '61' '122' '0') ('Cari' 'Magical' 'Human' 'Merman' 'Male' '61' '182' '0') ('Willoa' 'Magical' 'Human' 'Dryad' 'Female' '62' '129' '0') ('Alma Big Bazoo Pierce' 'Real' 'Human' 'Cowgirl' 'Female' '66' '117' '0') ('Myrtle Jeopardy Sherman' 'Real' 'Human' 'Cowgirl' 'Female' '62' '149' '0') ('Kendall' 'Magical' 'Human' 'Merman' 'Male' '67' '117' '0') ('Winifred the Silence' 'Real' 'Human' 'Knight' 'Female' '68' '292' '4') ('Yinzu' 'Magical' 'Animal' 'Basilisk' 'Male' '519' '685' '10') ('The Gray Gorilla' 'Real' 'Human' 'Supervillain' 'Male' '81' '220' '0') ('Deinocephaloceratops (Terrible Horned Face)' 'Real' 'Animal' 'Dinosaur' 'Male' '210' '23760' '9') ('Prof. Maniac' 'Real' 'Human' 'Mad Scientist' 'Male' '68' '149' '4') ('Sobejul' 'Magical' 'Other' 'Gargoyle' 'Female' '44' '229' '4') ('Ollie Friendly Face Jenkins' 'Real' 'Human' 'Cowgirl' 'Female' '63' '115' '1') ('Newt Redfur' 'Magical' 'Human' 'Fairy' 'Male' '14' '6' '0') ('Homochelobator (Same Claw Hero)' 'Real' 'Animal' 'Dinosaur' 'Male' '203' '23456' '0') ('Faramond the Eager' 'Real' 'Human' 'Knight' 'Male' '68' '165' '0') ('Mistress Frozen Cheat' 'Real' 'Human' 'Supervillain' 'Female' '86' '145' '0') ('Rational Life Simulation Device' 'Real' 'Other' 'Robot' 'Unknown' '47' '100' '0') ('Brutus' 'Magical' 'Animal' 'Wolpertinger' 'Male' '12' '11' '0') ('Stareye' 'Real' 'Human' 'Superhero' 'Female' '70' '147' '8') ('Dr. Whistle' 'Real' 'Human' 'Mad Scientist' 'Female' '67' '142' '9') ('Agent Bronze Starling' 'Real' 'Human' 'Superhero' 'Female' '61' '257' '0') ('Barbarea' 'Magical' 'Human' 'Dryad' 'Female' '63' '102' '0') ('Elizabeth Jeopardy Ortiz' 'Real' 'Human' 'Cowgirl' 'Female' '66' '125' '0') ('Hugyica' 'Magical' 'Animal' 'Basilisk' 'Female' '487' '616' '2') ('Doctor Broken Sentinel' 'Real' 'Human' 'Superhero' 'Female' '71' '134' '0') ('Silvivenator (Forest Hunter)' 'Real' 'Animal' 'Dinosaur' 'Male' '215' '17692' '10') ('Sabadvux' 'Magical' 'Other' 'Gargoyle' 'Male' '40' '245' '0') ('The Crimson General' 'Real' 'Human' 'Superhero' 'Female' '55' '137' '5') ('Sensory Recording Technology' 'Real' 'Other' 'Robot' 'Unknown' '55' '167' '0') ('Gaura' 'Magical' 'Human' 'Dryad' 'Female' '68' '137' '5') ('Dr. Misery' 'Real' 'Human' 'Mad Scientist' 'Male' '69' '146' '7') ('Callan' 'Magical' 'Human' 'Mermaid' 'Female' '63' '115' '3') ('Torvorhynchomimus (Savage Beak Mimic)' 'Real' 'Animal' 'Dinosaur' 'Male' '209' '18827' '0') ('Shegeinzu' 'Magical' 'Animal' 'Basilisk' 'Female' '399' '579' '2') ('Alien Banshee' 'Real' 'Human' 'Supervillain' 'Male' '67' '145' '10') ('Universal Base Protection Android' 'Real' 'Other' 'Robot' 'Unknown' '48' '152' '9') ('The Broken Sage' 'Real' 'Human' 'Superhero' 'Male' '83' '157' '10') ('Magna Citrusstream' 'Magical' 'Human' 'Fairy' 'Female' '11' '5' '3') ('Prof. Bottom' 'Real' 'Human' 'Mad Scientist' 'Female' '68' '153' '0') ('Barracudon' 'Magical' 'Human' 'Merman' 'Male' '72' '141' '5') ('Winston One Eye Tack' 'Real' 'Human' 'Pirate' 'Male' '71' '163' '0') ('Rosia Golden-Eye Rave' 'Real' 'Human' 'Pirate' 'Female' '72' '154' '3') ('The Outrageous General' 'Real' 'Human' 'Superhero' 'Male' '82' '168' '4') ('Massodonceratops (Massive Tooth Horned Face)' 'Real' 'Animal' 'Dinosaur' 'Female' '233' '22647' '0') ('Prof. Fingers' 'Real' 'Human' 'Mad Scientist' 'Male' '73' '157' '0') ('Golden Bird Eye Carlton' 'Real' 'Human' 'Pirate' 'Female' '72' '133' '9') ('Monroe' 'Magical' 'Human' 'Merman' 'Male' '68' '197' '4') ('Doran of the Light' 'Real' 'Human' 'Knight' 'Male' '65' '227' '0') ('Yejazeq' 'Magical' 'Animal' 'Basilisk' 'Female' '537' '498' '4') ('Widget' 'Magical' 'Animal' 'Wolpertinger' 'Female' '12' '10' '8') ('Soleil Mistyspice' 'Magical' 'Human' 'Fairy' 'Female' '11' '4' '8') ('The Old Horror' 'Real' 'Human' 'Supervillain' 'Female' '75' '196' '0') ('Ukrih' 'Magical' 'Other' 'Gargoyle' 'Female' '35' '177' '7') ('Ed Phantom ONeill' 'Real' 'Human' 'Cowboy' 'Male' '70' '127' '3') ('Eluned the Grand' 'Real' 'Human' 'Knight' 'Female' '70' '297' '0') ('Quavolqaz' 'Magical' 'Other' 'Gargoyle' 'Male' '37' '218' '8') ('Self-Aware Algorithm Device' 'Real' 'Other' 'Robot' 'Unknown' '47' '152' '5') ('Milet the Illuminator' 'Real' 'Human' 'Knight' 'Male' '73' '281' '0') ('The Filthy Smasher' 'Real' 'Human' 'Supervillain' 'Female' '61' '157' '0') ('Prof. Craven' 'Real' 'Human' 'Mad Scientist' 'Female' '69' '138' '5') ('Leomaris' 'Magical' 'Human' 'Merman' 'Male' '68' '177' '0') ('Jubal' 'Magical' 'Human' 'Merman' 'Male' '72' '184' '0') ('Arvilla Mumbling Heinrik' 'Real' 'Human' 'Pirate' 'Female' '67' '144' '0') ('Pandora Cloudsplash' 'Magical' 'Human' 'Fairy' 'Male' '12' '4' '0') ('Dicraeotholus (Forked Dome)' 'Real' 'Animal' 'Dinosaur' 'Female' '173' '20907' '0') ('Julianne Giggleclove' 'Magical' 'Human' 'Fairy' 'Female' '14' '4' '0') ('Tammie the Romantic' 'Real' 'Human' 'Knight' 'Male' '67' '227' '0') ('Elva Butcher Barrie' 'Real' 'Human' 'Pirate' 'Female' '65' '148' '0') ('Selene Cottonbottom' 'Magical' 'Human' 'Fairy' 'Female' '13' '5' '1') ('Harbor Frozenshadow' 'Magical' 'Human' 'Fairy' 'Male' '11' '2' '1') ('Timber' 'Magical' 'Animal' 'Jackalope' 'Male' '11' '10' '3') ('Nero' 'Magical' 'Animal' 'Jackalope' 'Male' '11' '7' '0') ('Dr. Moon' 'Real' 'Human' 'Mad Scientist' 'Female' '67' '153' '0') ('Munchkin' 'Magical' 'Animal' 'Wolpertinger' 'Female' '12' '6' '6') ('Shaden' 'Real' 'Human' 'Superhero' 'Male' '77' '176' '0') ('Reef Jumpyjewel' 'Magical' 'Human' 'Fairy' 'Male' '10' '3' '0') ('The Fire Brute' 'Real' 'Human' 'Supervillain' 'Male' '56' '190' '4') ('Hadrodraco (Big Dragon)' 'Real' 'Animal' 'Dinosaur' 'Male' '229' '21459' '3') ('Sybbyl the Keen' 'Real' 'Human' 'Knight' 'Female' '69' '188' '10') ('Panochelogryphus (Fully Claw Griffin)' 'Real' 'Animal' 'Dinosaur' 'Female' '197' '15445' '10') ('The Wanderer' 'Real' 'Human' 'Supervillain' 'Male' '57' '235' '0') ('Vivien' 'Magical' 'Human' 'Mermaid' 'Female' '62' '117' '1') ('Laraine' 'Magical' 'Human' 'Mermaid' 'Female' '65' '120' '0') ('Suffield Deranged Hackney' 'Real' 'Human' 'Pirate' 'Male' '67' '160' '0') ('Dr. Effort' 'Real' 'Human' 'Mad Scientist' 'Male' '68' '137' '1') ('Intelligent Bodyguard Technician' 'Real' 'Other' 'Robot' 'Unknown' '45' '144' '0') ('Griritt' 'Magical' 'Other' 'Gargoyle' 'Male' '37' '244' '9') ('Carl Killer McPherson' 'Real' 'Human' 'Cowboy' 'Male' '69' '134' '3') ('Wallflower Whitewhirl' 'Magical' 'Human' 'Fairy' 'Female' '10' '4' '0') ('Zaqac' 'Magical' 'Animal' 'Basilisk' 'Male' '408' '428' '8') ('Jericho' 'Magical' 'Animal' 'Jackalope' 'Male' '11' '7' '0') ('Asbam' 'Magical' 'Other' 'Gargoyle' 'Male' '41' '148' '0') ('Guiscard the Gentle' 'Real' 'Human' 'Knight' 'Male' '66' '207' '7') ('Pelorotrachelotitan (Monstrous Necked Giant)' 'Real' 'Animal' 'Dinosaur' 'Female' '131' '16885' '1') ('Carrie the Mortal Sherman' 'Real' 'Human' 'Cowgirl' 'Female' '61' '119' '2') ('The Ice Doctor' 'Real' 'Human' 'Superhero' 'Female' '75' '178' '0') ('Grumpy Savage' 'Real' 'Human' 'Supervillain' 'Male' '72' '182' '3') ('Juggernaut' 'Magical' 'Animal' 'Wolpertinger' 'Male' '11' '7' '2') ('Dan Have Mercy Knowles' 'Real' 'Human' 'Cowboy' 'Male' '66' Clarification: SQL Check Assignments, Weeks 1-3, Grades and Feedback vs later SQL assignments Your grades for the following SQL assignments from Weeks 1-3 are determined by your highest score of TWO attempts on the SQL Check quiz.  · Week 1 Mythical Creatures I · Week 2 Mythical Creatures II · Week 3 Help Desk You were asked to also submit your work from these assignments so they would serve as a backup.  Submitted assignments (the uploaded Word document) may be 'spot checked' for completeness, but you will not receive a separate grade for these submissions.  This approach to grading allows us to offer additional SQL practice for students in early weeks, when other assignments still need to be manually graded by the instructor (Week 1 Database Guided Study and Week 2 Database Development).  The SQL Checks also allow you the chance to take the quiz once, rework your SQL as needed, and then retake the quiz; your highest grade of the two attempts is posted to the Grades area. The reason you are given two tries at the quiz is so you can review your SQL code for certain questions and see where you might have made a mistake. Thus, you should not take the 2nd attempt five minutes after the first. Note, for example, that in the Week 2 SQL Check, it is highly likely that the second attempt at the quiz will NOT have the same questions as the first attempt. Later SQL assignments that you submit ONLY to the Assignments Folder (uploaded Word file only, no SQL Check quiz) will be manually graded by the instructor and you will receive specific feedback on the SQL code.  You can only submit these SQL assignments ONCE. · Week 4 BI SQL Assignment · Week 5 SQL University · Week 6 ETL Candy If any of the above is unclear, let your instructor know.  If you have specific questions on ANY SQL assignment, from ANY week, do not hesitate to contact your instructor. UMGC IFSM 330 Setting up SQLiteonline.com In this class, we’ll be using SQLiteonline.com to install databases, run scripts and view output. SQLiteonline runs from a browser; there is no software to install. Now, we are going to fire up SQLiteonline.com, run a script to install a database with a single table, and run some queries on this database. Part 1 – Prepare the database and query environment, Open a browser and go to www.sqliteonline.com 1. When you first access SQLiteonline.com, you should see something like the following screenshot: A: Shows we’re using the SQLite database and there is a database preloaded called ‘demo’. B: Is the area where we will enter our SQL install commands and SQL database queries C: Shows output of queries. D: Is the ‘Run’ button. We click there to run a command or query. 2. We’re going to start by deleting (dropping) the ‘demo’ database. Right click next to demo and choose drop. Then click OK to confirm. Now we have an empty database. Click in the Query Area, and select/highlight the query SELECT * FROM demo; (use your mouse or CTRL-A on the keyboard) and DELETE that query (DELETE KEY or BACKSPACE). We now have an empty data base and a blank query environment where we can begin work. 3. NOTE: SQLiteonline.com saves NOTHING for you. You will need to keep a copy of your queries and screenshots of output in Word (Part 4 of this document). Furthermore, It’s always smart to back your work up, so make a note to periodically save a copy somewhere else (i.e. email yourself a copy, or save it to your Google Drive as well.) Backing up only takes a minute and can save hours of rework. 4. The process that we just completed in SQLiteonline.com, removing/dropping the demo database and clearing the SQL Query area is a process you will do EVERY TIME you begin work again in SQLiteonline.com. Part 2, beginning on the next page, describes how to run an SQL INSTALL script to install a database in SQLiteonline.com. This is also a process that you will do EVERY TIME you begin work in SQLiteonline.com. Part 2 – Download the Script and get your MythicalCreatures Set Up The names in Mythical Creatures table are thanks to our friends at https://www.fantasynamegenerators.com/. Got a dragon and don’t know what to name it? They will have fantastic suggestions. 1. Please download the MythicalCreatures.sql file from the Assignments Folder in LEO (the same folder you downloaded these instructions from) and save the file to your hard drive. 2. If you double click the file it should open automatically in NotePad (Windows) or a text editor on a Mac. As we did before, with your cursor/mouse in Notepad, select the entire sql text (CTRL-A) and copy (CTRL-C) and paste (CTRL-V) the text into the Query area of SQLiteonline.com. Text is selected: SQLiteonline.com, after pasting (CTRL-V) the text into the SQL Query area. Note the DB (database) is still empty. Click Run to Run/Execute the Database install. After Run, we now have the database LitCharacters showing at the left. Be careful not to click Run Twice, otherwise you will have all of the data—twice. Click the ARROW to the right of LitCharacters, to show the Column Headings: Note our install command is still in the SQL query area. We should remove that text, so we can run other queries from a blank screen. The database stays at the left, unless we actually DELETE/DROP the database (as we did before). Within the SQL query area, click CTRL-A to select the text and DELETE or BACKSPACE on the keyboard to delete the query. Part 3 – Verify your MythicalCreatures Database 1. You are a literary agent working for Super Random House, Inc. Your publishing company maintains a database of characters which have appeared or may appear in the future in its novels. The novels run the gamut from fiction to nonfiction, biography to fantasy, and of course there must always be a basilisk or a robot available. Super Random House pseudo-randomly selects characters and assigns them to an author when it commissions a book. For example, it could select one pirate, one knight, and one supervillain, and commission an author to write a short story using those characters. Super Random House keeps track of previous uses of its characters to avoid over- or under-use of any specific one. 2. Your database has one table in it, and the table is called ‘litcharacters.’ 3. Here’s a sample of the first few rows of a litcharacters table. Note your first few rows may or may not contain the exact same information, but they should be of the same general idea. The data fields are: a. idLitCharacters – a unique identifier (the primary key, if you’ve heard of those) b. Name – a text field with the name of the character c. Realm – a text field telling us what realm the character belongs to d. CreatureType – designates creature as Human, Animal, or a few additional types e. CreatureSubType – gives more specifics about the exact sort of creature f. Gender - gender g. Height – height in inches h. Weight – weight in pounds i. For example, in the table below, our first literary character is a male Merman (human on top, fish tail on the bottom) named Kaerio, clearly a magical character, but with a human type, and he is 65 inches tall and weighs 181 pounds. j. Rounding out the scales is entry number 8, our Super Claw Lizard, at over 26,000 pounds. idLitCharacters Name Realm CreatureType CreatureSubType Gender Height Weight 1 Kaerio Magical Human Merman Male 65 181 2 Hissing Hornet Real Human Supervillain Male 61 205 3 Rugby Defiant Eldon Real Human Pirate Male 67 168 4 Belet the Hero Real Human Knight Female 70 270 5 Mistress Shaggy Wraith Real Human Supervillain Female 66 175 6 Swift Shadow Real Human Supervillain Female 83 179 7 Doctor Heavenly Daggers Real Human Superhero Female 89 183 8 Superchelosaurus (Super Claw Lizard) Real Animal Dinosaur Female 202 26974 9 The Voiceless Arsonist Real Human Supervillain Female 58 184 10 Alectrochelodraco (Eagle Claw Dragon) Real Animal Dinosaur Male 207 7409 k. Let’s verify your MythicalCreatures database is working correctly. 4. Run the following query to list all the data in the table LitCharacters. A screenshot of the first few rows is below. Forgot how to run a query? Do this: a. Make sure your SQLiteonline.com SQL query area is empty. We want to work from a ‘blank slate’. b. Type the SQL into the SQL Query area (so you literally type SELECT * from LitCharacters;) c. Leave your cursor blinking away after the semicolon d. Mouse up to the RUN button and press it to execute the code SELECT * FROM LitCharacters; 2. Remove/DELETE your SELECT * FROM LitCharacters; SQL query and from a blank SQL query area, run the following query and verify that you have 250 records in the table: SELECT count(*) FROM LitCharacters; Part 4.1: Using Snipping Tool (Windows) or the Screenshot App (Mac) to Capture Output All of the screenshots/images in these instructions were captured and copied and pasted into Word using the Snipping Tool in Windows. Note you should typically NOT take a picture of the entire screen, but select the pertinent output that you want to capture. If the output in submitted screenshots is too small to easily read or if the submitted screenshots do not show enough of the output, the assignment will be returned for resubmission. Instructions for using the Snipping Tool can be found here: https://support.microsoft.com/en-us/windows/use-snipping-tool-to-capture-screenshots-00246869-1843-655f-f220-97299b865f6b If you have Windows 10, you may receive a message that the Snipping Tool is being replaced by a new App called ‘Snip & Sketch’. Snip & Sketch instructions can be found here: https://support.microsoft.com/en-us/windows/how-to-take-and-annotate-screenshots-on-windows-10-ca08e124-cc30-2579-3e55-6db63e36fbb9 The Snipping Tool equivalent in Mac is the Screenshot App. Instructions for using the Screenshot App can be found here: https://support.apple.com/en-us/HT201361 Pay particular attention to the second section How to capture a portion of the screen, which will allow you to select specific output to capture. Part 4.2: Using a Browser to Capture Output Most major browsers can also take and save screenshots. Since our output is based within a browser this might be a simple option for some. Firefox: https://support.mozilla.org/en-US/kb/firefox-screenshots Firefox and Microsoft Edge keyboard shortcut for Screenshots: CTRL-Shift-S Chrome: in Chrome-based browsers, look for a small camera icon: Part 4.2: Using Word to type SQL code for SQLiteonline Quotes are often a part of SQL code, but Word creates quotes for written text not programming or SQL code. Quotes in Word can sometimes be curved, sometimes not. But SQLiteonline.com can give errors on “curved/angled” quotes. SQLiteonline prefers "straight up and down" quotes the type that are created by Notepad. However, Notepad within Windows is very basic and not always easy to use. A more advanced, but free, open source alternative to Notepad for MS Windows is Notepad++, available here: https://notepad-plus-plus.org/ Some students seem to use Microsoft Word for SQL code without a problem, others encounter problems and it’s not even clear the quotes are causing the errors. Examples: Arial: “curved/angled” Arial Unicode MS: “curved/angled” Courier New: “curved/angled” Times New Roman: “curved/angled” From notepad: "straight up and down" Setting Up SQLonline.com Page 10