syllabus.366 - CSC/CPE 366 Database Modeling Design and...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
CSC/CPE 366: Database Modeling, Design and Implementation Winter 2008 Course Syllabus January 8, 2008 Instructor: Alexander Dekhtyar email: [email protected] 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 [email protected] . 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
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
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.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern