Day 3. Getting Started with Database Design

Today's lesson is about the process whereby a business need can be modeled and therefore translated into the definition for a database system. What you'll learn today is central to the design of all relational databases.

In particular, you will learn:

• How to analyze business needs in terms of business processes, business rules, and business objects

• How to identify transactions and relationships

• How to define an outline database design and specify application requirements that fulfill the business needs

• How to normalize your data structure

After you have studied today's lesson, you should be able to take a business scenario and represent it in database form.