UCSCBaskin School of Engineering  
General Information Events, News & Organizations Degrees & Departments Research Classes Admissions & Advising People & Jobs Administration
CMPS 180 - Spring 2003

Course Objectives

The course deals with the use of database management systems (DBMSs). Most commercial computer applications involve the use of a DBMS to store information. A bank ATM (automated teller machine) has access to your balance stored in a database. When you use a credit card, information about your card and each transaction is stored in a database. The state Department of Motor Vehicles keeps track of your drivers license and your car in databases. This course will cover the design of database systems, important database theory, SQL, programming and relational databases, and logical, object-oriented, object-relational and XML databases. The course will also involve a multi-part project using PostgreSQL, an SQL database, and the web.

Specifically this course will address:

  1. The background and history of database management systems
  2. The fundamentals of using a database management systems
  3. Industry standards used for database management systems
  4. Theoretical background of the relational model
  5. Queries and Updates
  6. Transactions and Security
  7. Logical, object-oriented, object-relational, semi-structured and XML database systems.
  8. Data warehouses and data mining.

Arthur M. Keller, UC Santa Cruz, Computer Science Dept., Baskin School of Engineering, ark@soe.ucsc.edu

General info · News · Events · Degree Programs · Research · Classes · Admissions · Advising · People · Jobs · Administration
SOE Webmail · SOE SSH · SOE Wiki · Search · Sitemap · Contact us · Driving directions · Privacy · UCSC
© Baskin School of Engineering, University of California, Santa Cruz
1156 High St., Santa Cruz, CA 95064 · (831) 459-2158 · webmaster@soe.ucsc.edu