Scribd
Upload
174 views4 pages

Record Based Data Model DBMS

The document discusses the Record-based Data Model in DBMS, which organizes data in tables consisting of rows (records) and columns (fields). It outlines three types of Record-based Models: Hierarchical, Network, and Relational, each with distinct structures and relationships. Additionally, it highlights the features of Record-based Models, such as their structured format, efficiency for DBMS implementation, and support for powerful query languages like SQL.

Uploaded by

hiij7132
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
174 views4 pages

Record Based Data Model DBMS

The document discusses the Record-based Data Model in DBMS, which organizes data in tables consisting of rows (records) and columns (fields). It outlines three types of Record-based Models: Hierarchical, Network, and Relational, each with distinct structures and relationships. Additionally, it highlights the features of Record-based Models, such as their structured format, efficiency for DBMS implementation, and support for powerful query languages like SQL.

Uploaded by

hiij7132
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/ 4

Conceptual Data Model (DBMS)

Record-based Data Model (DBMS)

Record-based Data Model (DBMS)

Record-based data model ek low-level data model hai jo data ko **tables (records and fields)** ke form mein

store karta hai.

Is model mein:

- Data ko rows (records) aur columns (fields/attributes) ke form mein organize kiya jata hai.

- Har record ek entity ka data represent karta hai.

- Yeh model DBMS implementation ke liye zyada suitable hota hai.

Record-based models ko DBMS mein mainly 3 types mein divide kiya gaya hai:

1. Hierarchical Model

2. Network Model

3. Relational Model

Types of Record-based Models

1. Hierarchical Model

- Is model mein data ko **tree-like structure** mein store kiya jata hai.

- Ek parent record ke multiple child records ho sakte hain, lekin ek child ka sirf ek hi parent hota hai.

Example:

Department

Employee

Department Table:

| Dept_ID | Dept_Name |
Conceptual Data Model (DBMS)

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

| D1 | Sales |

| D2 | HR |

Employee Table:

| Emp_ID | Emp_Name | Dept_ID |

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

| 101 | Ram | D1 |

| 102 | Sita | D1 |

| 103 | Ravi | D2 |

2. Network Model

- Is model mein data ko graph-like structure mein store kiya jata hai.

- Ek record multiple parent aur multiple child se connected ho sakta hai (many-to-many relationship).

Example:

Student <-> Course

Student Table:

| Student_ID | Name |

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

|1 | Aman |

|2 | Rani |

Course Table:

| Course_ID | Course_Name |

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

| C1 | DBMS |

| C2 | OS |
Conceptual Data Model (DBMS)

Enroll Table (Relationship):

| Student_ID | Course_ID |

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

|1 | C1 |

|1 | C2 |

|2 | C1 |

3. Relational Model

- Yeh sabse popular aur widely used data model hai.

- Data ko **tables (relations)** mein organize kiya jata hai.

- Har row ek unique record aur har column ek attribute ko represent karta hai.

Example:

Customer Table:

| Cust_ID | Name | City |

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

| C01 | Ravi | Raipur |

| C02 | Neha | Bilaspur |

Order Table:

| Order_ID | Cust_ID | Product |

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

| O01 | C01 | Pen |

| O02 | C02 | Book |

Features of Record-based Models

Features of Record-Based Models:


Conceptual Data Model (DBMS)

1. Structured Format: Data rows and columns mein hota hai.

2. Easy for DBMS: DBMS implementation ke liye efficient.

3. Query Friendly: Relational model SQL jaisa powerful query language support karta hai.

4. Different Structures: Different needs ke liye hierarchical, network, aur relational options available hain.

You might also like