CMPE 226 - Database Systems
Spring 2008
- Lectures: Tuesday, 6:00 - 8:45 PM, Clark Building 302
CMPE 226 Green Sheet
- Instructor:
- Magdalini Eirinaki
- Office: ENG 283F
- Phone: (408) 924 3828
- Office Hours: T 3 - 5 PM, Th 5 - 8 PM, or by appointment
All CmpE students are required to read and aggree to the CmpE Honesty PledgeAll materials associated with this class (handouts, lecture slides, announcements, discussions, important dates, etc.) will be posted on the SJSU eCampus environment (CE6).
Textbook:
Database Systems, The complete book, by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom, Prentice Hall (2002)
Students are encouraged to buy the version of the book containing the access code to the Gradiance Online Accelarated Learning (GOAL) system, since most homework assignments will use it. Alternatively, students may purchase an access code separately from the textbook. Please contact the instructor if you have questions on this matter.
Syllabus (tentative)
| Topics | Lectures |
| Introduction | 1 |
| E-R model | 1 |
| Relational model | 1 |
| Relational Algebra/Calculus | 1-2 |
| SQL | 1-2 |
| Transaction Management | 1-2 |
| Functional Dependencies | 1-2 |
| Data Storage and Buffering | 1 |
| Indexing | 1 |
| Query Evaluation | 1 |
| Logical Query Languages | 1 |
| Alternative Data Models | 1 |
| Data Warehousing and Data Mining | 1 |