Blog

STOP!!! Please remain on this page. Do not proceed until t…

STOP!!! Please remain on this page. Do not proceed until the teaching team instructs everyone to continue. [1] Some useful resources: SQL Basics Chapter 6 – Basic SQL Instructions for 2-File Autograder.pdf Stored Procedures + Functions Handout [2] All of the queries are based on the following “global company” scenario: Global Company Database Handout Global Company Database EERD Global Company Database Relational Schema [3] In this autograder format, you will need to download two files: sp26_exam3_da_init.sql and sp26_exam3_da_student.sql. Once you have downloaded the files, run sp26_exam3_da_init.sql once. Now, you can start writing your solutions in sp26_exam3_da_student.sql and run this file only when you hope to see your grade. You do not need to run the database initialization file again.   [4] Submit your answers using this format (one of these per question): create or replace view practiceQuery as ; This is the same format that you’ve used when practicing with the company autograder in class. [5] Also, please be sure to use the “as” operator to rename any duplicate columns in the select clauses of your queries.  All column names must be unique for our evaluation system.  Leaving duplicate column names in your query definitions can cause the evaluation and testing of your submission to fail.  Also, your column names do NOT have to match the expected output. [6] Finally, all of the queries involve the select command.  Do not submit any other queries or transactions involving these commands or their variants: insert, update, delete, create (other than creating views), alter, drop.   [7] Make sure your queries work using the Autograding System and the Magic Tables as we have been doing in class.  [8] Upload only the  sp26_exam3_da_student.sql file to the Daily Activity 23.1 Gradescope assignment. Only the code uploaded to Gradescope will be graded, so make sure you really saved your latest version!! There are 40 points in total. Both the local autograder and Gradescope show your final score.    STOP!!! Please remain on this page. Do not proceed until the teaching team instructs everyone to continue.