After completing this course, you will be able to

• use a proven, step-by-step process to create a rigorous, unambiguous data model.
• describe the objectives of data Modelling and how it is positioned within the system development life cycle.
• differentiate between the conceptual, logical, and physical phases of data Modelling.
• construct an entity relationship diagram using entity types, relationships and attributes./li>
• use constructs of the relational model (tables columns, keys) to create a logical data model.
• apply a "bottom-up" approach to data Modelling, including normalization up to fourth normal form.
• plan, organize, and execute a data Modelling project.
• validate and confirm your data model using simple, effective techniques.

Get the skills you need to capture business data requirements in a formal data model. You will be guided through all the steps to create a conceptual, a logical and a physical data model. The course is not tool-specific; therefore, all the concepts and techniques you learn will allow you to perform data modelling by hand, or use the tools of your choice. We'll also introduce you to the practical benefits of conducting data modelling sessions in a JAD-like environment. With the help of extensive, progressive workshop exercises and a detailed case study, you gain real-world, hands-on experience building a data model from start to finish.

Who should attend?

If you will be responsible for performing business analysis and creating a data model to document the results, this course is for you. This course will also help prepare people who need to participate in data Modelling sessions, including end-users, SMEs and Information Systems personnel.

Any prerequisites?

Although no data processing experience is necessary, an understanding of business requirements would be very useful.