CS348 Spring 2012: Information Systems
Instructor
Office Hours Monday 10:30 am – 12:00 pm
Location LWSN 2142G
Teaching Assistant
Shahul
Hameed Khajamohideen
skhajamo@purdue.edu
Office Hours Tuesday 12:00pm – 1:00pm
Location
LWSN B116G
Class Schedule
MWF 8:30am-9:20am Haas Hall G066
Final
Wed 05/02 7:00pm-9:00pm
LAMB 108
Course Project Deadline April 20th, 2012, 11:59pm.
Textbook
Elmasri, Navathe. Fundamentals of Database
Systems. Sixth Edition.
Grading Policy (tentative)
·
Midterm 30%
·
Final 30%
·
Homeworks 20%
·
Project 20%
Class Schedule
January 9 Course Overview – Introduction to Database Systems Chapter 1
January 11 Introduction to Database Systems Chapter 1
January 13 Concepts and Architectures Chapter 2
January 16 NO CLASS
January 18 The Relational Data Model Chapter 3
January 20 The Relational Data Model Chapter 3 HW1 Answer Key
January 23 Basic SQL Chapter 4
January 25 Advanced SQL Chapter 5
January 27 Advanced SQL Chapter 5 HW2 Answer Key
January 30 Advanced SQL Chapter 5
February 1 Relational Algebra and Calculus Chapter 6
February 3 Relational Algebra and Calculus Chapter 6 HW3 Answer Key
February 6 Data Modeling – the ER Model Chapter 7
February 8 Data Modeling – the ER Model Chapter 7
February 10 The Extended ER Model Chapter 8
February 13 Model Mapping – from ER Model to Relational Model Chapter 9
February 15 Model Mapping – from ER Model to Relational Model Chapter 9
Chapter 10 Read on your own
February 17 Normalization Theory Slides to use HW4 Answer Key
Chapter 15
February 20 Normalization Theory Chapter 15
February 22 Relational Database Design Algorithms Chapter 16
February 24 Relational Database Design Algorithms Chapter 16
February 27 Object and Object-Relational Databases Chapter 11
February 29 Object and Object-Relational Databases Chapter 11
March 2 Midterm The midterm will cover all materials presented until February 24th (included).
March 5 Object and Object-Relational Databases Chapter 11
March 7 Object and Object-Relational Databases Chapter 11
March 9 Object and
Object-Relational Databases Chapter
12
March 12 NO CLASS – Spring Break
March 16 NO CLASS – Spring Break
March 19 XML Chapter
13
March 21 DBMS Architectures – File Structures Chapter 17
March 23 DBMS Architectures – File Structures Chapter 17 HW5 Answer Key
March 26 DBMS Architectures – Indexing Techniques Chapter 18
March 28 DBMS Architectures – Indexing Techniques Chapter 18
For B-Trees and B+-Trees use these slides
March 30 DBMS Architectures - Indexing Techniques Chapter 18 HW6 Answer Key
April 2 DBMS Architectures - Query Processing and Optimization Chapter 19
April 4 DBMS Architectures - Query Processing and Optimization Chapter 19
April 6 Physical Database Design and Tuning Chapter 20
April 9 Transaction Processing Chapter 21
April 11 Transaction Processing Chapter 21
April 13 Concurrency Control Techniques Chapter 22 (only sections 22.1, 22.5)
April 16 Database Recovery Techniques Chapter 23 (only sections 23.1, 23.5)
April 18 Database Recovery Techniques Chapter 23
April 20 Database Security Chapter 24
April 23 Dead Weak
April 25 Dead Weak
April 27 Dead Weak
IMPORTANT INFORMATION
ABOUT HW
1)
Each homework 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 a homework.
4) The
student, wishing to use the exception, must notify the TA (Shahul Hameed Khajamohideen <skhajamo@purdue.edu>)
that he/she intends to use the exception; this notification must be sent by the
deadline indicated on the homework.
PSO Schedule
PSO1 Week
of Jan 23-Jan 27
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 30 - Feb 3
Topics: Advanced SQL (More SQL Commands, Using Joins, Group By)
PSO3 Week
of Feb 13 - Feb 17
Topics: PL/SQL in Oracle (Creating procedures, triggers)
PSO4 Week
of Feb 27 - Mar 2
Topics: Developing Applications using JDBC - Part 1 (What is JDBC,
Using JDBC to connect to an Oracle database)
PSO5 Week
of Mar 26 - Mar 30
Topics: PSO 5 - Developing Applications using JDBC - Part 2 (Using
Java Servlets, JSP to develop database applications using JDBC)
PSO6 Week
of Apr 2 - Apr 6
Topics
– this PSO will be used
to clarify doubts about the project
PSO7 Week
of Apr 16 - Apr 20
Topics
– this PSO will be used
to clarify doubts about the project