Database Management

Catalog description

Various data models, including hierarchical, network, relational, and object oriented, are introduced. The major part of the course is devoted to relational databases. Topics covered are the mathematical foundation, the three-level ANSI-SPARC architecture, and the SQL language. The SQL language includes the data manipulation and data definition components that are used to construct and query databases and also to provide access control to safeguard security. Entity-relationship modeling is presented and used to design the external level. Functional dependency and normalization techniques are used for the logical design of databases. Problems of concurrency control in multi-user database management systems are discussed. Prerequisite Course(s): Corequisite: CSCI 260 Classroom Hours - Laboratory and/or Studio Hours – Course Credits: 3-0-3