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.
Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
