Stages in Creating a Database
The process of creating a database can be broadly divided into two main stages:
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.
- 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.
Note: all of these terms are interchangeable between the stages.