Database concepts

Database design: modelling the system

Conceptual and Logical Models and Physical Implementation

Step 1 Conceptual. A model of the system that is represented for our purposes as an entity-relationship (E-R) model. This is independent of what type of database system (relational, traditional file or object oriented) is going to be used to implement the system.

Step 2 Logical. A model that is dependant on the type of database system (in our case, relational) that is to be implemented.

Step 3 Physical. The relational database management system (RDBMS) that the implementation is for. In our case Oracle (but could be Access, SQL Server or FileMaker Pro).

Which steps have you completed so far in this course?

Show me

You have already completed the physical implementation in module one (Step 3).