Describe the waterfall model. List the steps.

It is a strict sequence of steps where the output of one step is the input to the next. Each step has to be completed in order to move on to the next.

  • Establishing Requirements
  • Statement of requirements
  • Analysis
  • System Specification
  • Design
  • Design Document
  • Implementation
  • Initial System
  • Testing
  • Released System
  • Maintenance

What does the acronym SDLC mean, and what does an SDLC portray?

Software Development Life Cycle (SDLC)

It portrays: Planning, Implementation, Testing, Documentation, Deployment, Maintaining

What needs to be modified in the waterfall model to accommodate database design?

  • Establishing Requirements
  • Data Requirements
  • Data analysis
  • Conceptual Data Model
  • Database design
  • Logical Schema
  • Implementation
  • Initial Schema and database
  • Testing
  • Released schema and database
  • Maintenance

Provide the iterative steps involved in database design.

  • Use a relational representation of the conceptual data model to give a set of tables for a first-cut database design.
  • Do the tables represent the data in an acceptable way according to the given criteria for usability, efficiency, and so on?
  • If yes, define constituents of schema for each table such as:
    • columns
    • primary keys
    • foreign keys
    • constraints
  • Implementation
  • If no, flex tables to produce second cut design
  • Ask the question again until the answer is yes.