CS348: Information Systems

Home | Syllabus | Schedule & Lecture Slides | Homework, Projects, & Handouts | Announcements

Homework, Projects & Handouts

Homework

•  Homework 1 due Sep 8, 2015 @ class time
•  Homework 2 due Sep 24, 2015 @ class time
•  Homework 3 due Oct 27, 2015 @ class time
•  Homework 4 due Nov 24, 2015 @ class time   

***Handwritten assignments will be accepted too, but please write legibly!

***If you cannot make it to class, please leave your assignment in the TA's mailbox before the deadline.

 

Projects

•  Project 1 due Sep 15, 2015 @ 11:59 pm Project description/Code template
  You can test the correctness of your application using the sample test. Note that the expected output column of this file does not exactly match the format of the project specification, but your program should.
•  Project 2 due Oct 29, 2015 @ 11:59 pm Project description/data.sql/query results on sample data/ views on sample data / SQL tutorial
•  Project 3 due Nov 17, 2015 @ 11:59 pm Project description/data.sql/procedure results on sample data
•  Project 3 (Extended Version) Project description/procedure results on sample data/data.sql
•  Project 4 due Dec 1, 2015 @ 11:59 pm Project description/Code template/AppEngine Installation Guide / AppEngine Eclipse Tutorial  
•  Project 4 (Extended Version), Project description  

 

 

Other Handouts

• Slides that are covered in CS348 Final Exam, Fall 2015.
• Big data Lab. Introduction of tools from the Apache Hadoop ecosystem: HDFS and MapReduce.
  Hadoop Introduction (slides) ; SQL via MapReduce project description (pdf)
• Handout on serializability (from Jeff Ullman's book)
• Handout on crash recovery (from Jeff Ullman's book)
• Data Science and Prediction
• Example of proving loss less join
• Oracle certification exam (sample questions)
• Big Data (Michael Stonebraker) (slides)
• Above the Clouds: A Berkeley View of Cloud Computing
• Secure Data Warehouse (slides)
• Private and Trusted Interactions (slides)
• PL/SQL Tutorial code
• JDBC Tutorial code
• Handout on SAP Software /SAP online training
• SQL Tutorial Questions
• SQL Tutorial Answers
• Handout on Natural and Outer Joins & Relational Calculus
• Engineering the Object-Relation Database Model in O-Raid
• Normalization and lossless joins and FD preservations
• The design and implementation of INGRES by Stonebraker
• RAID distributed database system
• Project Recommendations, general information/recommendations about development; not required reading
• UNIX PATH Tutorial, the mysterious PATH variable...
• Normalization, explains why normalization is required using examples.
• Hierarchical model, explains the characteristics using examples.
• Network model, explains the characteristics using examples.
• Engineering the Object-Relation Database Model in O-Raid
• Oracle PL/SQL Tutorial