Database: JSS Three

Database

TOPIC: Database

CLASS: JSS Three

What is Database?

1. A database is a collection of data organized in a manner that allows access, retrieval and use of data.
2. A database is a collection of information that is organized so that it can easily be accessed, managed, and updated.
3. A database is an organized collection of data.

Meaning and Definition of DBMS

DBMS stands for DataBase Management System.
DataBase Management System is defined as an application software that manipulates the data in the database.

Examples of DBMS Packages

They include:
Dbase
Rbase
MS Access
Oracle
Paradox
MYSQL Server
SyBase
FOXPRO
IDMS
System 2000.
Ingres
Postgres
NoSQL

Database Terminologies

1. Field: Field is a single piece of information about an object. A is also defined as a space that holds specific parts of data from a set or a record. Examples of fields are NAME, ADDRESS, QUANTITY, AGE, etc.
2. Record: A record is a collection of fields. It is the collection of information about a particular element, person or object.
3. File: This is the collection of a related record
4. Primary Key: a field in a table whose value uniquely identifies each record in the table. Examples of fields that can serve as primary keys include; NIN, Driving License number, Bank account number, Admission number, Fingerprint, BVN, etc

Forms of Database

1. Hierarchical Database
in this form of database, data are arranged or structured in form of a tree. It can also be defined as a design that uses a one-to-many relationship for data elements. The data is stored as records are connected through links
2. Network Model
This type of database allows the modelling of many-to-many relationships of data. In the network model of a database, a record can have multiple parents, making the system more flexible compared to the strict single parents of the hierarchical database.
3. Relational Model
A relational database presents information in tables with rows and columns. Records are arranged in rows while fields are arranged in columns. A relational database is the most common type of database structure. It is used by most microcomputers in Database Management System (DBMS) packages.

Starting a DBMS (MS Access)

To start the database in Microsoft Access, you do the following:
Step1: Click on the start button on the taskbar
Step 2: Move to all Programs,
Step 3: Click on MS Access

Opening an Existing Database

To open an existing Database, do the following:
Step 1: Click on the file menu, then click the open button
Step 2: Click on the file to be opened from the dialogue box.
Step 3: Then click on open or press enter on your keyboard.

Tutorial on How to Create a Simple Database using Microsoft Access


In this video you will learn how to do:
a. Create fields
b. Add records to the fields
c. Sort a database using a specific creteria
d. Create a Report
e. Query a database, etc
The Video tutorial is below.

Comments

  1. SIRJOE10 February 2020 at 06:20

    thank you very much

    ReplyDelete
  2. Unknown24 September 2020 at 19:27

    thank you very much❤❤💖💘

    ReplyDelete
  3. Yusuf26 September 2021 at 12:52

    Thanks so much

    ReplyDelete
  4. Unknown15 April 2022 at 04:23

    So far, I have access many of your posts, and truth be told words cannot describe the perfect quality of information you provide. Thank you very much and more grace to keep doing the good job.

    ReplyDelete
  5. Anonymous19 September 2023 at 22:10

    Good ,thanks.

    ReplyDelete
  6. Anonymous14 February 2024 at 20:56

    Thanks

    ReplyDelete
  7. Anonymous18 February 2024 at 11:32

    Well at least I learned something 😃😃

    ReplyDelete
  8. Anonymous27 March 2024 at 21:19

    thank you so much

    ReplyDelete

Post a Comment

Popular posts from this blog

90 Objective Examination Questions in Major Subjects

An examination is a formal test that you take to show your knowledge or ability in a particular subject, or to obtain a qualification. This section of my blog is designed to provide 90 objective examination questions covering first, second and third term work in major subjects. Basic Science Computer Studies/Information Technology Biology Financial Accounting Basic Technology Business Studies Physical and Health Education Civic Education Christian and Religious Studies Physics Economics Geography Cultural and Creative Arts (CCA) Prevocational Studies Chemistry Mathematics
Read more

Complete Computer Studies/ICT Curriculum for JSS 1 to SSS 3

Curriculum refers to the lessons and academic content taught in a nation, state, school or a specific course or program. This post contains a complete curriculum in Computer Studies as compiled by the Nigeria Ministry of Education. First, second and third terms scheme of work can be extracted from it. To access the simply click on the links below. JSS ONE CURRICULUM IN COMPUTER STUDIES TOPIC Historical Development of Computer CONTENT . Early counting devices · Fingers · Fingers · Stones · Sticks · Pebbles · Cowries 2. Mechanical Counting Devices · Abacus · Slide rule, ETC OPERATIONAL OBJECTIVES Students should be able to: 1. List early counting devices 2. State the problems in counting large numbers with those devices 3. Name mechanical counting devices 4. Name electro-mechanical counting devices TEACHING AIDS Fingers, Toes, Sticks, stone, Charts, etc JSS ONE COMPLETE CURRICULU
Read more

JSS One Objective Questions in Computer Studies/Information Technology

1. One major Problem with early counting devices is that A. they are always accurate B. they waste time C. they can be used to count large numbers D. they were fast 2. UNIVAC is an acronym that stands for A. Universal Automatic Computer B. Universal Array Computer C. Unique Automatic Computer D. Unvalued Automatic Computer Click Here to view all Questions
Read more