CS186 Projects
  • Overview
  • Assignments
    • Project 0: Setup
      • Getting Started
      • Your Tasks
      • Submitting the Assignment
    • Project 1: SQL
      • Getting Started
      • SQL vs. SQLite
      • Your Tasks
      • Testing
      • Submitting the Assignment
    • Project 2: B+ Trees
      • Getting Started
      • Your Tasks
      • Testing
      • Submitting the Assignment
    • Project 3: Joins and Query Optimization
      • Getting Started
      • Part 0: Skeleton Code
      • Part 1: Join Algorithms
        • Task 1 Debugging
        • Task 2 Common Errors
      • Part 2: Query Optimization
      • Testing
      • Submitting the Assignment
    • Project 4: Concurrency
      • Getting Started
      • Part 0: Skeleton Code
      • Part 1: Queuing
      • Part 2: Multigranularity
      • Testing
      • Submitting the Assignment
    • Project 5: Recovery
      • Getting Started
      • Your Tasks
      • Testing
      • Submitting the Assignment
    • Project 6: NoSQL
      • Getting Started
      • Your Tasks
      • Submitting the Assignment
  • Common
    • Adding a partner on GitHub
    • Development Container Setup
    • Miscellaneous
      • Nested Loop Join Animations
Powered by GitBook
On this page
  1. Assignments
  2. Project 1: SQL

Submitting the Assignment

PreviousTestingNextProject 2: B+ Trees

Last updated 3 months ago

This project is due on Thursday, 2/6/2025 at 11:59PM PST (GMT-8).

Push your changes to your GitHub Classroom private repository and then submit through Gradescope. You may find it helpful to read through the Project 0 submission procedure again . Alternatively you can submit your proj1.sql file directly (make sure it is named proj1.sql or the autograder won't recognize it).

A full list of files that you may modify are as follows:

  • proj1.sql

Grading

  • 75% of your grade will be made up of tests released to you

  • 20% will be determined by hidden tests unreleased tests that we will run on your submission after the deadline

  • 5% will be determined by the correctness of your SQL syntax (see for more information)

  • This project will be worth 5% of your overall grade in the class

here
SQL vs. SQLite