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)