CODEWITHSUNDEEP
databasedatabase-design
Zampanò
Zampanò

Reputation: 594

SQL Developer Data Modeler - Creating a Physical Model

The following is a sample logical model created using Oracle SQL Developer Data Modeler:

Logical Model

After engineering the model to a relational model, the resulting model is the following: enter image description here

Is the above model considered to be a Physical Model? I believe this is a physical model, but the fact that it's called a relational model is making me have doubts.

Upvotes: 1

Views: 1434

Answers (1)

Panickos Neophytou
Panickos Neophytou

Reputation: 525

From 1keydata:

Physical data model represents how the model will be built in the database. A physical database model shows all table structures, including column name, column data type, column constraints, primary key, foreign key, and relationships between tables.

What you have there represents what needs to be implemented in your database.

The relational model is "an approach to managing data using a structure and language consistent with first-order predicate logic" [Wikipedia]. In high level both diagrams follow the relational model.

Upvotes: 1

Related Questions