Course

Course Summary
Credit Type:
Course
ACE ID:
EDSI-1016
Organization's ID:
BAP DJ7
Location:
Classroom-based
Length:
21 hours (3 days)
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Upper-Division Baccalaureate 2 Credit Recommendation In Information Systems And/Or Information Technology
Description

Objective:

The objective of the course is to teach participants to effectively model business rules, policies, and procedures. Participants learn entity relationship diagramming, super and sub-types, attributive and associative entities, and documenting data constraints. The course approaches logical data modeling by focusing on the important requirements of the business that are discovered through significant user involvement during the analysis phase. Participants also learn how to create models without being limited by technology or organizational structure and are ready to communicate business and project requirements to project stakeholders using conceptual and logical data models.

Learning Outcomes:

  • Create logical data models to define business and project requirements
  • Explain the purpose, importance, and uses of logical data modeling in the requirements gathering process
  • Describe the elements of data flow diagrams and functional decomposition diagrams and their relationship to logical data models
  • Explain a logical data model to stakeholders
  • Apply logical data modeling to the overall software development life cycle and respond to business management issues

General Topics:

  • Background of modeling
  • Introduction to logical data modeling
  • The conceptual data model
  • The logical data model
  • Normalization and physical data model
  • Overview of the context level data flow
  • Transition to OO/UML
  • Case tools
  • Verifying and presenting models
Instruction & Assessment

Instructional Strategies:

  • Case Studies
  • Discussion
  • Lectures
  • Work-based Learning
Supplemental Materials