CERTIFIED BUSINESS DATA MODELER (CBDM)
CONTENTS![Print as PDF](http://www.visiblesystemscorp.com/Services/Courses/images/print.gif)
Certified Business Data Modeler (CBDM)
Introduction
Individuals or groups can use this CBDM Course Series for personal, self-study training in Business Data Modeling. It comprises two courses and a case study workshop. The courses can all be delivered for self-study using PowerPoint, or via a Corporate Intranet. A brief summary of each course and the workshop is provided in the following pages.
Completion of each of these two courses is required to qualify as a Certified Business Data Modeler (CBDM). The Case Study Workshop applies the skills learned to a real-life problem. Your case study solution then becomes your exam solution, which we will subsequently assess for certification as a CBDM.
Back to Contents
Audience
These two courses and workshop are designed for personal self-study education by business managers and their staff, as well as IT managers and their staff. Each course includes many business examples, Course Exercises and Sample Solutions that are understood by all. The workshop is based on a real-life problem; each student can select a business area of the case study organization for detailed solution, based on the student's own experience and interests.
The target audience includes business and IT staff who must define data and information requirements for data bases to be developed for applications, for use across the Internet, or via Corporate Intranets. When trained by these self-study courses, business and IT staff can work together in a highly-effective design partnership: business staff know the business, while IT staff know computers.
Back to Contents
DATA MODELING CONCEPTS COURSE
This course teaches business managers and their staff ("business experts") as well as analysts, data administrators and data base administrators ("IT experts") how to work together in a design partnership to develop a data model for their organization. This data model provides a blueprint of the data needed to support business processes, and the information needed by management for decision-making. A data model is a prerequisite for:
- Development of integrated data bases to be used for Applications and for redevelopment of Legacy Systems
- Development of a Corporate Repository for Data and Information Warehouses
- Identification of re-engineered business process opportunities
Objectives
On completion of the course, both business experts and IT experts will understand:
-
How data modeling and data mapping are used to represent expert business knowledge.
-
How data entities, attributes and associations are used to represent business meaning in a design partnership with business and IT staff.
-
How data modeling can be used to represent management information needs and the underlying data in data models that enable rapid business change.
-
How data modeling can identify business requirements for Internet / Intranet Applications and Data Warehousing projects.
-
How data modeling can be used for Forward Engineering, Reverse Engineering and Business Reengineering projects.
Back to Contents
Course Outline
-
Data Modeling Concepts: Introduces and defines the components of a data model - data entities, attributes and associations, and their representation in data maps and entity lists.
-
Data Entity Types: Defines and illustrates use of each data entity type - principal (supertype) entities, secondary (subtype) entities, type entities, role entities, intersecting entities that are used to represent business activities, processes and systems, and structure entities used to capture expert knowledge for development of dynamically-updated expert data bases.
-
Data Mapping Conventions: Introduces conventions used to document data maps, and represent business strategies for strategic analysis of business alternatives.
-
Strategies and Associations: Shows how data maps can be used for rapid feedback to management for refinement of strategic alternatives.
-
Data Attribute Types: Defines and illustrates the use of primary and foreign keys, compound keys and candidate keys. Defines and illustrates non-key attributes including secondary keys (ie. selection attributes), derived attributes, elemental attributes, group attributes and repeating groups.
-
Course Exercises: Twelve course exercises of increasing difficulty are included for student completion throughout the course, together with sample solutions.
Back to Contents
Duration
- The course material, when presented as PDF of PowerPoint visuals and Instructor Notes, will take approximately 4 - 6 hours to complete. With completion of the twelve included course exercises, a total of 8 - 10 hours will be required depending on each student's progress.
Prerequisites
- This course has no prerequisites.
Back to Contents
BUSINESS NORMALIZATION CONCEPTS COURSE
This course teaches business managers and their staff ("business experts") as well as analysts, data administrators and data base administrators ("IT experts") the steps and rules of Business Normalization for data modeling. A data model is a blueprint of the data needed to support business processes, and information that is needed by management for decision-making. Data models are used for:
- Development of integrated data bases to be used for Applications and for redevelopment of Legacy Systems
- Development of a Corporate Repository for Data and Information Warehouses
- Identification of re-engineered business process opportunities
Objectives
On completion of the course, both business experts and IT experts will understand:
-
How to develop a normalized entity list from any unnormalized data source.
-
How business normalization can be used to identify current business needs.
-
How business normalization eliminates redundant data versions, to implement integrated data bases that can be used more effectively.
-
How business normalization can be used to identify future business needs and cross-check the accuracy of business meaning to design for the future.
-
How expert knowledge can be captured in fifth business normal form (5BNF) Structure entities to manage knowledge as a valuable business asset.
-
How business normalization and data mapping both support each other, and how they can be used iteratively in data modeling to uncover business meaning.
Back to Contents
Course Outline
-
Introduction to Business Normalization: Provides business examples that illustrate the benefits and advantages of business normalization.
-
Reasons for Business Normalization: Uses typical business problems that show how business normalization is used to structure data so that data redundancy is eliminated, and data maintenance problems that arise from redundant data are also eliminated.
-
First, Second and Third Business Normal Form: Contrasts business normalization with traditional normalization. Covers the rules of First Business Normal Form (1BNF), Second Business Normal Form (2BNF) and Third Business Normal Form (3BNF). Shows how business normalization cross-checks are used to uncover business meaning, identify homonyms and synonyms, and identify potential future business needs.
-
Fourth and Fifth Business Normal Form: Shows the rule and use of Fourth Business Normal Form (4BNF) to identify supertypes and subtypes. Covers the identification and capture of business expertise in Fifth Business Normal Form (5BNF) Structure entities, as dynamically-updated knowledge defined by business experts.
-
Business Normalization Examples: Uses progressively completed course exercises, plus many business examples, to illustrate application of the five business normal form rules. Shows how these rules can help identify additional business needs that may have been missed earlier, so that systems and data bases that are later developed do address the business requirements.
-
Course Exercises: Twelve course exercises of increasing difficulty are included for completion throughout the course, with sample solutions.
Back to Contents
Duration
- The course material, when presented as PowerPoint visuals, will take approximately 4 - 6 hours to complete. With completion of the twelve included course exercises, a total of 8 - 10 hours will be required depending on each student's progress.
Prerequisites
- This course assumes that the student has previously completed the Data modeling Concepts course.
Back to Contents
DATA MODELING CASE STUDY WORKSHOP
The Data Modeling Case Study Workshop is designed so that students can apply their Data Modeling and Business Normalization skills to a real-life case study problem. They check their solution for correctness and quality using a supplied modeling tool, Visible Advantage. This is used to capture each student's solution to the case study problem, so that it can later be emailed to assess the student for qualification as a Certified Business Data Modeler (CBDM).
Objectives
This Case Study Workshop shows the student how to apply the learned skills to a real-life case study problem, so that :
-
Data modeling represents business meaning for real-life problems.
-
Business normalization identifies future business needs.
-
These concepts apply to real-life problems within an organization.
-
Modeling tools capture data models, to check for accuracy and quality.
-
Data bases are generated for any target RDBMS.
Back to Contents
Workshop Outline [8-10 hours]
-
Guided Tour: of the Visible Advantage modeling tool.
-
Workshop Introduction: provides an overview of the case study organization and its planning statements.
-
Initial Data Modeling: develops an initial data model from planning statements and enters it into Visible Advantage.
-
Tactical Data Modeling: focuses on one business area with problems for that area, and enters your solution.
-
Operational Data Modeling: uses documents from the area for business normalization to add to the data model, then enters your solution into Visible Advantage.
-
Quality Assurance: checks the correctness and quality of your solution. You then email your case study solution for CBDM assessment as a Certified Business Data Modeler.
Back to Contents
Prerequisites
- The Data Modeling Concepts Course and the Business Normalization Concepts Course are both prerequisites for the Data Modeling Case Study Workshop, which must be completed and submitted for assessment to qualify as a Certified Business Data Modeler.
Back to Contents
CBDM CERTIFICATION EXAM
To register for the CBDM Certification Exam, please complete and submit the online Registration Form as described next - or instead print and fax the Registration Form - with your email address. We will email to you a password and further details so that you can download and install the courses and workshop materials.
A student edition of the Visible Advantage modeling tool is supplied to each student. This is a limited capacity, but full-function modeling tool that you will use for the case study workshop. The solution that you develop for the workshop and enter into Visible Advantage comprises your CBDM Certification Exam solution. The workshop manual has laboratory exercises and instructions for entering your case study solution into Visible Advantage so that you can check the validity of your exam solution before its submission.
The Visible Advantage encyclopedia must be returned to us by email, for CBDM Exam Assessment. If required, we will set additional remedial study and exercises until each student demonstrates a full understanding of the relevant Data Modeling and Business Normalization concepts.
Following completion of the workshop, the student edition of Visible Advantage can be retained by each student and can later be used for small projects, if required.
The encyclopedia from each small project can also be automatically merged into larger project encyclopedias - if your organization also uses the enterprise edition of Visible Advantage. This enables students to apply data modeling, business normalization and modeling tool analysis skills they have learned to specific areas of your enterprise where they have particular expertise.
Back to Contents
Individual or Small Group Training
This delivery option is used to train individuals or small groups. Each course is supplied electronically in PDF files of Microsoft PowerPoint Instructor Notes with Course Exercises and Sample Solutions. A Student Notes Reference Manual in Microsoft Word is keyed to each slide in the course material. To qualify as a Certified Business Data Modeler (CBDM), each student must complete the:
- Data Modeling Concepts Course
- Business Normalization Concepts Course
- Data Modeling Case Study Workshop
The workshop includes a real-life case study that requires each student to demonstrate full understanding of the self-study Concepts Courses. A Student Edition of the Visible Advantage modeling tool is supplied for use with the Data Modeling Case Study Workshop, as discussed later. Your case study solution becomes the certification exam solution.
Back to Contents
Large Group Training via Corporate Intranet
This delivery option applies for training large groups of 20 or more students. For large corporations each course can be presented across a Corporate Intranet using any Web browser. Students can take courses and the workshop at any time of their choosing, with slides available for online reading using a browser rather than PowerPoint. Student Notes can be printed for online and offline reference. This is a very economical option to train hundreds of staff, for a single Corporate Intranet License Fee.
A case study can also be supplied that is tailored uniquely to your organization's own enterprise environment. This is used to train your own instructors and help desk staff, so they are qualified to certify your subsequent business and IT students. The tailored case study problem is also used for inhouse Training for Internal Certification of instructors and help desk staff and is presented on-site by the author of the Data Modeling Course Series, Clive Finkelstein.
Back to Contents
Training for Internal Certification
Instructor Training in each course is on a Teach the Teacher basis, to train your Instructors and Help Desk staff so they can provide inhouse Classroom Training for your own staff, or Help Desk support for Intranet delivery to self-study staff students.
A Case Study, tailored to your organization for Internal Certification, can be provided. A quote to tailor each course, develop a Certification case study, and on-site instructor training by Clive Finkelstein can be requested when you register for the Intranet Version of the course.
Back to Contents
REGISTRATION INSTRUCTIONS
Visit the Online Store for:
On placing an order, an email message will be sent to you with instructions that detail how to download the password-protected courses and workshop file, together with a password to extract the courses and workshop from that file. Using the supplied password, you can expand and install these courses and the workshop for the specified number of students that you register from the Online Store. You will receive instructions to download the Visible Advantage Student Edition. Further information can also be obtained by contacting:
Internet Education Sales
Information Engineering Services Pty Ltd
PO Box 246, Hillarys WA 6923 AUSTRALIA
Phone: +61-8-9402-8300
Fax: +61-8-9402-8322
Email: cfink@ies.aust.com
Back to Contents
INSTRUCTOR
Clive Finkelstein
Clive Finkelstein is acknowledged worldwide as the "Father" of Information Engineering, and is Managing Director of Information Engineering Services Pty Ltd in Australia. He has over 43 years' experience in the Computer Industry. He has published many books and papers, and contributed Chapters and Forewords to books published by McGraw-Hill and Springer-Verlag. Clive has authored the following books:
-
“Information Engineering”, James Martin and Clive Finkelstein, Savant Institute, Carnforth: Lancs UK (1981). This was the book that started the Information Engineering Revolution in the 1980's.
-
"An Introduction to Information Engineering", Clive Finkelstein, Addison-Wesley, Sydney: Australia (1989). This book covers the history and evolution of Information Engineering.
-
"Information Engineering: Strategic Systems Development", Clive Finkelstein, Addison-Wesley, Sydney: Australia (1992). This is the “how-to” book on using Information Engineering.
-
"Building Corporate Portals with XML", Clive Finkelstein and Peter Aiken, McGraw-Hill New York: NY (2000). This book covers methodologies and technologies for Enterprise Portals.
-
“Enterprise Architecture for Integration: Methods and Technologies”, Clive Finkelstein, to be published in 2005. This brings together the methods and technologies for rapid delivery of Enterprise Architecture in 3-month increments. This activity is based on material from that book.
Clive Finkelstein is an internationally renowned consultant and instructor, and has completed projects for Defense, Government and Commercial organizations throughout the world and in most industries. Many projects have involved the Zachman Framework for Enterprise Architecture, using the latest methods and technologies for rapid delivery of priority areas into implementation. These methods use Enterprise Engineering for rapid definition of Enterprise Architecture. His technology focus addresses Enterprise Integration technologies using XML, Enterprise Application Integration (EAI), Enterprise Portals, Web Services and Service-Oriented Architecture (SOA) for Business Process Management (BPM) using XML-based BPM languages.
He provides training and consulting in all aspects of the Zachman Framework for Enterprise Architecture, with rapid delivery of priority areas using Enterprise Engineering. His application of these methods in large and medium Government, Defense and Commercial enterprises results in Business Transformation Enablement, so that business and IT managers and their staffs can plan for and achieve rapid business change. Enterprise Architecture provides a Governance Analysis Framework that supports Sarbanes-Oxley and other Governance Audit requirements. It provides direct support and linkage to Balanced Scorecard for Strategy-Focused Organizations, to ensure that IT systems and databases support defined Scorecard Measures, Strategy Maps and Governance requirements.
Clive writes a monthly column, “The Enterprise” for DM Review magazine. Past issues are at http://www.dmreview.com/. He publishes a free, quarterly technology newsletter via email: “The Enterprise Newsletter (TEN)”. Past issues of TEN are at: http://www.ies.aust.com/. His books and papers are at http://www.ies.aust.com/cbfindex.htm. He can be contacted at cfink@ies.aust.com. Many in-house skills-transfer courses and seminars presented by Clive Finkelstein are at http://svc004.bne009i.server-web.com/catalogue/visible/default.shtml.
|
Contact Details
Clive Finkelstein, Managing Director
Information Engineering Services Pty Ltd
PO Box 246, Hillarys WA 6923 Australia
|
|
|