UMBC CMSC 461 Spring '99 CSEE | 461 | 461 S'99 | lectures | news | Oracle Help | help

Design of a E-R Database Schema


Some of the schema decisions that must be made by the database designer include:

Design phases

Different authors will have different names for the different phases, however all of them are essentially describing the Software Development Life Cycle:
  1. Requirements specification

  2. There can be a series of specifications that can use defined:
  3. Analysis

  4. The result of analysis should be the input and output of the systems, as well as the E-R Diagram with the entity and relationship sets.
  5. Design

  6. The results of design should be the definition of all the database components and the logical description of the processing that the system will provide.
  7. Implementation

  8. Here is where the tables are actually created, and the databases are populated with data. The software is developed. This will be the shortest phase if all of the other phases are correctly executed.
  9. Test

  10. Testing is necessary to provide the development team built the correct system and built the system correctly.
  11. Documentation

  12. Actually, the documentation should been included in other phases and finalized during this phase.
  13. Modification and Enhancement

  14. This is the most expensive time to correct bugs!
    This is also the phase where the system evolves to meet new and unforeseen requirements.

CSEE | 461 | 461 S'99 | lectures | news | help

Wednesday, 10-Feb-1999 16:09:26 EST