Database Systems

Catalog description

This course will give the student an overview of application development using data base management systems (DBMS). Conceptual database design, data modeling and data normalization will be presented and practiced. Structured query language (SQL) will also be practiced using MySQL or a similar tool. Relational databases will be examined, with an emphasis on those found in PC networks with client-server applications. Topics include: the rationale for using databases, the history of databases, logical definition and structure for efficient access, physical definition of the data, using SQL and QBE (query by example) to access databases, data security and backup strategies.