Database Design

Location: Online Webinar (Zoom, WebEx, Google Meet, MS Teams)

Objectives:

This seminar provides guidelines for planning a desktop database. You will learn how to decide what information you need, how to divide that information into the appropriate tables and columns, and how those tables relate to each other.

A properly designed database provides you with access to up-to-date, accurate information. Because a correct design is essential to achieving your goals in working with a database, investing the time required to learn the principles of good design makes sense.

Learning Objectives:

1. What is good database design
2. The Design Process
3. Determining the purpose of the database
4. Organizing the required Information
5. Dividing Information into Tables (Columns)
6. Primary Keys
7. Relationships
8. Normalization