Description:

This workshop is conducted 'in-house'. That is, it is run in response to a request from a client, and only that client's staff attend. The charge for the workshop is a flat consulting charge, with no restriction on the number of staff who may participate. The charge is calculated by multiplying the current consulting rate by the number of hours, where this is assumed to be 16 hours for the two days, plus the hours needed to study the problem models beforehand.

Some time before the workshop, delegates submit descriptions of the problems they have encountered in practice.  The problems can be disguised if they involve confidential information (although note that only the staff of the single client are present). 

During the workshop, delegates describe these problems to the group (or, if preferred, the lecturer will present the problem on behalf of the delegate).  The group then discusses the problem.  Alternative ways of handling it are compared, and some consensus is reached. 

The lecturer will have had advance warning of each problem, and so can ensure that each session provides useful guidelines to address the problem. 
  

 

Objectives:

The objective is to provide solutions to the difficult modelling situations encountered during the practice of data modelling. 

Delegates who attend have the opportunity to compare their experiences with those of the other staff members..  Did they have the same problems?  How did they solve them?  If they didn't have the same problems, why not?    The lecturer will also contribute his experience towards solving the problems. 

Some typical areas requiring judgment are: 

    • To what extent should concepts be lumped together, or to what extent should they be split apart?  (lumpers `vs' splitters)
    • When denormalization is required for performance reasons, what extra business rules need to be enforced?
    • When denormalization is required, how is the physical database generated, and must two data models be used (an ideal and a denormalized)?
    • How can objects be mapped into a relational database (many systems these days used object oriented programming with a relational database system)?
    • What is the effect of using `dataless' keys, and can it be done in every case?

 


Topics:

The topics will consist of the problems submitted by the delegates, together with a set of topics selected for each workshop.

Delegates may suggest particular topics for inclusion in the workshop they will be attending.

 

Audience:

The workshop is intended for people who have attended the Mike King Business Modelling Course and have had the opportunity to use the techniques in practice for at least a few months before attending the workshop.

People who have not attended the above course will also be welcome, provided they have practical experience of data modelling.

 

Prerequisites:

Attendance at the Mike King Course on Business Modelling with Entities and Objects, or practical experience of Data Modelling. 
 

 

Duration:

2 days

 


 

Workshop Schedule

Duration (Days)

Booking Status

Venue

Scheduled Start Date

2 days

Workshops are arranged to fit in with the need. Just notify us of your interest, and we can set the dates together.

South Africa

On Demand 

United Kingdom

Australia

United States

 

Enrol Delegates

E-mail MikeKing@MikeKingCourses.com 

E-mail button.

GETTING AN ENROLMENT FORM

The E-mail button will open 

your mail program. 

Please Email us to book for this workshop. 

 

Or you may fax us on: 

(011) 886 9039