The course concentrates on the relational model and includes several query languages. Topics covered include normalization, database design, catalogs, transaction support, concurrency control, integrity support, backup and recovery, and security. Projects involve the use of both personal and enterprise database systems. The course concentrates on the relational model and includes several query languages. Topics covered include normalization, database design, catalogs, transaction support, concurrency control, integrity support, backup and recovery, and security.
Projects involve the use of both personal and enterprise database systems.
Introduction and Review Background, basic database concepts, examples. Network and hierarchical models. Creating tables, entering data, updates, queries, reports, forms. Relational Algebra Conventional set operations, select, project, join, divide. SQL Review of data definition, simple queries, functions, joins, nesting.