National University

Request Information

(800) 628-8648 Get Started

Campus Finder

Areas of Study

CSC422 Database Design

Lead Faculty: Dr. Ronald Uhlig

Course Description

A survey of principles, structure, analysis, and techniques of database design and implementation. Topics include physical and logical design, normalization, database models, security, and integrity.

Learning Outcomes

  • Describe characteristics of entity relationship components and explain how relationships between entities are defined.
  • Build ER Model.
  • Explain normalization and normal forms.
  • Create data models based on EER diagrams.
  • Use SQL commands and function for data manipulation and data administration.
  • Create views, triggers and stored procedures.
  • Describe database design strategies.
  • Describe various models used for concurrency control.
  • Explain how DBMS process SQL queries.
  • Describe distributed database management system and how transactions are managed in a distributed database environment.