Csc 1302, Honors Principles of Computer Science II (Fall 2016)

Weekly Materials

In Memory Relational Database Project

  1. Week 1 (25 August 2016) DUE: September 4, 2016 - Sunday (handin under 1)
    Initial setup code in Database.java, Relation.java, and Tuple.java
  2. Week 2 (1 September 2016) DUE: September 14, 2016 - Wednesday (handin under 2)
    Database.initializeDatabase(dir)
    Relation.removeDuplicates()
    Tuple.equals()
  3. Week 3 (8 September 2016)
    Week 2 continued
  4. Week 4 (15 September 2016) DUE: September 28, 2016 - Wednesday (handin under 4)
    Tuple.clone()
    Relation.member(Tuple t)
    Relation.union(Relation r2)
    Relation.intersect(Relation r2)
    Relation.minus(Relation r2)
  5. Week 5 (22 September 2016)
    Week 4 continued
  6. Week 6 (29 September 2016) DUE: October 5, 2016 - Wednesday (handin under 6)
    Relation.rename(ArrayList<String> cnames)
    Relation.times(Relation r2)
    Tuple.concatenate(Tuple t2, ArrayList<String> attrs, ArrayList<String> doms)
  7. Week 7 (6 October 2016) DUE: October 12, 2016 - Wednesday (handin under 7)
    Tuple.project(ArrayList<String> cnames)
    Relation.project(ArrayList<String> cnames)
  8. Week 8 (13 October 2016) DUE: October 19, 2016 - Wednesday (handin under 8)
    Tuple.select(String lopType, String lopValue, String comparison, String ropType, String ropValue)
    Relation.select(String lopType, String lopValue, String comparison, String ropType, String ropValue)
  9. Week 9 (20 October 2016) DUE: November 2, 2016 - Wednesday (handin under 9)
    Tuple.join(Tuple t2, ArrayList<String> attr, ArrayList<String> dom)
    Relation.join(Relation r2)
  10. Relational Algebra Queries to test the operators Please submit Query1.java, Query2.java, Query6.java, and final versions of Database.java, Relation.java, and Tuple.java, under assignment "dbengine". DEADLINE: December 8th (Thursday)

Netflix Project

Data Set
Data Set in .zip format
Official Dataset Website

Netflix - Part 1
Netflix - Part 2
Netflix - Part 3
Netflix - Part 4

Submit all Netflix Code under assignment "netflix" by Dec 8 (Thursday)