RelationalDBDesign
prev next prev next
  Course navigation
 
Lesson 4
Objective
Relational Database Course Project
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
  1. store and
  2. retrieve
information about its business transactions.

To fulfill your obligation to the company, you need to accomplish a number of steps involving
  1. analyzing their business structure,
  2. their needs,
  3. 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.
ER diagram for Stories, Inc.
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
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
  Course navigation