CPS 430/542: Database Management Systems/Fall 2005

(from the undergraduate bulletin)
The goal of CPS 430/542 (3 semester hours) is to study physical and logical organization of databases: the entity-relationship model; relational database model; the data definition and data manipulation language of a commercial database management system; integrity constraints; conceptual database design.

(instructor's perspective)
CPS 430/542 offers an introduction to the study of modern database systems. The course focuses on modeling and programming databases. Students can expect illustration of E/R modeling, a theoretical coverage of the relational model, practical exposure to programming a commercial DBMS, and discussion of the role of a database in a larger application. Programming will be done in SQL under Oracle 8.* in the UNIX programming environment. This course assumes no prior knowledge of database systems.

Syllabus (pdf)

Meeting Times: M W 4:30-5:45p, SC150

Instructor: Dr. S. Perugini, AN 145, 229-4079, perugisa at notes dot udayton dot edu, OHs: M W 3:30-4:30p, T Th 5:45-6:45p and by appointment.

Graduate Teaching Assistant: Karthik Ganesan Pillai, MH 21, 229-2199, ganesakz at notes dot udayton dot edu, OHs: W F 11:00a-1:00p and by appointment.

Required Textbook: [FCDB] A First Course in Database Systems by J.D. Ullman and J. Widom. Prentice Hall, Second Edition, 2002. ISBN: 0-13-035300-0.

Lectures and Reading Assignments:
(click on a date to view lecture summary for that class)
  1. Introduction, history, data models (Ch1): Aug 22, 24
  2. Data modeling: E/R model (Ch2): Aug 29, 31, Sep 7, 12
  3. Relational model (Ch3): Sep 14, 19, 21, 26, 28, Oct 3, 5, 12, 17, 19, 24, 26, 31, Nov 2
  4. Queries in relational algebra, SQL, and datalog (Ch5, 6, 10): Nov 7, 9, 14, 16, 21, 28, 30, Dec 5, 7
    Midterm Exam (Oct 24, closed book, closed notes; no exemptions)
    Final Exam (4:30-6:20p, Dec 12, SC150; comprehensive, closed book, closed notes; no exemptions)
Course slides: Module 1 (Introduction, E/R model, relational model) | Module 2 (Queries)

Homeworks:   1 | 2 | 3 | 4 | 5 | 6 | 7
Solution Sketches:   1 | 2 | 3 | 4 | 5 | 6 | 7

Project (phases): 1 (modeling) | 2 (conversion to normalized relations) | 3 (writing an SQL schema)

Grades: WebCT

Software tools (for drawing E/R diagrams): Graphviz Xfig Dia SmartDraw

Accounts: CPS Account Access @ Home  UNIX Account Access  Using Oracle 8  Using PROLOG  CPS Labs Hours  Keeping your Password Safe  A Beginner's Guide to Effective E-Mail 
If you are unable to log into your CPS (Windows or UNIX) account or if you forgot your CPS (Windows or UNIX) account password, contact the CPS systems administrator, Mr. Halter, at dean.halter at notes dot udayton dot edu or 229-3835, and be as specific as possible. Mr. Halter's office is located in the back of AN 131 and his office hours are M-F 8:00-5:00p.

Readings and Resources: webpage for our textbook [FCDB] | MySQL in the news

Helpful Links: UD Academic Calendar  UD Student Handbook  UDit Policies  UD Official WWW Policy

Feedback: Please feel welcome to contact your instructor, Dr. Perugini, to provide any feedback you may have on the style of the lectures, the concepts presented in class, the course webpage, homeworks, the course project, deadlines, course and grading policies, or your general experience in the course.
(c) S. Perugini, Fall 2005, University of Dayton. Permission to use ideas about the organization of topics and any notes or material is granted, provided suitable acknowledgments and citations are made.