Purdue School of Engineering and Technology

Purdue School of Engineering and Technology

Advanced Database Design

CIT 44400 / 3 Cr.

This course addresses enterprise data management and logical database design concepts with an emphasis on needs determination and data modeling skills from an organizational perspective. Students will create data models and apply forward and reverse engineering techniques.


ERwin Data Modeler


Course Outcomes (What are these?)

  • Identify the major functions of data management. (CIT a)
  • Describe data modeling concepts, terminology, and best practices. (CIT a, m)
  • Design conceptual, logical, and physical data models for an enterprise. (CIT c)
  • Use a professional data modeling tool for forward and reverse engineering. (CIT i)
  • Understand the importance of needs determination and business requirements in the context of database design. (CIT m)
  • Evaluate different data modeling standards and industry approaches. (CIT k)
  • Contrast Entity-Relationship modeling with dimensional data modeling. (CIT i)
  • Understand the challenges of enterprise data models and data management. (CIT j)

CIT Student Outcomes (What are these?)

(a) An ability to apply knowledge of computing and mathematics appropriate to the program’s student outcomes and to the discipline.

(c) An ability to design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs.

(i) An ability to use current techniques, skills, and tools necessary for computing practice.

(j) An ability to use and apply current technical concepts and practices in the core information technologies.

(k) An ability to identify and analyze user needs and take them into account in the selection, creation, evaluation and administration of computer-based systems.

(m) An understanding of best practices and standards and their application.

  • Data Management Framework
  • Conceptual Data Modeling
  • Logical Database Design
  • Physical Database Design
  • Managing the Data Modeling Process
  • Enterprise Data Models and Data Management


What You Will Learn

Data Management Framework

• Define data modeling

• Determine user needs and gather requirements for Database Design

• Understand what is involved in enhanced Entity-Relationship Modeling

Conceptual Data Modeling

  • Create conceptual entity-relationship model
  • Use Information Engineering Notation
  • Define and document
    • Subtypes and Supertypes
    • Identity
    • relationships
    • cardinality and optionality

Logical Database Design

  • Create logical data model
  • Define and document
    • Subtypes and Supertypes
    • Attributes and Columns
    • Primary and foreign Keys
    • relationships
    • cardinality and optionality
    • Refine a database model into third normal form

Physical Database Design

  • Create physical database model
  • Define and document
    • Tables
    • Columns, datatypes, and sizes
    • Primary and foreign Keys
    • Write database creation script.