CS 338: Computer Applications in Business: Databases
Note that the assignments are not going to be marked. We will
provide the solutions and you are
encouraged to do them since they will help you check your
understanding of the material, practice with the ideas, and prepare
for the exams.
Assignment 1
Assignment 2
- Download assignment
- to test your solutions you can use one of the following ways:
- a stand-alone SQLLite-based engine
(download an appropriate binary here) that you
install on your computer and use with the following database.
The advantage of doing this (beyond having a cool interface) is that you can add to/delete/modify the instance to test your solutions more thoroughly.
- an on-line webbased interface (allows querying only)
here (helpful additional commands:
show tables and describe tablename)
- Download *CORRECTED* example solutions
Assignment 3
Assignment 4