This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: CSC/CPE 365: Introduction To Database Systems Fall 2007 Course Syllabus September 14, 2007 Instructor: Alexander Dekhtyar email: [email protected] office: 14-209 What When Where Lecture TR 1:40 – 3:00pm 20-140 (Eng. East) Lab TR 3:10 – 4:30pm 14-302 (Database Lab) Final Exam Dec 6 (R) 1:10 - 4:00pm 20-140 (Eng. East) Office Hours When Where Tuesday 11:00am - 12:00pm 14-209 Wednsday 9:00am - 12:00pm 14-209 Thursday 11:00am - 12:00pm 14-209 Additional appointments can be scheduled by emailing the instructor at [email protected] . Overview This is an introductory database course devoted to study of the principles of op- eration of modern relational database systems. During the course the students will learn the basic concepts of data management, the principles of operation of relational DBMS (Database Management Systems) and the principles of build- ing database applications on top of relational DBMS. The students will study the SQL query language for relational data, and will learn how to use it to construct software that relies on DBMS to manage its data. In addition, some theoretical 1 aspects of database management will be covered, as well as an overview of the internal organization of the DBMS. Course labs will use Oracle DBMS. Texbook Required: Oracle 10g Programming: a primer , Rajshekhar Sunderraman, Ad- dison Wesley, 2007. Recommended: (this an “or” list, one of the books below is sufficient) • Database Systems. The Complete Book , H. Garcia-Molina, J.D. Ullman, J. Widom, 2002, Prentice Hall. or A First Course in Database Systems , J.D. Ullman, J. Widom, 2001, 2nd Edition, Prentice Hall. • Database Management Systems , R. Ramakrishnan, J. Gehrke, 3d Ed., McGraw-Hill, 2003. • Database System Concepts , A. Silberschatz, H. Korth, B. Sudarshan, 4th or 5th Ed., McGraw-Hill, 2002/2005. Note: In general, there are other database theory textbooks that cover roughly the same material in roughly the same way. Any such textbook (Date, Elmasri-Navathe, Kifer-Bernstein-Lewis) and any edition published within the last 7-10 years will serve as a useful supplement for the required text. I only caution you to be careful when matchin notation used in a particular textbook with the notation used in class....
View Full Document
- Spring '08
- Databases, Relational model, Database management system, Mailing list