Database Design and Modeling in Oracle

The System Development Cycle in Oracle

The System Development Cycle can be placed into five distinct steps. However, note that with the advent of object modeling and design that software construction becomes a much more iterative process. This means that steps can be repeated and even mixed together in any order. Even though Oracle is effectively a relational database, many of the application development tools are generally object oriented in nature. The Internet is object oriented in nature.

1. Strategy and Analysis - user requirements and system specification.
2. Design - technical design documentation created from user requirements and specification.
3. Build and Document - conversion of design into executable software code and data structures.
4. Transition - user acceptance testing plus final modifications.
5. Production - pass support of the application to production support and release the application itself to the general user population.

Oracle Database Design Notation

Normalisation

• Precursor - unique identification making each entity uniquely identifiable by a combination of attributes and relationships.
• First Normal Form - remove repeated attributes or groups of attributes to their own entities.
• Second Normal Form - remove attributes dependant on only a part of the unique identifier.
• Third Normal Form - remove attributes dependant on attributes which are not a part of the unique identifier.