Explain Network and Relational data models

Explain Network and Relational data models

 

📘 7. Explain Network and Relational Data Models

 

🌐 Network Data Model

📌 Definition:

The Network Data Model is a type of database model that allows many-to-many relationships between data entities. It organizes data using records and sets, where records represent objects and sets represent relationships.

  • Developed by CODASYL (Conference on Data Systems Languages) in the 1960s.
  • Visualized as a graph where:
    • Nodes = entities (records)
    • Edges = relationships (sets)

📎 Key Features:

  • Supports complex relationships through pointers.
  • More flexible than the hierarchical model (which only supports parent-child).
  • Records are connected using links (pointers) instead of foreign keys.

Example:

Think of a university system:

  • A Student can enroll in multiple Courses
  • Each Course can have multiple Students

The network model can represent this many-to-many relationship directly using sets.

🔍 Advantages:

  • Efficient for navigational access
  • Good for applications with complex relationships

⚠️ Disadvantages:

  • Complex to design and maintain
  • Requires knowledge of physical database structure

 

🧮 Relational Data Model

📌 Definition:

The Relational Model, introduced by E. F. Codd in 1970, is based on mathematical logic and set theory. It represents data using tables (called relations), where each row is a record (tuple) and each column is an attribute.



SAP Client Creation (SCC4) & Logical system (BD54) in SAP
  • Data is stored in structured tables
  • Tables can be linked using keys (Primary Key & Foreign Key)

📎 Key Features:

  • Each table has a unique primary key
  • Relationships are defined through foreign keys
  • Data retrieval is done using SQL (Structured Query Language)

Example:

StudentID

Name

101

Alice

102

Bob

 

CourseID

CourseName

C01

Math

C02

English

 

StudentID

 

CourseID

101

 

C01

101

 

C02

102

 

C02

This structure represents a many-to-many relationship using foreign keys.

🔍 Advantages:

  • Easy to use and understand
  • Data is independent of how it is stored
  • Supports powerful querying with SQL

⚠️ Disadvantages:

  • Can be slower for large datasets with complex relationships
  • Relational joins can be resource-intensive
    What is SAP Landscape?


🔁 Comparison Table: Network vs Relational Data Model

Aspect

Network Model

Relational Model

Structure

Graph with records and links (pointers)

Tables (relations)

Data Representation

Records and sets

Rows (tuples) and columns (attributes)

Relationship Type

Many-to-many via sets

Many-to-many using foreign keys

Flexibility

High, but complex

Easy to understand and manage

Query Language

Procedural navigation

Declarative (SQL)

Learning Curve

Steep

Moderate to easy

Performance

Fast for complex navigations

Slower for complex joins

 

 

  • The Network Model is useful when performance and relationship complexity matter more than ease of use.
  • The Relational Model is the most widely used today due to its simplicity, scalability, and SQL support.

Both models play a vital role in the evolution of database systems and understanding them helps in grasping the fundamentals of modern data management.



Visit for latest Job Vacancies and News indianinQ8.com

Visit for More Forever Living Products - Forever Living Kuwait at https://foreverlivingkuwait.blogspot.com/


7. Explain Network and Relational data models






Explain Network and Relational data models


The network model is a database model conceived as a flexible way of representing objects and their relationships. Its distinguishing feature is that the schema, viewed as a graph in which object types are nodes and relationship types are arcs, is not restricted to being a hierarchy or lattice.

The relational model for database management is a database model based on first-order predicate logic, first formulated and proposed in 1969. 

In the relational model of a database, all data is represented in terms of tuples, grouped into relations. A database organized in terms of the relational model is a relational database.


Kuwait bus routes and numbers, bus route kuwait CityBus, KPTC, KGL Mowsalat. find Kuwait’s public transport Muscat خط الحافلات الكويت.


In the relational model, related records are linked together with a "key". 

The purpose of the relational model is to provide a declarative method for specifying data and queries: users directly state what information the database contains and what information they want from it, and let the database management system software take care of describing data structures for storing the data and retrieval procedures for answering queries.