 |
|
 |
 |
|
|
|
|
 |
Entity Relationship Diagrams This Entity Relationship Diagrams course explains all aspects of entity relationship diagrams, from initial entity identification through to verification of the final entity relationship model. This will equip you with the skills needed for the analysis and design of any information (data) based system. Topics include: entity relationship diagrams, relationship identification, exclusive & recursive relationships, data attributes & keys, normalization and relational database design. This course includes a series of advanced exercises, covering all aspects of this complex technique. Get the training you need RIGHT NOW - only $14 from our online shop. |
| Entity Relationship Diagrams |
| This course represents approximately 5 hours of intensive training and is equivalent to a 2-day instructor led course. It is made up of self contained sections, each representing approximately 15 minutes of training, giving you the flexibility to either undertake intensive study or to fit your training into a busy work schedule. It clearly describes the underlying concepts which are then illustrated using a variety of real-world examples. It also includes exercises, case studies and questions to ensure that you understand and remember all of the key messages. |
| Features include: |
|
|
|
1) An
embedded active ‘Table of Contents’ for easy navigation. This Entity Relationship Diagrams course (approx. 1MB) is in Adobe Acrobat format, if you don't already have the Acrobat Reader click here to download it free. |
| Entity Relationship Diagrams Course Contents - the learning objectives of each Section are shown below. | |
| ____________________________________________________________________ | |
| Study Area 1 - Introduction | |
| Introduction - Data models are diagrams that clearly show how information and data is stored and used within an organization and how the various elements of data inter-relate. This course teaches candidates how to draw data models depicting the current, or planned, environment and how to optimise the way that data is stored and retrieved. This course teaches the whole process of data modeling, from information gathering to final verification of the diagrams produced. | |
| ____________________________________________________________________ | |
| Study Area 2 - Entities & Relationships | |
| Entities - This section introduces, explains and illustrates what constitutes an entity and discusses in detail; types, occurrences, data groups and items. | |
| Identifying Entities - Involves the candidate in identifying entities in a simple business scenario. | |
| Entity Identification Guidelines - Introduces a set of accepted, practical standards and guidelines for entity identification. | |
| Entity Keys - Explains the use of entity attributes as keys within the data model. Topics covered include: compound keys, primary keys, foreign keys and candidate keys. | |
| Entity Descriptions - In this section candidates learn the basic principles of completing a formal entity description. | |
| Relationships - The relationships section introduces the second critical component of a data model, the ‘relationship’ between entities. Topics include: occurrences, link phrase, cardinality and participation/optionality. | |
| Identifying Relationships -This section teaches the basic skills required to identify and model entity relationships. | |
| Relationship Statements - Explains how to identify the principal forms of notation used when defining relationship statements. | |
| ____________________________________________________________________ | |
| Study Area 3 - Modeling Complex Relationships | |
| Resolving M:M Relationships - The practical techniques used to resolve many-to-many relationships are explained in this section, as are the reasons that these relationships are not permitted on formal data models. | |
| Resolving 1:1 Relationships - One-to-one relationships are rare and are not permitted in formal data models. This section teaches users how to resolve apparent 1:1 relationships. | |
| Amending the Diagrams - Once candidates have resolved the apparent M:M and 1:1 relationships, they will need the skills taught in this section to amend the final data model. | |
| Multiple Relationships - Explains how to portray entities when they have multiple relationships. | |
| Exclusive Relationships - This section explains the special nature of exclusive relationship groups and how to depict them in the data model. | |
| Recursive Relationships - A recursive relationship is one in which an entity has a relationship with itself; this section explains how to identify and model recursive relationships. | |
| ____________________________________________________________________ | |
| Study Area 4 - Conducting the Analysis | |
| Entity Cross Referencing - There is a choice between a rigorous, formal referencing technique and one based on ‘what usually happens’. This section concentrates on the formal, rigorous approach | |
| Informal Relationship Identification - In this section candidates learn a less formal approach, which takes into account probable relationships, as the model evolves. | |
| Drawing the Preliminary Model - This section provides candidates with practice in drawing a simple preliminary data model. | |
| Refining the Preliminary Model - Interactive exercises aimed at enhancing and refining a simple preliminary data model. | |
| ____________________________________________________________________ | |
| Study Area 5 - Advanced Exercises | |
| Exercise 1 (1 hour) - This interactive exercise applies all of the concepts and techniques learned on the course to a straightforward business scenario. Full on-line case study support is provided. | |
| Exercise 2 (2 hours) - The second interactive exercise applies all of the concepts and techniques learned on the course to a more complex business scenario. It also introduces more advanced data modeling techniques, for example, ‘connection traps’. Full on-line case study support is provided. | |
| ____________________________________________________________________ | |
