PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
CONTENT AND OBJECTIVES:
Examine data modeling tools.
Demonstrate the use of a data modeling tool, such as ERWin, MS Visio, Rational or PowerDesigner.
Diagram a simple model.
Data Entity Types
An integrated case study is used for exploring and analyzing data modeling.
Automobile rental system case study: Determine the data entity types; the initial documentation will be for logical design.
Utilizing the client-specific diagram tool, define the external and conceptual level of the database.
Data Mapping Conventions
Become familiar with diagram notation and conventions.
Document the business strategies and clarifying diagrams from the Data Entity Types case study.
Use the conventions and diagramming techniques presented in lecture.
Create the data model, relationships, and entities to complete the case study.
Improve and refine the model to include the recursive relationships, strong and weak entity types, cardinality constraints, and appropriate comments.
Review each model for completeness, conformity to standards, optimal design, clarity, and consistent definitions.
Determine whether denormalization is needed and the level of denormalization which is required.
Calculate the physical cost to retrieve the data and empirically determine whether denormalization is required.
Review the data model to determine if the appropriate level of denormalization has been used and whether there is an alternative to denormalization for completing proper design.
Data Attribute Types
Acquire facility in identifying keys, categorizing the key type, and determining alternative techniques.
Review the selection, type and size of the keys, and if required, perform a final normalization or denormalization.
Perform a review of physical design, including the level of the indexes, type of keys and how it affects the design.
Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.