CS348: Information Systems

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

Homework, Projects & Handouts

Homework

•  Homework 1 due Sep 6, 2013 @ class time
•  Homework 2 due Sep 25, 2013 @ class time
•  Homework 3 due Oct 23, 2013 @ class time
•  Homework 4 due Nov 18, 2013 @ 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 or email before the deadline.

 

Projects

•  Project 1 due Sep 13, 2013 @ 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 16, 2013 @ 11:59 pm Project description/data.sql/query results on sample data/ views on sample data
•  Project 3 due Nov 15, 2013 @ 11:59 pm Project description/data.sql/procedure results on sample data
•  Project 4 due Dec 2, 2013 @ 11:59 pm Project description/Code template/AppEngine Installation Guide  
•  Project 4 (Extended Version), Project description  

 

 

Other Handouts

• 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