BTM 415 - Data Base Design and Administration

3 units (fi 6)(EITHER, 3-0-2)

Application of database concepts in organizations. A comprehensive introduction to the design and development of relational databases from a logical data model. The relational database access language SQL is used along with a number of key-software development tools. Effective data administration techniques for enforcing integrity and security as well as enhancing performance are discussed. Topics of special current interest include data warehousing and the object-oriented data model. Prerequisite: BTM 311. Note: There will be a lab component for up to ten weeks during the term.