Home
Syllabus
Schedule
Homework/Projects
Lecture Notes
Resources

Resources

Exam reviews

Textbook Website

http://www-db.stanford.edu/~ullman/fcdb.html

Data sets

Using jupyter

jupter-instructions.txt

Using sqlite

sqlite3_basics.txt

StackOverflow post on how to implement table inheritance. In this example, the policy_id is a primary key for the policies table and a foreign key for each of the policy_motor and policy_property tables.

SQLite introduction on foreign keys and how to design, implement, and use constraints.

Using git

We will use git to store and submit class work. Please make sure you create a git repo using the project name csci305 and share the repo with the instructor so the instructor can send feedback to your repo.

If you don't remember how to set up git repo, please go back to your previous course exercises in CSCI 205, 206, or 315 and look for references there. Talk to your instructor if you have any questions.

Here is a direct link to the gitlab exercise in this semester's CSCI 206. Follow the link and set up your CSCI 305 git repo.


Last modified: Tue Jan 09 09:20:55 EST 2018