Access can use a relational model of a database design.

Explain why nevigation is simple relational data model than in hirarchical model

Relational Database Model

1. Relational Model : Newer database model; Network Model - Older database model

2. The network model structures data as a tree of records with each record can have multiple parent and child records, forming a lattice structure.

The basic data structure of the relational model is the table, where information about a particular entity (say, an employee) is represented in columns and rows

3.The relational model has strong mathematical foundation with set theory and predicate logic. Network Model has no strong mathematical background.

4. Relational model is the most flexible of the database models. Network model is not very flexible.

5. Relational model has widespead use. Network model has limited use.

The Entity-Relationship Model is often referred to as a

semantic data model, because it more closely resembles real

world scenarios than, e.g., the relational model.

. In the ER model, we model the concept of "Instructors."

In the relational model we deal with names and phone

numbers.

. In the ER model, there is a distinction between entities

(objects) and relationships between such entities.

In the relational model, both concepts are represented by

relations.