Types of Data Modelling

TYPES OF DATA MODELLING

Flat Model: The flat Model (or Table) model consists of a single, two-dimensional array of data elements, where all members of a given column are assumed to be similar in values, and all member of row are assumed to be related to one another.

Flat Model

	Route No.	Miles	Activities
RECORD 1	1 – 95	12	Overlay
RECORD 2	1 -495	05	Parching
RECORD 3	SR – 301	33	Crack Seal

HIERARCHICAL MODEL

In a hierarchical database, data is organized into an upside-down tree-like structure, implying a single upward link in each record to describe the nesting, and a sort field to keep the records in a particular order in each same-level list. Hierarchical structures were widely used in the early mainframe database management systems.

Network Model: 

This model organizes data using two fundamental construct, called records and sets. Records contain fields, and sets define one-to-many relationships between records: one owner, many members.

EVALUATION

1. Differentiate between Hierarchical and Network Model.
   1. Explain Flat data model. 

Relational Model

The relational model or relational data base model is based on first-order predicate logic. Its core idea is to describe a database as a collection of predicates over a finite set of predicate variables, describing constraints on the possible values and combinations of values.

Object-Relational Model

The object relational model is similar to relational database model, but objects, classes and inheritance are directly supported in database schemas and in the query language. An object-relational database can be said to provide a middle ground between relational databases and object-oriented databases (OODBMS)

Star Schema

The star schema is the simplest style of data warehouse schema. The star schema consists of a few “fact table” (possibly only one, justifying the name) referencing any number of dimension tables”. The star schema is considered an important special case of the snowflake schema.

GENERAL EVALUATION

1. List and explain the types of data model.
2. With the aid of a chart, using the school setting as a case study, explain Network model.

READING ASSIGNMENT

Data Processing for Senior Secondary Education by HiiT Plc. Chapter One, pages 56

WEEKEND ASSIGNMENT

Instruction: Choose the correct option from the ones lettered A to D

1. One of the following is an example of a DBMS package.
2. Ms Word    (b) Ms Power-point       (c) Ms access   (d) Ms Outlook

2.   In the approach of data modeling ____ data modeling identifies the highest level relationship between different entities.

• Conceptual Data Modeling       
• Logical Data Modeling 
• Flat data Modeling
• Physical Data Modeling

1. ____ model organizes data using two fundamental construct called record and set.
2. Network    (b) Relational          (c) Object Oriented     (d) Star Schema
3. ____model consists of a single, two-dimensional array of data elements.
4. Network     (b) Relational   (c) Object Oriented     (d) Star Schema
5. ____database model  is organized into an upside-down tree-like structure
6. Network    (b) Relational    (c) Object Oriented     (d) Hierarchical

SECTION B

1. List and explain four types of database model
2. Define the following; Data, Field, record, File.