Skip to content

Data Model – SS2 Data Processing Lesson Note (First Term)

Lesson note at a glance

Class
SS2
Subject
Data Processing
Term
First Term
Reading time
4 min
Start of this note, 3 of 8
Take this term’s notes offline
Reading here is free. Download all 8 SS2 Data Processing First term notes as PDF to print and Word to edit.
Download all three terms, ₦2,000
Instant download. Secure payment by Paystack. Card, bank transfer, USSD or OPay. Payment stuck? WhatsApp us.

Data modelling is the process of structuring and organising data so that it can be implemented in a database management system (DBMS).

Advertisement
  • A data model describes structured data, such as the data held in relational databases.
  • It may also place constraints on the data stored in its structure.
  • It does not describe unstructured data such as emails or pictures.

Behavioural objectives

By the end of the lesson, students should be able to:

  1. define data modelling;
  2. state the difference between structured and unstructured data in relation to data models;
  3. explain the concepts of data modelling;
  4. describe data structure and data organisation as the two meanings of the term data model;
  5. name and describe the conceptual, logical and physical approaches to data modelling.

What is data modelling?

Data modelling is the process of structuring and organising data, and the data structures are then typically implemented in a DBMS.

  • Defining data: it states what data is needed and in what form it is kept.
  • Organising data: it arranges the data into a clear structure.
  • Constraints: it may also impose limits on the data placed within the structure.
  • Main use: managing large quantities of data is a primary function of information systems.

What is the difference between structured and unstructured data?

Structured data is data arranged in a fixed format, such as rows and columns, so that a DBMS can store and search it easily.

Unstructured data is data that has no fixed format, such as documents, messages, pictures, sound and video.

Point Structured data Unstructured data
Format Fixed and organised No fixed format
Described by a data model? Yes No
Where it is stored Data management systems such as relational databases Files such as documents, emails, pictures, audio and video
Example A school register with name, class and age columns A word-processing document, an email message or a photograph

Why was data modelling developed?

Data modelling was developed because early information systems focused on processing rather than on data.

Advertisement
  • Early focus: the main effort in the system development life cycle (SDLC) was to produce programs that automate a business process.
  • Key driver: processing, rather than data or information, drove information systems.
  • Growth: technology and system complexity increased over time.
  • Response: methodologies and modelling techniques were invented.
  • Quality: these techniques improved the quality of the deliverables.
  • Repeatable processes: they made sure that inexperienced programmers could follow repeatable SDLC processes.

What are the concepts of data modelling?

The concepts of data modelling are the main ideas that explain what a data model does for an information system.

  1. Blueprint: modelling techniques and tools capture complex system designs and turn them into easily understood representations of data flows and processes. This creates a blueprint for construction and re-engineering.
  2. Structure: a data model gives the data used in the information system a specific definition and format.
  3. Relationships: the model shows the data flow and the logical interrelationship among different data elements.
  4. Compatibility: data can be compatible across systems if the same data model is used consistently.

What are the basic building blocks of a data model?

The basic building blocks of a data model are entities, attributes and relationships.

  • Entity: a person, place, thing or event about which data is kept, such as a student or a teacher.
  • Attribute: a property that describes an entity, such as a student’s name, age or class.
  • Relationship: a link between entities, such as a student offering a subject.

What are the two meanings of the term data model?

The term data model refers to two different things: a description of data structure and a description of how data is organised using a DBMS.

What is data structure?

  • A data model describes the structure of the data within a given domain.
  • By implication, it also describes the underlying structure of that domain itself.
Advertisement

What is data organisation?

  • A data model also describes how to organise data using a database management system.

What are the approaches to data modelling?

There are three approaches to data modelling: conceptual, logical and physical.

Conceptual data modelling

  • It identifies the highest-level relationships between different entities.
  • It is the first step in organising the data requirements.

Logical data modelling

  • It illustrates the specific entities, attributes and relationships involved in a business function.
  • It serves as the basis for the creation of the physical data model.

Physical data modelling

  • It represents an application and database-specific implementation of a logical data model.
  • It describes the physical means used to store data.
Conceptual Logical Physical
The order of the three approaches to data modelling, from highest level to implementation.
Approach What it shows Purpose
Conceptual Highest-level relationships between entities First step in organising data requirements
Logical Specific entities, attributes and relationships Basis for the physical data model
Physical Application and database-specific implementation Describes the physical means used to store data

Evaluation

  1. Define data modelling.
  2. Give three examples of unstructured data that a data model does not describe.
  3. State two concepts of data modelling.
  4. Which approach to data modelling is the first step in organising data requirements?
  5. Explain how logical data modelling is related to physical data modelling.

Assignment

Explain the two meanings of the term data model, then describe the conceptual, logical and physical approaches to data modelling in your own words.

This term's Data Processing topics

SS2 First Term · 8 topics

  1. Database Management System I
  2. Database Management System II: How to Create Database
  3. Data Model
  4. Data Model II: Types of Data Modelling
  5. Data Modeling
  6. Data Modeling II: Standard Data Model & Examples
  7. Normalization
  8. Entity-Relationship Models
Advertisement

Lesson Notes for Other Classes

Print it or edit it in Word

Every note is free to read online. A PDF or Word copy of one subject costs ₦1,000 for one term, or ₦2,000 for all three terms.

Sign in first, then choose your class and subject at checkout.