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