Topic Content:
- Forms of Database
- Relational, Hierarchical, Network
We previously defined a database as a collection of records (data) stored at a central location for use by many different users. Hence, it provides consistency in the control of data.
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:
Username | Name | Age | Sex | House | class |
Kc 52116 | Osuoha Williams | 12 | M | HARM | JS 3A |
Kc 31278 | Okon John | 11 | M | H/J | JS 3F |
Kc 21185 | GwaikyaaShienguvan | 13 | M | PANES’ | JS 3J |
Kc 23345 | Mohammed Yusuf | 14 | M | MCK | JS 3C |
Kc 42346 | Fasanmoye Israel | 14 | M | HARM | JS 3E |
You are viewing an excerpt of this Topic. Subscribe Now to get Full Access to ALL this Subject's Topics and Quizzes for this Term!
Click on the button "Subscribe Now" below for Full Access!
Subscribe Now
Note: If you have Already Subscribed and you are seeing this message, it means you are logged out. Please Log In using the Login Button Below to Carry on Studying!
Responses