CS3431. Database
Systems I
Required Textbook / Readings
The material covered
in this course will follow the main text book. Homeworks
may also be designed based on this course book. Thus all students
are expected to assure that they have regular access to the textbook,
preferably by purchasing it or by borrowing for the term.
The slides utilized in this course were developed
for this course, and further refined
through several past offerings of this course by instructors
here at WPI, emphasizing relevant material from the book.
Some adjustments will be made as the course progresses.
- A First
Course in Database systems.
- Third Edition (2008).
- Jeffrey D. Ullman and Jennifer D. Widom
- Pearson Prentice Hall.
- ISBN: 0-13-600637-X
- URL:
The Prentice-Hall Web Page
The old version of this same textbook that you should be able
to get a used version is similar in content, but the newer
version does have a few changes. Information on the 2002 version of the
book can be found at :
- A First
Course in Database systems.
- Second Edition (2002).
- Jeffrey D. Ullman and Jennifer D. Widom
- Prentice Hall.
- ISBN: 0-13-035300-0
-
URL:
The Prentice-Hall Web Page
Other Recommended
Books / Reading
Instead of above,
if you are interested
in databases and you are planning on taking the second database course
(CS4432), we could also purchase the complete version of the above
text book. This complete book includes all of the material
on database design and modeling as
required for this CS3431 class (in the first 10 chapters of this book),
as well as all material on database implementation aspects
currently required for CS4432 (roughly in the next 10 chapters of this book).
Buying the combined book will be cheaper than buying the 2 books separately,
but you will end up carrying a heavier book around with you
for 2 terms. The choice is yours.
- Database
Systems: The Complete Book
- Hector Garcia-Molina, Jeffrey D. Ullman and
Jennifer D. Widom
- Prentice Hall.
- ISBN: 0-13-031995-3
- URL:
The Prentice-Hall Web Page
For additional
references on SQL, online references are very useful. You may also use
the following book.
-
Oracle 10g Programming:
A Primer by Rajshekhar Sunderraman,
Addison-Wesley Publisher.
There are several
other excellent database textbooks available, which cover the syllabus
for this course. You may also find them useful for
reference.
-
Database Management
Systems, by Raghu Ramakrishnan and Johannes Gehrke,
McGraw-Hill.
-
Fundamentals of
Database Systems, by Ramez Elmasri and Shamkant Navathe, Addison
Wesley.
-
An Introduction to
Database Systems, by C. J. Date, Addison
Wesley.