Profile

e-Catalog

Contact

Search

Cart

Database Fundamentals

Audience

Database users and IS staff requiring a basic appreciation of the concepts of database management systems; managerial staff needing information that will help in the decision to purchase a relational DBMS

Prerequisites

A basic understanding of computers would be an advantage

Course Aim

To introduce students to the database approach and enable them to make an informed decision about purchasing a database management system

Learning Objectives

Evaluate the advantages of a the computer database's file-based system of information storage. Outline the four components of a DBMS, describe its three-level architecture, list its functions, and explain its relationship to the operating system and application programs. Distinguish three major information systems supported by a DBMS and list the services offered by a database. Describe the duties and functions of a DBA and of IS staff and end-users in relation to a DBMS.

Topics Covered

Data sharing - Computerized v. manual filing systems - Data inconsistency - Moving towards data sharing The database approach - Files-based systems - Database system components - Database functionality - Migration to a database - Functions of a database - Programming tasks - Centralized control Workings of a DBMS - Basics of DBMS - Data access - Data independence - Data control and protection - Data redundancy - Data models and architecture - Database models DBMS environment - Three major systems - Corporate v. local databases - Data processing Role of the DBA - Functions of the DBA - Duties of the DBA - Other DBMS users