RelationalDBDesign  Tweet
RedhatLinuxSysAdmin SEOMining




Database Design   «Prev  Next»
Lesson 1

Design strategy, tools, and the database life cycle

Regardless of the approach they take to database design, the overall strategy of database designers is the same:
  1. To accomplish certain time-tested objectives.
  2. Design strategy, tools, and the database life cycle
This module describes those objectives as well as two different approaches to database design, and illustrates database architecture.
In addition, this module describes the design and post-design stages of the database life cycle, and outlines the capabilities of CASE tools.
All computer software, including databases and their incorporated database models, have a fixed life cycle. That life cycle is the cycle of usefulness within acceptable limits of cost effectiveness. There comes a point where older legacy software is either too expensive to maintain or can be easily replaced. At that point, there is simply no reason to retain and not rewrite older software. Other than that, older legacy software and databases (depending on how old they are) can present enormous problems for management in finding people to maintain those older systems.


Learning objectives
After completing this module, you will be able to:
  1. Describe the overall strategy of database design
  2. Describe the subject approach to database design
  3. Describe the application approach to database design
  4. Define user view, logical schema, and physical schema
  5. Describe the design stages of the database life cycle
  6. Describe the post-design stages of the database life cycle
  7. Explain the use of CASE tools in database design
The next lesson outlines the objectives of database design strategy.