|
SSC, 6. semester
Introduction to Information Systems
Description
Databases are at the heart of modern commercial
application development. Their use extends beyond this to many
applications and environments where large amounts of data must be stored
for efficient update and retrieval. The purpose of this course is to
provide an introduction to the design and use of database systems,
as well as an appreciation of the key issues in building such systems in
heterogeneous and Web environments.
We begin by covering the relational model and the SQL
language. We then study methods for database design, covering the entity
relationship model. Next, we discuss XML as a data model, and present
languages for querying it. We see how XML is used for sharing data among
different applications in a distributed environment. Finally, we touch on
some advanced topics on the implementation of database systems, such as
transactions and indexing.
Credits: 4
Written exam (The exam will be written and comparable to
the exercises. It also will refer to aspects treated in the project.)
Time and Place: Friday 08:00 - 10:00, room ELA 1, Friday 10:00 - 12:00,
INF 1, INF 3 and INM 200.
Newsgroup: epfl.ic.cours.IIS
Prerequisites
Team
Exercises
- All exercises are done individually.
- Please read these practical guidelines
before starting to work on the exercises.
Finale Grade
Projects
Lecture Schedule
| Date |
Slides/Homeworks
Title |
Homework/Project
Deadline/Solution |
| 12.03.04 |
Lecture: Introduction (ppt), Basic SQL
(ppt) |
|
12.03.04
|
Exercise 1:
SQL |
|
19.03.04
|
Lecture:
Advanced SQL (ppt) |
|
26.03.04
|
Lecture:
Conceptual Modelling and Schema Design (ppt) |
Exercise 1 due (solution)
|
26.03.04
|
Project phase 1, step1 : requires
SQL, ER Modeling, mapping ER-SQL, finish in 1 week |
|
02.04.04
|
Lecture:
Database Programming, JDBC (ppt) |
Projects phase 1, step 1 due
|
02.04.04
|
Project phase 1,
step2: requires JDBC, finiish in 3 weeks |
|
09.04.04
|
Easter Holiday |
|
16.04.04
|
Easter
Holiday |
|
23.04.04
|
Lecture:
Functional Dependencies (ppt) |
Project phase 1, step 2 due
|
| 23.04.04 |
Exercise 2:
Functional Dependencies and Rel. Algebra |
Solution |
23.04.04
|
Project phase 2,
step 1: requires FD
and Rel. Algebra, finish in 2 weeks |
|
30.04.04
|
Lecture:
Relational Algebra (ppt) |
|
07.05.04
|
Lecture:
Introduction to XML (ppt) |
Exercise 2 due, Project phase 2,
step 1, due,
debriefing phase 1
|
07.05.04
|
Exercise 3:
XML and XQuery |
|
| 07.05.04 |
Project phase 2,
step 2: requires
JSP and less XML, finish in 2 weeks |
|
14.05.04
|
Lecture:
XML and XQuery (ppt) |
|
21.05.04
|
Lecture:
Web Services (ppt) |
Exercise 3 due (solution), Project phase 2,
step 2 due
|
| 21.05.04 |
Project phase 3, step 1: requires
Web Services, Transactions, finish in 2 weeks (Rules
of the Bidding Game) |
|
28.05.04
|
Lecture:
Transactions (ppt) |
|
28.05.04
|
Exercise 4:
Transactions
|
(solution)
|
04.06.04
|
Lecture:
Recovery (ppt) |
Project phase 3, step 1, due
|
04.06.04
|
Project phase 3, step 2: no add.
requirements, finish in 2 weeks |
|
11.06.04
|
Lecture:
Database Heterogeneity
(ppt) |
Exercise 4 due
|
18.06.04
|
Test Exam |
Test Exam (solution)
|
Programming
Some programming will be necessary in this course for the project. One
can only start to appreciate database systems by actually trying to use
one. The exercises will be with mostly no programming (except the first
one).
Tools
The World-Wide Web and e-mail will be used extensively to provide you
with course information, such as the schedule mentioned above, homework
assignments and solutions, class messages and many other things.
Web sources
Literature
Main book
|
| |
Databases and Transaction Processing, An application-oriented
approach: Philip M. Lewis, Arthur Bernstein, Michael Kifer,
Addison-Wesley 2002.
|
Other books
|
| |
Database Systems: The Complete Book: Hector Garcia-Molina, Jeffrey
Ullman, Jennifer Widom |
| |
Database Management Systems: Ramakrishnan |
| |
Fundamentals of Database Systems, Elmasri, Navathe |
| |
Database Systems, Date (7. edition) |
| |
Modern Database Management, Hoffer, (4. edition) |
| |
Database Systems Concepts, Silverschatz, (4. edition)
|
Attendance
I hope you will attend every lecture. If you miss a lecture, talk to a
friend who was present, and be sure to check the Web site for any
information passed during the lecture.
Academic Misconduct
All work turned in is expected to be your own. Although students are
encouraged to study together, each student is expected to produce his or
her own solution to the homework problems and projects. Copying or using
sections of someone else's or some other group's program, even if it has
been modified by you, is not acceptable.
|