Data Analysis & Modeling Workshop
Duration: 2 Days
Data analysis, data modeling and normalization are key components of software development and are essential knowledge for software developers. This course introduces the participant to the concepts and best practice. All Computer Aided Software Engineering (CASE) tools are built around these ideas and Object Oriented (OO) development also relies heavily on data analysis concepts.
All software developers need to be able to model data and to produce file structures that reflect the needs of the business - for today and tomorrow. Whether you are using a procedural language or a 4GL; a native file access method or a data base manager; whether systems are written internally or by 3rd party developers, the use of data analysis will greatly assist your ability to support future information processing needs. This 2-day Data Analysis & Modeling workshop covers it all.
Topics Covered In This Course
Examples of data analysis; the application of data analysis during the project life cycle; the roles of analyst, designer and user during this activity.
BASIC PRINCIPLES & TERMINOLOGY
The business analysis approach; cross checking and consolidation; global, application and transaction models; entities, attributes, relationships and normalization.
Relationship notation; exercise in mapping; simple and complex relationships; naming relationships and reasons for doing so; drawing an application data model from the results of normalization.
DATA ANALYSIS & NORMALIZATION
Fact finding and the identification of candidate data; recording data in the data dictionary; data dictionary notation; normalization; examples of first, second, third, fourth and fifth normal form relations; normalization exercise.
GLOBAL DATA MODEL
Analysis of business rules and an exercise to draw a global data model; annotating the data model and checking with user management.
THE COMPOSITE DATA MODEL
Composite and compound keys; key-only relations, combining the models to form one composite data model.
FOURTH & FIFTH NORMAL FORMS
Circumstances which may lead to data anomalies within key fields. Overview of transaction path analysis.
What You Can Expect
Participants will have a good understanding of data modeling and will be able to develop data storage designs to suit their environment.
On completion of the Data Analysis & Modeling workshop, participants will be able to:
Who Should Take This Course
Systems developers - business analysts, systems analysts, analyst-programmers and designers involved in the analysis, specification and development of computer-based systems.
Techniques used on the Data Analysis & Modeling workshop include:
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]