CS448: Introduction to Database Systems

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

Homework, Projects & Handouts

Homework

• Homework1 Due 1/31/2014 before class.

• Homework2 Due 02/17/2014 before class.

• Homework3 Due 03/07/2014 before class.


• Homework4 Due 04/14/2014 before class.
  

   
***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

• Project1 data.sql Due 02/14/2014 at 11:50 pm NOTE the updated version

• Project1b (for students who took CS348 with Prof. Bhargava.)  02/21/2014 at 11:50 p

• Project 2 Due 04/07/2014 11:50p

  Test cases: You can use the command sets in the following files (in the same order as the files are listed here) to test your application.
  admin1.sql (execute as the admin user)
  user1.sql (execute as user1)
  user2.sql (execute as user2)
  admin2.sql (execute as the admin user)
  user5.sql (execute as user5)
  Expected outputs
  
  Grading test cases: Your projects were graded using the test files below (in the same order as the files are listed here).
  admin1.sql (execute as the admin user)
  userA1.sql (execute as userA1)
  userB1.sql (execute as userB1)
  admin2.sql (execute as the admin user)
  userB2.sql (execute as userB2)
  
  
• Project 3 (Choose any of the below) Due 4/23/2014
  
• Research Assignment
• Data Mining/ojdbc6.jar
  output for k=1, num_training=111
  output for k=3, num_training=111
  output for k=4, num_training=111
  output for k=5, num_training=111
  output for k=7, num_training=111
  output for k=3, num_training=75
  output for k=3, num_training=60
  
• Role Based Access Control/ojdbc6.jar