>>PRINT
Database Design and Development
DB DSGN & DEV
CLASS CODE: IS 320 CREDITS:  3
DIVISION: BUSINESS & COMMUNICATION
DEPARTMENT: INFORMATION SYSTEMS
GENERAL EDUCATION: This course does not fulfill a General Education requirement.

DESCRIPTION: Emphasis will be placed on logical and physical database design and implementation. SQL (Structured Query Language) will be introduced. Other major topics include: database design, data modeling, enterprise database processing, multi-user database processing, and object-oriented database processing.
TAUGHT: Winter, Summer, Fall
CONTENT AND TOPICS:

  • Data modeling

  • Design and implementation with relation tables

  • Normalization

  • UML class diagrams

  • Data definition and relational query languages (DDL and SQL)

  • Administrative

  • Management

  • Technical issues with respect to security/integrity and distributed databases

GOALS AND OBJECTIVES:

  1. Obtain a database overview: history, environment, and development.

  2. Learn fundamental semantic modeling concepts.

  3. Demonstrate the ability to build a well-designed database structure (schema).

  4. Understand how a database management system works.

  5. Analyze modeling concepts, including normalization, and study the process of converting semantic models to relational models.

  6. Introduce the data definition and relational query languages (DDL and SQL), object oriented databases, and integrated applications, and achieve basic proficiency in them.

  7. Address administrative, management, and technical issues with respect to security/integrity and distributed databases.


REQUIREMENTS: Create SQL scripts, design and create a database, written tests covering the various topics discussed in class and the textbook.
PREREQUISITES: IS 210
OTHER:
EFFECTIVE DATE: August 2002