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. Sixth Edition.

   

 

Grading Policy

·         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

 

            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