CS348 Spring 2017: Information Systems
Instructor
Office Hours 10:00 am – 11:00 am Wednesday
Location LWSN 2142G
Teaching Assistants
Anshu Maheshwari
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
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