CS348 Spring 2016: Information Systems

 

Instructor
    Elisa Bertino

    bertino@cs.purdue.edu

Office Hours 10:30 am 12:00 pm Monday

Location LWSN 2142G

 

Teaching Assistants

Jason Meng

    meng40@purdue.edu

Office Hours 4:00 pm 5:00 pm Thursday Office Hours Location HAAS G16

 

Romila Pradhan

    rpradhan@purdue.edu

Office Hours 2:30 pm 3:30 pm Monday Office Hours Location LWSN B116

 

Aaron Rodgers

Rodgers9@purdue.edu

Office Hours 12:00 pm 1:00 pm Thursday and Friday - Office Hours Location LWSN B116J

 

 

MIDTERM: March 9th, 9:30am-10:30am Location: MATH 175

 

FINAL: May 5th, 1:00pm-3:00pm Location: RHPH 172

 

 

Course Project Deadlines

Project1 deadline: March 4th, 2016

Project2 deadline: April 8th, 2016

Project3 deadline: April 27th, 2016

 

Class Schedule

MWF 9:30am-10:20am LWSN B155

 

PSO Schedule

Section 1 T 9:30-11:20am LWSN B148

Section 2 M 3:30-5:20pm LWSN B148

Section 3 T 1:30-3:20pm LWSN B158

Section 4 W 3:30-5:20pm HAAS G040


   

Material:

Course slides

Silberschatzm Korth, Sudarshan. Database System Concepts. Six Edition.

 

Grading Policy

         Midterm 25% 

         Final 30%

         Homeworks 10%

         Project 1 10%

         Project 2 15%

         Project 3 10%

 

Academic Integrity Policy

Purdue University values intellectual integrity and the highest standards of academic conduct. To know and understand what academic integrity is, what is expected from you, and what you should NOT do, read carefully this document: Academic Integrity

 

CS348 Academic Integrity Policy

All CS348 course work must be done individually.

 

In CS348, a first instance of academic dishonesty results in a zero for that assignment plus a letter grade deduction at the end of the semester. A second instance of academic dishonesty results in a grade of F.

 

We encourage discussion of any CS348 topic including ideas about how to do the projects. But, under no circumstances is exchange of code via written or electronic means permitted between CS348 students. It is considered dishonest either to read someone else's solution or to provide a classmate with a copy of your work. Do not make the mistake of thinking that superficial changes in a program (such as altering comments, changing variable names, or interchanging statements) can be used to avoid detection. If you cannot do the work yourself, it is extremely unlikely that you can succeed in disguising someone else's work. We are adamant that cheating in any form is not tolerated. Even the most trivial assignment is better not done than if you cheat to complete it.

 

We will use software tools to check plagiarism among submitted assignments. Additionally, the instructor and TAs will inspect all submitted material to ensure honesty.

 

 

Class Schedule

 

January 11 Course Overview Introduction to Database Systems

January 13 The Relational Model

January 15 The Relational Algebra

 

January 18 No Class

January 20 SQL Data Types

January 22 SQL Table Creation HW1

 

January 25 SQL Table Creation

January 27 SQL Table Creation

January 29 SQL Queries HW2

 

February 1 SQL - Queries

February 3 SQL Queries

February 5 SQL Updates HW3

 

February 8 SQL Views

February 10 Active Databases

February 12 Active Databases

 

February 15 Active Databases

February 17 Data Modeling the ER Model

February 19 Data Modeling the ER Model Project1 Assigned

 

February 22 Model Mapping from ER Model to Relational Model

February 24 Normalization Theory

February 26 Normalization Theory HW4

 

February 29 Presentation of Project2 - SQL via MapReduce Project2 Assigned

March 2 Normalization Theory

March 4 Relational Database Design Algorithms

March 7 Relational Database Design Algorithms

March 9 Midterm MATH 175

March 11 Canceled

 

March 14 NO CLASS Spring Break

March 16 NO CLASS Spring Break

March 18 NO CLASS Spring Break

 

March 21 DBMS Architectures Introduction

March 23 DBMS Architectures - Indexing Techniques

March 25 DBMS Architectures - Indexing Techniques

 

March 28 DBMS Architectures - Query Optimization

March 30 DBMS Architectures - Query Optimization

April 1 DBMS Architectures - Query Optimization HW5

 

April 4 DBMS Architectures - Query Optimization

April 6 DBMS Architectures - Query Optimization

April 8 DBMS Architectures - Database Access Control Project3 Assigned

April 11 DBMS Architectures Database Access Control

April 13 DBMS Architectures Transactions Management and Recovery

April 15 DBMS Architectures Transactions Management and Recovery

 

April 18 DBMS Architectures Transactions Management and Recovery

April 20 Advanced Topics Information Retrieval

April 22 Advanced Topics Information Retrieval

 

April 25 Course conclusion

April 26 Dead Weak no class

April 27 Dead Weak no class

 

IMPORTANT INFORMATION ABOUT HW

1)      Each homework and project must be returned by the deadline indicated on the homework.

2)      Each student is granted a maximum of two exceptions with respect to the indicated deadline.

3)      Each exception grants an additional week for completing the homework/project.

4)      The student, wishing to use the exception, must notify the TAs that he/she intends to use the exception; this notification must be sent by the deadline indicated on the homework/project.

 

 

PSO Schedule

 

PSO1 Week of Jan 18-Jan 22

Topics: Introduction to Oracle, Connecting to CS Oracle Server, Basic SQL Commands (Creating and Deleting tables, Inserting rows in a table, Basic querying)

 

PSO2 Week of Jan 25 Jan 29

Topics: Advanced SQL (More SQL Commands, Using Joins, Group By)

 

PSO3 Week of Feb 1 - Feb 5

Topics: PL/SQL in Oracle (Creating procedures, triggers)

 

PSO4 Week of Feb 8 Feb 12

Topics: Developing Applications using JDBC - Part 1 (What is JDBC, Using JDBC to connect to an Oracle database)

 

PSO5 Week of Feb 15 Feb 19

Topics: PSO 5 - Developing Applications using JDBC - Part 2 (Using Java Servlets, JSP to develop database applications using JDBC)

 

PSO6 Week of Feb 22 Feb 26

Topics this PSO will be used to clarify doubts about the project

 

 

 

FINAL May 01-07 (TBD)