This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: CSC/CPE 366: Database Modeling, Design and Implementation Winter 2008 Course Syllabus January 8, 2008 Instructor: Alexander Dekhtyar email: email@example.com office: 14-209 What When Where Lecture TR 12:10 1:30pm 14-252 Lab TR 1:40 3:00pm 14-302 (Database Lab) Final Exam March 20, (R) 1:10 - 4:00pm 14-252 Office Hours When Where Tuesday 3:00pm - 4:00pm 14-209 Wednsday 9:00am - 12:00pm 14-209 Thursday 3:00am - 4:00pm 14-209 Additional appointments can be scheduled by emailing the instructor at firstname.lastname@example.org . Overview This course will explore a variety of topics related to design and implementa- tion of database applications. During the course, the students will learn the techniques for building relational database models for applications and tuning database design for best performance, will obtain experience in building an ac- tual database application and will learn the basic concepts of object-oriented, object-relational and semistructured database models. Course labs will use Or- acle DBMS. 1 Texbook Required: A First Course in Database Systems (3rd Edition) , Jeffrey D. Ull- man, Jennifer Widom, 2007, Prentice Hall. Recommended: Oracle 10g Programming: a primer , Rajshekhar Sunderraman, Addison Wesley, 2007. Note: this was your CPE 365 textbook. As the course involves significant application development component which will involve Oracle DBMS, this book will be a useful reference Database Systems. The Complete Book , H. Garcia-Molina, J.D. Ullman, J. Widom, 2002, Prentice Hall. Note: This book includes the full version of 2nd Edition of the required text, and for most of the course can be used as a substitute, especially if you are considering taking CSC/CPE 468 in near future. However, be warned, that it lacks the new content that is found in the 3d Edition of the required text. Topics The following will be covered in the course. No. Topic Duration (weeks) 1. Introduction: Database Modeling 1 2. Conceptual Modeling using Entity-Relationship models 2 3. Constraints and Triggers 1 4. Database Tuning, Functional Dependencies, Theory of Normal Forms 1-2 Midterm Topics 1 4. 5. Object-Oriented and Object-Relational Databases 1-2 6. Semistructured Databases and XML 2 Final Exam Comprehensive Most of the topics will be covered in the order specified above, but some variations are possible during the course. Grading Homeworks 10-20% Labs and Project 35-40% Midterm Exam 20 - 25% Final Exam 25 - 30% I give relatively hard problems and take points off on exams. Because of this, the traditional 90-A, 80-B, 70-C grading schema does not work in my classes....
View Full Document
This note was uploaded on 05/19/2008 for the course CSC 365 taught by Professor Dekhtyar during the Spring '08 term at Cal Poly.
- Spring '08