Categories: Lesson Notes

JSS3 First Term Internet and Communication Technology (ICT) Lesson Note – Forms of Database

The content is just an excerpt from the complete note for JSS3 First Term Internet and Communication Technology (ICT) Lesson Note – Forms of Database. Check below to download the complete DOCUMENT

WEEK 9

Topic: – Forms of Database

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 recognised 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 organise 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.

Relational database is the most popular and it is preferred above flat file because flat file is not sufficient to handle the data processing needs. There are three primary relational database systems:

  1. Proprietary       →      2.       Open Source      →    3. Embedded

Sub-Topic 2

Hierarchical Database links records together like a family tree, data are arranged or structured in form of tree. The structure allows

To gain full access to the note: DOWNLOAD FILE

Sunday

Share
Published by
Sunday

Recent Posts

List of Universities Offering Veterinary Medicine in Nigeria

Veterinary medicine is the branch of medicine that deals with the prevention, diagnosis, and treatment…

4 months ago

List of Universities Offering Anthropology in Nigeria

Anthropology is the scientific study of human beings and their cultures. It encompasses a wide…

4 months ago

List of Universities Offering Sociology in Nigeria

Sociology is the scientific study of human society, culture, and behavior. It examines the social…

4 months ago

List of Universities Offering Social Work in Nigeria

Social Work is a profession dedicated to helping individuals, families, and communities to cope with…

4 months ago

List of Universities Offering Religious Studies in Nigeria

Religious studies is an academic discipline that explores the beliefs, practices, and history of various…

4 months ago

List of Universities Offering Public Administration in Nigeria

Public administration is the field of study and practice that focuses on the organization and…

4 months ago