This course covers the essential concepts, principals, techniques, and mechanisms for the design, use and implementation of computerized database systems. Concentration will be on the Relational model, with an overview of the other significant models, Hierarchical and Network. The query language SQL will be studied in some detail. Planning and design of databases through the ER model and normalization are also covered. Most assignments will be done using ORACLE Database software. Thus the student will be introduced to the ORACLE system and gain familiarity with its components.
By providing a balanced view of theory and practice, the material covered should give the student an understanding and use of practical database systems. CS 275 provides practical examples of concepts taught in other Computer Science courses, including locking and buffer management (Operating Systems), data structuring (Data Structures), indexing and query processing algorithms (Algorithms), and their use in solving database problems.
|Introduction to Databases||1.1 - 1.6||SQL: Data Definition||6.1 - 6.6|
|Database Environment||2.1 - 2.6||Entity-Relationship Modeling||11.1 - 11.6|
|The Relational Model||3.1 - 3.4||Enhanced E-R Modeling||12.1|
|The Relataional Algebra||4.1||Normalization||13.1 - 13.9|
|SQL: Data Manipulation||5.1 - 5.3||Transaction Management||20.1 - 20.3|
A term project involving the implementation of a database is associated with the course. This is a group project, with group sizes of 2 to 3 persons. The project plan and its design are due on Tuesday, February 19th (January 29th).
Printable version here.