Honolulu University Course Outlines-Information Technology Curriculum

CS 200 Database Management Systems 5 credit hours
Online Distance Learning at Honolulu University

COURSE OBJECTIVES: Upon completion of this course, you will be able to:

1) Introduce the concept of database management systems through a business perspective.
2) Introduce modeling tools to support database environments.
3) Introduce concepts of database design, testing, and maintenance.
4) Introduce concepts of database administration and security.
5) Introduce concepts of distribution and fault-tolerance.
6) Introduce concepts of databases as tools to enhance corporate environments.
7) Introduce numerous database architectures and platforms.

COURSE CONTENT: The reading material for this course provides an introduction to databases. Topics include:

1) The history of databases
2) Information versus data
3) File processing versus database systems
4) Costs and risks
5) Systems architecture and planning
6) Life cycles and systems development
7) Modeling approaches
8) Database requirements
9) Schemas
10) Scope and business rules
11) Entities and relationships
12) Clustering
13) Conceptual and physical considerations
14) Relational, hierarchical, and network models
15) Performance and optimization
16) Management and administration concerns of databases
17) Security
18) Fault-tolerance
19) RAID
20) SQL (tables, joins, queries, updates, deletions, searching/sorting, etc)
21) Client/server systems
22) Internet and web databases
23) Data warehouses
24) Data marts
25) Distributed models
26) Object-oriented concepts

COURSE ACTIVITIES: In order to use our time wisely within the term, adherence to the following completion schedule of activities is suggested:

COURSE PREREQUISITE: A bachelor's degree is the minimum requirement for admission to this course of study.

COURSE DELIVERY: This course shall be delivered completely through online interaction via the Internet or other acceptable distance learning medium(s). Due to this being a non-traditional program, traditional classroom residency is not required. Therefore, you are expected to independently read and analyze the subject matter with me performing the roles of an advisor and mentor.