[go: up one dir, main page]
Scribd
Upload
2 views2 pages

Data Models DBMS Notes

A data model defines the structure, storage, and manipulation of data in a database. The main types of data models in DBMS include Hierarchical, Network, Relational, Entity-Relationship (ER), and Object-Oriented models, each with distinct characteristics and use cases. A comparison table highlights their structures, relationship support, and examples of use cases.

Uploaded by

Sakshi Damani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views2 pages

Data Models DBMS Notes

A data model defines the structure, storage, and manipulation of data in a database. The main types of data models in DBMS include Hierarchical, Network, Relational, Entity-Relationship (ER), and Object-Oriented models, each with distinct characteristics and use cases. A comparison table highlights their structures, relationship support, and examples of use cases.

Uploaded by

Sakshi Damani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Data Models in DBMS

1. What is a Data Model?

A data model defines how data is stored, connected, and manipulated in a database. It helps in organizing

data logically and structurally. Here are the main types of data models used in DBMS:

2. Types of Data Models

1. Hierarchical Data Model:

- Organizes data in a tree-like structure (1 parent, many children).

- Example: Department -> Employee -> Salary

- Used in: IBM IMS

2. Network Data Model:

- Organizes data in a graph (many-to-many relationships).

- Example: Project -> Employee A, Employee B

- Used in: CODASYL DBMS

3. Relational Data Model:

- Data is stored in tables (relations).

- Example: Table Student(ID, Name)

- Used in: MySQL, Oracle, PostgreSQL

4. Entity-Relationship (ER) Model:

- Uses entities, relationships, and attributes.

- Designed using ER Diagrams.

- Example: [Student] --enrolled_in--> [Course]

5. Object-Oriented Data Model:

- Stores data as objects (like in OOP).

- Example: Object Book { title, author, issueBook() }

- Used in: db4o, ObjectDB


Data Models in DBMS

3. Comparison Table

Comparison of Data Models:

| Model | Structure | Relationship Support | Use Case Example |

|----------------|----------------|----------------------|----------------------|

| Hierarchical | Tree | 1-to-many | Organization Chart |

| Network | Graph | Many-to-many | Project Assignments |

| Relational | Table | Many-to-many | Student-Course DB |

| ER Model | Diagrammatic | Any | University Database |

| Object-Oriented| Objects | Complex Objects | Multimedia Systems |

You might also like