Developers, Business Analysts, System Analysts, Managers and Data Base Administrators.
This course introduces students to the principles and process of gathering and translating business data requirements into a graphical logical data model. Participants will see the practical application of the basic data modeling techniques commonly utilized by Business Analysts. With a combination of lecture, examples and lab exercises, attendees are guided through the concepts, use and creation of the Context Diagram, Data Flow Diagram and Entity Relationship Diagram.
Upon successful completion of this course, the student will be able to:
- Recognize why data modeling is used and the benefits of this practice
- Discuss data modeling approach
- Interpret and create Context Diagrams, Data Flow Diagrams, and Entity Relationship Diagrams
- Define the three types of data models: Conceptual, Logical and Physical
- Create a complex data model and validate against a key set of business requirements
- Distinguish and describe Entities, Relationships, and Attributes
- Describe the Normalization process
- Understand the use of primary keys and foreign keys
None, though business knowledge and some knowledge of programming principles is recommended.