Why should I be interested in learning about Relational Databases?
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 databases.
However, unless your database is properly designed, it will be characterized by data problems such as
However, unless your database is properly designed, it will be characterized by data problems such as
- missing data,
- incorrect data and
- mismatched data
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
- 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 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.
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 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 is the first of two courses in the Relational Database Design Fundamentals series.
