Question

Database notation is not consistent; there are hundreds of types of database models. Each model or notation is good at selective situations. Visio uses notation and graphical shapes that are not the same as those in your text. If you look at some of the links to schemas, you will see a similar sort of thing. Research the web for data models and data notation and similar phrases. Provide your answer to the following questions:

1.Name some of the notations/models you find In your own words,

2.discuss why do these differences in modeling exist

3.What, if any, solution you would recommend.

Answer 1

1.Name some of the notations/models you find In your own words,

Ans:

Conceptual Data Models
Physical Data Models
Record Based Logical Data Models

2.discuss why do these differences in modeling exist

The purpose of a data model is to represent data and to make the data understandable. Each data model differ from each other, and are used to define data based on requirement(abstractly, high level representation).Each model is good at selective situations.

Conceptual Data Model: Conceptual data models makes use of concepts such as attributes(property used to define object), entities(object), relationships(association between entities) in database.

So, In Conceptual Data Model we will interpret entities and their corresponding associations and properties.

Eg: Entity-Relationship Model

Record Based Logical Models:

Record Based Logical Models are used to represent data in detailed manner(high level implementation) i.e.,DB's logical structure is represented here.

Eg:

Hierarchical Model : data is defined as hierarchical tree structure
Network Model: data is defined as record types
Relational Model :data is defined as relations between them

Physical Data Models :

Physical data models are used to represent the physical structure(full db layout) of the data in database. here, entities acts as tables, properties act as column names and values, relationships act keys in DB.

Eg: Unifying Model

3. What, if any, solution you would recommend.

Effective data modeling solutions should help organizations and its users to map and understand their information architecture by helping to visualize and manage business data across multiple platforms.