Conceptual and logical database modeling

Page 1

Seminar Enterprise & Information Technology Architecture

2-day In-person Seminar on

Conceptual and Logical Database Modeling Register Now

by Jerry Rosenbaum Price: $1,295.00 (for 1 attendee) Register now and save $200. (Early Bird)

Location : Los Angeles CA | March 11th & 12th, 2014 | 8:30 AM to 5:30 PM Location : Atlantic city, NJ | April 24th & 25th, 2014 | 8:30 AM to 5:30 PM

Overview:

Who Will Benefit:

This is a practical hands on course where the concepts of Conceptual and Locical Modeling are interwoven with practical group exercises and discussions. Throughout the course we discuss the interdependence of process analysis and data analysis (conceptual and logical design) and how they affect each other. The student is also shown how to approach the conversion of a logical database design to a physical database design.

l

l l

l l l

Agenda: Day 1

l

Lecture 1: What is Database Design l l l l l l

The Database Concept and Database Design Challenges in Database Design Data integrity Sharing of data Data Management Quality database design

l

l

Lecture 2: Basic Data Analysis - Building the Conceptual Model l

l l l l l

Professionals Database Design Professionals Information Resources Management Professionals Database Administrators Systems Analysts Software Engineers, Programmers Management responsible for enterprise data and related issues

Areas Covered in the Session:

l

l

Information/Data Modeling

Entities Relationships Attributes Cardinalities Ordering Exercise

l

l

Understanding the role of data modeling How to approach data modeling for a new or existing system How to ask the right questions and understand the answers How to organize and maintain metadata Building a logical data model that is robust and maintainable Reviewing a model with the business

About Speaker Jerry Rosenbaum

Day 2

Owner, The Rose Tree Group, Ltd

Lecture 1: Essential Relational Design

Dr. Rosenbaum has over 40 years experience in many of the significant areas

l

Creating Domains

of information technology. He has expertise

l

in Enterprise Architecture, Data

l

Developing Tables and primary keys Relationships and Foreign Keys Columns

l

Exercise

Business Rules, and Systems Migration,

l

Architecture, Data Administration, Data Quality, Data Modeling, Process Modeling, Refurbishment, and replacement. He has experience implementing and using the

Lecture 2: Normalization

Zachman Framework, Treasury Enterprise

l

Keys Reduncency Normal Forms

l

Exercise

l l

Click here to register for this Seminar

Architecture Framework (TEAF) and Dept of Defense Architecture Framework (DODAF, formerly C4ISR).

Suggest a Topic

EITA Global www.eitaglobal.com

161 Mission Falls Lane, Suite 216, Fremont, CA 94539, USA Phone: +1-800-447-9407 or Fax your PO to: 302-288-6884 If you do not wish to receive this training alerts from EITA Global Click Unsubscribe

More Seminar


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.