CS3431. Database
Systems I
Required Textbook / Reading
For about 20% of the
class, where we learn ER model, and translation between ER and
relational models, we will use slides developed at WPI. However, for
relational model, relational algebra, SQL and other topics, we will
closely follow the required text book.
- A First
Course in Database systems.
- Third Edition, 2008.
- Jeffrey D. Ullman and Jennifer D. Widom
- Prentice Hall.
- ISBN: 013600637X
- URL:
The Prentice-Hall (Pearson Store) Web Page
Other Recommended
Books / Reading
If you are interested
in databases, you may want to buy the complete version of the above
required text book, including database implementation aspects. The
first part of this complete book is what is used for cs3431, and
the second part of this complete book is currently used for CS 4432.
Buying the combined book will be cheaper than buying the 2 books separately.
- Database
Systems: The Complete Book, Second Edition
- Hector Garcia-Molina, Jeffrey D. Ullman and
Jennifer D. Widom
- Prentice Hall, 2009.
- ISBN: 0131873253
- URL:
The Prentice-Hall (Pearson Ed) Web Page
For additional
references on SQL, online references are very useful. You may also use
the following book.
- Oracle9i
Programming: A Primer by Rajshekhar Sunderraman,
Addison-Wesley
There are several
other excellent database textbooks available, which cover the syllabus
for this course, and 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.