CS348 Spring 2016: Information Systems
Instructor
Office Hours 10:30 am – 12:00 pm Monday
Location LWSN 2142G
Teaching Assistants
Jason Meng
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
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)