Database Systems Principles
CSE132A Winter 2018
This is an individual assignment. The usual criteria of academic integrity apply (see course policies).
If in doubt, please check with the instructor or TA. Please be advised that assignments will be compared
using plagiarism detecting software.
This SQLite script sets up the schema for the database (together with the additional relation weekday),
and this script constructs the example database shown
in the assignment.
To set up the schema, follow the instructions in the comment at the top of the script.
You can create the example database shown in the assignment
by downloading example.txt as example.sql and running it.
You are now ready to try out your own queries on the example database.
Answers on example database
Note: Assignments will be turned in on ieng6 using the turnin program.
Before running turnin you need to run the command "prep cs132a" on your ieng6 account.
You should already have an ACMS account set up on ieng6.
You can look up account information
at http://acms.ucsd.edu (click on the details button).
If you cannot find your account, or run into any other problem on ieng6, please contact ACMS.
Please make sure well ahead of time that you can login to your ieng6 account, using your UCSD credentials!
Solutions to the SQL assignment
JDBC assignment, due Monday, Mar. 5, 11:59pm using the turnin program
(the command turnin -c cs132a PA2.java)
Please include your name and ID in the comment section at the beginning of the file
This is an individual assignment. The usual criteria of academic integrity apply.
Please ask the instructor or the TA if you have any doubts about what is allowed.
We have put together a set of FAQs you might find useful. Please look at this first if you have a question.
Sample input and output data:
For each of the above inputs, the result is provided in a relation called "solution".
To check your answer against the test data, run your program on the input and compare your answer to the result
provided in the corresponding solution table.
You can do this manually or by running an SQL command finding the difference between your answer and the solution.