Introduction to Relational Database Design
Every Corporation or Business involved in e-commerce requires a database.
This course describes a design methodology for creating a database capable of producing useful information in a consistent manner.
Current relational database
software has brought point-and-click ease to the task of creating dabases.
However, unless your database is properly designed,
it will be characterized by data problems such as
- missing data,
- incorrect data and
- mismatched data
that will make it almost useless, no matter how user-friendly the software is.
This course on Relational Database Design is the first step in learning a design methodology that will help you create a database capable of
producing useful information in a consistent manner.
Specifically, I will discuss the principles of data modeling, culminating in the creation of a database diagram.
After completing the first course in this series, you will be able to:
- Explain relational database design concepts and terminology
- Explain the difference between conceptual and physical models
- Develop a conceptual design
- Analyze user information requirements
- Describe the entity/relationship modeling approach
- Identify entities
- Model relationships and identify attributes
- Use primary and foreign keys
In this course, I will discuss relational database design
with the aid of two kinds of graphical displays,
- the SlideShow and
- the MouseOver.
You will complete a course project that involves creating a database design diagram
appropriate to the needs of Stories on CD, Inc.
This is a fictional company that sells books on CD via mail order. You will complete the project incrementally via a series of exercises that provide opportunities to apply what you have learned to a real-world situation.
While the company is small and its needs are relatively simple, the principles you apply to analyzing its requirements and designing a database to
meet them are the same as those that database designers apply to much larger projects involving multi-national corporations.
Data Modeling and Relational Database Design is the first of two courses in the Relational Database Design Fundamentals series.
The next lesson outlines the prerequisites for this course.