Introduction to Database Design -- (Two Days)
Instructor: Paul N. Lee, [Owner/Consultant of Nahee Enterprises]
Database design is a critical part in a business environment, whether it is handling day-to-day processing, accounts/memberships, contact lists, or designing a dynamic WEB site. This seminar will give you the major information necessary to design such a database on your own. The processes you learn in this course can be applied to designing any relational database, using such systems as (MySql, Oracle, Sybase, Informix, Microsoft Access, Microsoft SQL Server, etc.). For the class project you will be able to design one database of your own choosing (or use the class standard). Several handouts will be supplied, along with a CD containing over 1,800 files of examples, templates, training, help files, many tools/utilities, and much more (a total of over 600-MB of information).
The following is the outline used for this class:
- The Basics.
- What is Data?
- What is a Database?
- What is a Database Management System?
- What is Data?
- Whom are those working with Databases?
- Data Analyst.
- Data Architect.
- Database Administrator.
- The Relational Model.
- Defining and using the Business Requirements to design the database model.
- Defining the Business entities.
- Defining the Business attributes.
- Relational Database Design.
- Tables, Uniqueness, and Keys.
- Foreign Keys and Domains.
- Determining Which Type of AutoNumber Column to Use.
- Indexed Tables.
- Joins (or Links and Relationships).
- Normalizing a Set of Tables.
- Before First Normal Form: Relations.
- First Normal Form.
- Second Normal Form.
- Third Normal Form.
- Higher Normal Forms.
- Integrity Rules.
- General Integrity Rules.
- Database-Specific Integrity Rules.
- A Practical Approach to Database Design.
- Normalizing a Database with Existing Data.
- Breaking the Rules.
- Denormalizing.
- When to Break the Rules.
- Class Project: Building the Database.
