CIS 125DB - Database Management Systems

3 Credit(s)

Prerequisite(s): CIS 120 (formerly offered as CS120) or BA 131, and MTH 60 or MTH 63 or BT 160

Course Description: Designed for students in any discipline, this course includes a hands-on approach to develop competency in basic and advanced concepts and commands of database management. Students will learn to design, set up, and print a variety of forms and reports. Software to be used to develop materials is Microsoft Access.

Course Level: Career/Tech Preparatory

Course Learning Outcomes:

CLO#1: Demonstrate a working knowledge of database terminology.
CLO#2: Distinguish between uses of flat files and relational databases.
CLO#3: Use MS Access as a tool for database creation, management, and reports. (ILO: Critical Thinking)
CLO#4: Use MS Access to plan and implement a relational database design. (ILO: Critical Thinking)
CLO#5: Plan and design multiple fields and tables within a database.
CLO#6: Create, sort, index, move around in the file, and display data according to criteria.
CLO#7: Implement complex calculations in fields, queries and reports. (ILO: Critical Thinking)