Sun Microsystems, Inc.
spacer spacer
spacer   Sun Educational Services  
spacer
black dot
  black fade
spacer
  Course Catalog
logo

Data Modeling

( WT-1030-180 )


     Course DescriptionBack To Top

Course Offered in Partnership With DigitalThink

This course, the first in a two-part series, introduces students to a design methodology they can use to create relational databases capable of storing and returning useful information in a consistent manner. Specifically, students will learn the principles of data modeling, culminating in the creation of an entity relationship diagram. Topics covered include requirements analysis, the entity-relationship modeling approach, and entities and attributes.

This course requires a word processing application. It also requires a computer running Windows, Macintosh, or UNIX.

eMentoring Services are included with this course.

  • Course length: 8 hours

    • Course details
        id:      WT-1030-180
        subscription duration:  180 days
        list price:  $  325.00


     
         Languages Offered Back To Top

    This course is currently available in English only.

     
         Prerequisites Back To Top

    To succeed fully in this course, students should be able to:

  • None

    •  
         Skills Gained Back To Top

    Upon completion of this course, you should be able to:

  • Explain relational database design concepts and terminology
  • Explain the difference between conceptual and physical models
  • Develop a conceptual design
  • Analyze user information requirements
  • Describe the entity/relationship modeling approach
  • Identify entities
  • Model relationships and identify attributes
  • Use primary and foreign keys

    •  
         Related Courses Back To Top

  • After: Data Analysis

    •  
         Course Content Back To Top



    Module 1: Course introduction Back To Top

  • Course introduction
  • Prerequisites
  • What you need
  • Course resources
  • Your learning community
  • Meet your instructor
  • Course project


    • Module 2: Relational database structure and terminology Back To Top

  • Relational database structure and terminology
  • The relational database model
  • Relational database structure
  • Linking relational database tables
  • Structured Query Language (SQL)
  • The relational database management system (RDBMS)
  • Module wrap-up


    • Module 3: Design strategy, tools, and the database life cycle Back To Top

  • Design strategy, tools, and the database life cycle
  • Database design strategy
  • The subject approach to database design
  • The application approach to database design
  • Schema architecture
  • Design stages in the database life cycle
  • Post-design stages in the database life cycle
  • Database design tools
  • Module wrap-up


    • Module 4: Requirements Analysis Back To Top

  • Requirements Analysis
  • Business objects, part 1
  • Business objects, part 2
  • Business rules
  • Users of data
  • The data flow diagram
  • User views
  • Calculated fields
  • Requirements Analysis documentation
  • Module wrap-up


    • Module 5: Entities and attributes Back To Top

  • Entities and attributes
  • Entity identifiers
  • Entity identifier rules
  • Instances of entities
  • Attribute domains
  • Multi-valued attributes
  • Resolve multi-valued attributes: Add more attributes
  • Resolve multi-valued attributes: Create a new entity
  • Constraints
  • Module wrap-up


    • Module 6: Entity relationships Back To Top

  • Entity relationships
  • Types of relationships
  • One-to-one relationships, part 1
  • One-to-one relationships, part 2
  • One-to-many relationships, part 1
  • One-to-many relationships, part 2
  • Many-to-many relationships, part 1
  • Many-to-many relationships, part 2
  • Problems with many-to-many relationships
  • Resolving many-to-many relationships
  • Mandatory and optional participation, part 1
  • Mandatory and optional participation, part 2
  • Module wrap-up


    • Module 7: Entity-relationship diagrams Back To Top

  • Entity-relationship diagrams
  • The entity-relationship (ER) diagram
  • Types of entity-relationship diagrams
  • Diagramming entities and attributes
  • Diagramming types of relationships
  • Diagramming types of participation
  • Users revisited
  • Verbalizing an ER diagram
  • Module wrap-up


    • Module 8: Course conclusion Back To Top

  • Course conclusion
  • Where do you go from here?
  • We'd love your feedback
  • Help us help you learn


    • Terms of Use.  Privacy Policy.  Feedback.  Copyright 1994-2002 Sun Microsystems, Inc.