CIS 2165 Database Management
Introduction to database management systems. Discussion of database environments, design, planning, implementation and administration in a relational model environment. Students will design and develop a simple database and implement a portion of this application including forms, queries and reports. Emphasis on database design techniques, normalization and the SQL database language.
Division: Business and Public Services
Department: Computer Science and Information Technology
Repeatable Credit: No
Offered Online: Yes
Prereqs: MAT 0200 OR MAT 1120
Outcomes
- Describe the functions of database recovery, security and administration, and basic data warehousing concepts.
- Utilize SQL and QBE commands to define, query and manipulate a relational database.
- Apply databases to actual situations and business problems. Complete the steps involved in database design and development. Construct and use a relational database.
- Define a database and describe the differences between traditional file management systems and database management systems (DBMS). Identify the concepts of the relational model, normalization, dependencies, integrity, and constraints.
Credit Hours: 3
Classroom Hours: 3