Skip to main content

Stages in Creating a Database

The process of creating a database can be broadly divided into two main stages:

  1. Data analysis involves using a formalised methodology to create a database design. Two widely used methods are Entity Relationship Modelling (ER) and Normalisation. During this Unit we will be examining the latter. It is important to note that a database design is independent of the final database system chosen. Therefore, the same design can be physically implemented in different types of databases.
  2. Physical implementation of that design in a database system. The database system used in this course is Oracle, a Relational Database Management System (RDBMS) from Oracle Corporation. However, there are many other RDBMSs used in industry, eg: MySQL (open source) DB2 (IBM) and SQLServer (Microsoft).

As you move from a database design to a physical implementation, different terminology is used. However, often the terms are interchangeable. The following diagram explains some of the terms used at the different stages.

Table showing database terms

Note: all of these terms are interchangeable between the stages.

Next: Entity