Forms of Database Flat file Hierarchical Relational
TOPIC:
Forms of Database Flat file Hierarchical Relational
Class :
JSS 3 / BASIC 9
Term:
FIRST TERM
Week:
Week 9
Reference Materials:
- ONLINE MATERIALS
- SCHEME OF WORK
- TEXTBOOKS
Instructional Materials
- Pictures
- Wall charts
- Computer
Previous Knowledge:
The pupils have previous knowledge of
Database Definition and Common Database Terminologies
Behavioural Objectives: At the end of the lesson, the pupils should be able to
- define database
- explain common database terminologies
- Forms of Database Flat file Hierarchical Relational
CONTENT:
Forms of Database Flat file Hierarchical Relational
Flat File Database is a database designed around a single table, it puts all database information in one table or list with fields to represent all parameters.
The classic example of a flat file database is a basic name-and-address list, where the database consists of a small, fixed number of fields: Name, Address, and phone Number.
Another example is a simple HTML table, consisting of rows and columns. This type of database is routinely encountered, although often not expressly recognized as a database.
Relational Database is a database that group data using common attributes found in data set. It can also be described as a collection of relations that are frequently considered to be part of the database, as they help to organize and structure the data, in addition to forcing the database to conform to a set of requirements.
For example, a set containing all students coming resuming from Lagos in the school can be group be their classes, sex, surname etc. Such a group uses the relational model. THE software used to do the grouping is called a relational database management system.
The Structured Query Language forms the core of all relational databases. It provides a uniform interface to Oracle, SQL Server, Access and other relational databases.
Forms of Database
There are three Forms of Database, the Flat file, Hierarchical Relational, and the Network. Each form has its own purpose, function, and use.
The Flat file is the simplest form of database. It consists of a single table with fields to represent all parameters. The classic example of a flat file database is a name-and-address list. Another example is a simple HTML table, consisting of rows and columns. This type of database is routinely encountered, although often not expressly recognized as a database.
The Hierarchical Relational form of database is more complex. It groups data using common attributes found in the data. The most common example of this form is the family tree. In a family tree, each person is represented by a node, and the relationship between each person is represented by the links between nodes.
The Network form of database is the most complex. It consists of multiple tables with fields to represent all parameters. The most common example of this form is a social network. In a social network, each person is represented by a node, and the relationship between each person is represented by the links between nodes.
PRESENTATION
The topic is presented step by step
Step 1:
The class teacher revises the previous topics
Step 2.
He introduces the new topic
Step 3:
The class teacher allows the pupils to give their own examples and he corrects them when the needs arise
EVALUATION
Evaluation:
- There are ___________________ Forms of Database,
- Mention the three types of database form
- What is the use of the flat file?
- Mention two uses of the Hierarchical relationship.
- The __________ form is the most complex of the database form.
- _______ database form consists of multiple tables with fields to represent all parameters.
- The most common example of ________ database form is a social network.
- The Network form of database is the most ________
- The ___________ database form consists of multiple tables with fields to represent all parameters.
Conclusion:
The subject teacher gives out a short note and he or she goes round to mark. The teacher does the necessary corrections.