CS348 Spring 2017: Information Systems

 

Instructor
    Elisa Bertino

    bertino@cs.purdue.edu

Office Hours 10:00 am 11:00 am Wednesday

Location LWSN 2142G

 

Teaching Assistants

Anshu Maheshwari 

   maheshw3@purdue.edu

Office Hours Monday 3-4pm Office HAAS G50

 

Karan N Prabhu prabhuk@purdue.edu

Office Hours Tuesday 3pm-4pm HAAS G50

 

Romila Pradhan

    rpradhan@purdue.edu

Office Hours Wednesday 10:30-11:30am Office HAAS G50

 

Devesh Kumar Singh

singh349@purdue.edu

Office Hours Thursday 4-5pm Hours Office HAAS G50

 

MIDTERM: March 22nd, 6:30pm-7:30pm Location: PHYS 112

 

FINAL: May 2nd, 1:00pm-3:00pm Location: PHYS 114

 

 

Course Project Deadlines

Project deadline: TDB

 

Class Schedule

MWF 8:30am-9:20am ARMS 1010

 

PSO Schedule

Section 1 T 7:30-9:20am HAAS 257

Section 2 T 11:30-1:20pm LWSN B146

Section 3 F 1:30-3:20pm LWSN B146

Section 4 F 1:30-3:20pm LWSN B146

Section 5 F 11:30-1:20pm LWSN B146

Section 6 R 1:30-3:20pm HAAS 257


   

Material:

Course slides

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

 

Grading Policy (tentative)

         Midterm 30% 

         Final 30%

         Homeworks 10%

         Project 30%

 

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 9 Course Overview Introduction to Database Systems

January 11 The Relational Model

January 13 The Relational Algebra

 

January 16 No Class

January 18 SQL Data Types

January 20 SQL Table Creation HW1

 

January 23 SQL Table Creation

January 25 SQL Table Creation

January 27 SQL Queries HW2

 

January 30 SQL - Queries

February 1 SQL Queries

February 3 SQL Updates HW3

 

February 6 SQL Views

February 8 Active Databases

February 10 Active Databases

 

February 13 Active Databases

February 15 Data Modeling the ER Model

February 17 Data Modeling the ER Model Project Assigned (tentative)

 

February 20 Model Mapping from ER Model to Relational Model

February 22 Normalization Theory

February 24 Normalization Theory HW4

 

February 27 Normalization Theory

March 1 Normalization Theory

March 3 Relational Database Design Algorithms

March 6 Relational Database Design Algorithms

March 8 DBMS Architectures Introduction

March 10 DBMS Architectures - Indexing Techniques

 

March 13 NO CLASS Spring Break

March 15 NO CLASS Spring Break

March 17 NO CLASS Spring Break

 

March 20 DBMS Architectures - Indexing Techniques

March 22 Class Canceled - Midterm

March 24 DBMS Architectures - Indexing Techniques

 

March 27 DBMS Architectures - Query Optimization

March 29 DBMS Architectures - Query Optimization

March 31 DBMS Architectures - Query Optimization HW5

 

April 3 DBMS Architectures - Query Optimization

April 5 DBMS Architectures - Query Optimization

April 7 DBMS Architectures - Database Access Control

April 10 DBMS Architectures Database Access Control

April 12 DBMS Architectures Transactions Management and Recovery

April 14 DBMS Architectures Transactions Management and Recovery

 

April 17 DBMS Architectures Transactions Management and Recovery

April 19 Advanced Topics Information Retrieval

April 21 Advanced Topics Information Retrieval

 

April 24 Dead Weak no class

April 26 Dead Weak no class

April 28 Dead Weak no class

 

IMPORTANT INFORMATION ABOUT HW AND PROJECT

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

2)      Submissions of homeworks and projects are accepted only within 10 days from the return deadline indicated on the homework and on the project.

3)      10 points will be deducted for each day (fraction of day) of delay in returning the homework or the project.

 

PSO Schedule

 

PSO1   Week of Jan 16-Jan 20

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 23 Jan 27

Topics: Advanced SQL (More SQL Commands, Aggregates, Joins)

 

PSO3   Week of Jan 30 - Feb 3

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

 

PSO4   Week of Feb 6 - Feb 10

Topics: Developing Applications using JDBC - (Using JDBC to connect to an Oracle database)

 

PSO5   Week of Feb 13 Feb 17

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

 

PSO6   Week of Feb 20 Feb 24 

Topics: Questions on project

 

PSO7   Week of Feb 27 Mar 3

Topics: Questions on project

 

PSO8   Week of Mar 6 Mar 10

Topics: Questions on project

 

PSO9   Week of Mar 20 Mar 24

Topics: Questions on project