ITS-1120 - Introduction to Database* (3)

Prerequisite: ITS-1055
Students learn how to use a relational Database Management Systems (DBMS). Topics include building, modifying, implementing, management and administration of a relational DBMS using Microsoft Access. Students will learn how to create tables, queries, forms, reports, and relationships according to project requirements. This course uses lecture and a hands-on format.

List Course Outcomes (consistent for all sections)
CO1 - Describe the purpose and functions of a Database Management System (DBMS).

CO2 - Use Entity Relationship diagrams to produce models of data structures used to solve business problems.

CO3 - Optimize data structures using the rules of Normalization, and produce complex physical models in Third Normal Form.

CO4 - Use Relational Algebra concepts to manipulate database tables and extract information from the data within them.

CO5 - Describe how transaction management operates in a database environment to keep inconsistencies and errors from occurring.

CO6 - Implement relational algebra concepts using SQL queries and views.

CO7 - Create and maintain relational database tables using SQL.

CO8 - Identify and analyze an Information Systems (IS) problem and design a working database system to solve it.

Course Fee: $15

View Course Sections