(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
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.
Please feel welcome to contact
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.