Resources
Exam reviews
Textbook Website
http://www-db.stanford.edu/~ullman/fcdb.htmlData sets
Using jupyter
Using sqlite
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.