CMPS 342 Database Systems
Course Description

Computer Science Department
California State University, Bakersfield
V.1, 5/6/2003

Catalog Description :

Basic issues in data modeling, database application software design and implementation. File organizations, relational model, relational database management systems, and query languages are addressed in detail. Two-tier architecture, three-tier architecture and development tools are covered.

Prerequisite:

CMPS 223

Units:

5

Coordinator:

Huaqing Wang
Goals/Objectives:
  • To provide the student with the history and motivations of information system, basic common features, architectures and functionalities of database management systems, and the differences between database systems and file-based systems.
  • To provide student with data modeling ability, to use UML and entity-relationship model to model the real-world and to conduct conceptual database design for business or enterprise.
  • To provide the student with knowledge on relational model, and its the query languaages, and to be able to convert a conceptual database into a logical database in relational model.
  • To provide the student with the ability to create database with commerical DBMS system, to enforce constraints and integrities, to improve performance with indexes and stored procedures, and to access database in various ways.
  • To provide student with ability to design and code GUI interface with client-server architecture.
  • To enhance the student's abilities of oral and written representations.

Current Text:

(1) Database Systems, 3rd edition, Thomas Connolly & Carolyn Begg, published by Addison Wesley
(2) Oracle 9i The Complete Reference, K. Loney & G. Koch, published by McGraw Hill

Topics:

  • Information models and systems (IM1): History and motivation for information systems; information storage and retrieval; information management applications; information capture and representation; analysis and indexing; search, retrieval, linking, navigation; integrity, scalability, efficiency, and effectiveness
  • Database systems(IM2): History and motivation for database systems; components of database systems; DBMS functions; database architecture and data independence
  • Data modeling (IM3): Data modeling; conceptual models; object-oriented model; relational data model
  • Relational databases (IM4 & IM6): Mapping conceptual schema to a relational schema; Entity and referential integrity; Relational algebra and relational calculusl; Functional dependency and Normal forms.
  • Database query languages (IM5): Overview of database languages; SQL; 4th-generation environments; database connectivities (JDBC, ODBC) ; stored procedures
  • Graphics user-interface design & programming (HC5 & HC6): client-server and three-tire architectures design and implementation
Topics not included in ACM curricula

ACM Sub Areas or Units Covered::

ACM Sub Areas or Units covered in this course:
IM1 Information models and systems 0.5
IM2 Database systems 0.5
IM3 Data modeling 0.5
IM4 IM6 Relational databases and design 1.5
IM5 Database query languages 1.0
HC5 HC6 Graphics user-inerface design & programing 1.0

IM: Information Management
HC: Human-Computer Interaction

Laboratory:

Students will spend two and half hours each week on the following subjects:
(1) Present to the class their findings about the enterprise, and the parts of enterprise he/she will design information system for.
(2) Present the conceptual database design to the class, and the others make suggestion, discuss the alternatives for the design.
(3) Express queries in relational algebra and relational calculus.
(4) Convert conceptual database to relational database
(5) Study and practice commercial database management system.
(6) Present logical database design.
(7) Present front-end design and implementation, and discussion on each student design and implementation.

Oral and Written Communication:

Three to four times oral presentations are given by each student. A document with investigation, designs and coding is completed by each student at the end of class.

Social and Ethical Issues:

 

Problem Analysis:

Students investigate analyze an enterprise, model the enterprise in parts of a quarter-long project.

Solution Design:

Conceptual, Logical, physical database design and GUI user-interface design will be conducted in a quarter-long project.

Version & Date

Version 1, 5/6/2003

Comments

The first draft based on ACM curricula 2001 in the format of ABET sample course description.