Data Modelling

---

Data Models are be used to specify the information needs or information requirements of an organisation in a graphical format.  They provide valuable information needed by developers and testers in the production and testing of information systems.

This course will use meaningful and practical examples to explain and demonstrate the notation used and show you how to develop them them.  Having completed the course, you will be able to produce class models to represent the information requirements of an organisation.

Part One of the course provides an overview into what class models are, what they look like and why we use them. It answers the question of why we need to model information and data requirements in the first place, examines some common fact finding techniques and introduces the key components of a Class. In part one we will start to build an example Class Model.

In Part Two we will add Associations and Business Rules to our  Class Model and consider multiplicity, enforcing business rules and  “Many to Many” associations.

In Part Three of the course we look at the importance of keys, and develop the model further with Primary Keys, Foreign Keys and and also Derived Attributes.

 In part Four we will develop the model further by adding generalisation aggregation and composition. While we consider these structural elements of a class model it would be a good idea to consider how to capture historical data.

In Part Five we turn our attention to data definitions, which are used to provide more detailed information on the classes, business rules and attributes represented in the model.

In Part Six, we will use generative AI to produce some class models and review the results. We will also use AI to attempt some of the course exercises and compare its answers to yours.

In Part Seven, we will set you an assignment to complete a data model for a case study.  You will have a week to complete this in your own time (and you can use AI to help) and then we will get back together to discuss your results.

Please contact us to express your interest or request further information.