This course focuses on the design, implementation, testing and application integration of an IBM DB2 enterprise database system. Using local client tools students will integrate the business model with logical data and physical models using a Master Data Management (MDM) approach. Using SQL DDL and DML statements students will implement tables and other structures and test the database design using interactive SQL statements and SQL code embedded in a COBOL application. Stored procedures, DB2 administration and security will be introduced.

Prerequisite: INFS6130