Back to Course

JSS3: COMPUTER STUDIES - 1ST TERM

0% Complete
0/0 Steps
  1. Computer Career Oppurtunities | Week 1
    5Topics
    |
    1 Quiz
  2. Computer Viruses I | Week 2
    7Topics
    |
    1 Quiz
  3. Computer Viruses II | Week 3
    7Topics
    |
    1 Quiz
  4. Introduction To The Internet | Week 4
    4Topics
    |
    1 Quiz
  5. Internet Terminologies | Week 5
    4Topics
    |
    1 Quiz
  6. The Concept of Digital Divide | Week 6
    5Topics
    |
    1 Quiz
  7. Database Concept, Definition And Terminologies | Week 7
    4Topics
    |
    1 Quiz
  8. Database II | Week 8
    4Topics
    |
    1 Quiz
  9. Database III | Week 9
    13Topics
    |
    1 Quiz
Lesson Progress
0% Complete

There are three forms (models) of database;

1. Relational database.

2. Hierarchical database.

3. Network database.

Relational Database:

This is also called a flat-file. It uses a table to represent data and the relationship between the data. A table is made up of rows and columns, and each row represents a record (horizontal), while each column has a unique name. This is referred to as a field (vertical) – Tuples and Attributes.

Students’ database (Information about students’ records in a school)

UsernameNameAgeSexHouseclass
Kc 52116Osuoha Williams12MHARMJS 3A
Kc 31278Okon John11MH/JJS 3F
Kc 21185GwaikyaaShienguvan13MPANES’JS 3J
Kc 23345Mohammed Yusuf14MMCKJS 3C
Kc 42346Fasanmoye Israel14MHARMJS 3E

Staff database – for Employees’(Information about employees’ records in an Organization)

Staff NoNameSexDeptStateSubject
Kc 207Yinusa AhmedMLANGYobeArabic
Kc 3215Okoro UbahMSOCImoCivic Ed
Kc 709Tinubu MonsiratFMATHSOyoMaths
Kc 999Godspower JosephMBUSBayelsaComm

Customers database (Information about Customers’ records in a Bank)

Acct. NoNameSexAcct. TypeCredit Bal.Debit Bal
000211500Akpan EmmanuelMCurrent250,00012,000
000211750Olatunji RoselineFSavings182,0009,000
000211680Akintomide RebeccaFCurrent350,000NIL
000211552Ogbeh BonifaceMSavings500,00016,000

Hierarchical Database:

This is in the form of a tree structure where records (information) are represented in terms of a parent-child relationship called a one-to-many relationship.

Each element in the structure is called a node. The node at the top of the tree is not a member of any relationship. So it is called a root node e.g

Screen Shot 2021 03 17 at 3.40.59 PM

The structure above shows a Principal, Teachers, and Students of Kofa College. The Principal is the root node. The one-to-many relationship is that the principal has many teachers and a teacher has many students.

Network Database:

In this model, there are multiple interrelationships (many-to-many relationships of data). This makes provision for accessing a number of records from more than one record.

Screen Shot 2021 03 17 at 3.37.26 PM

For example, many students are offering many subjects. Also, many subjects are being offered by many students.

Screen Shot 2021 03 17 at 3.37.36 PM

back-to-top
error: