| Lesson 4 | Relational Database Course Project |
| Objective | Elements of relational database course project |
For the remainder of the course, I want you to imagine that you have been hired by a company called Stories on CD, Inc. to consult on the design
of a relational database that will enable the company to
To fulfill your obligation to the company, you need to accomplish a number of steps involving
- store and
- retrieve
To fulfill your obligation to the company, you need to accomplish a number of steps involving
- analyzing their business structure,
- their needs,
- and the best way to organize and store the data to ensure its most efficient retrieval.
This course includes a number of hands-on exercises that enable you to complete these steps incrementally, applying what you learn in the lessons
to a real-world situation.
These exercises culminate in the completion of an
entity-relationship (ER) diagram,
completing the conceptual phase of database design.
The image below to shows the diagram that will be created.
These exercises culminate in the completion of an
entity-relationship (ER) diagram,
completing the conceptual phase of database design.
This concludes the first module of the course.
In the next module I will teach you about the relational database model and how to describe the structure of a relational database.
This material may be a review for many of you and is important to establish common terminology.
RelationalDB Course Project
In the next module I will teach you about the relational database model and how to describe the structure of a relational database.
This material may be a review for many of you and is important to establish common terminology.
Before moving on to the next module, click the
RelationalDB Course Project link below to download the case study on which the course project is based.
RelationalDB Course Project
RelationalDB Course Project link below to download the case study on which the course project is based.
RelationalDB Course Project