Database Definition and Common Database Terminologies
TOPIC:
Database Definition and Common Database Terminologies
Class :
JSS 3 / BASIC 9
Term:
FIRST TERM
Week:
Week 8
Reference Materials:
- ONLINE MATERIALS
- SCHEME OF WORK
- TEXTBOOKS
Instructional Materials
- Pictures
- Wall charts
- Computer
Previous Knowledge:
The pupils have previous knowledge of
Limitation of the old economy
Behavioural Objectives: At the end of the lesson, the pupils should be able to
- define database
- explain common database terminologies
CONTENT:
A database is a collection of data that can be accessed by computers. A database can be divided into two basic components: a table and a database package.
A table is the basic structure of a database. It is a collection of data that is organized into rows and columns. Each row represents a record, and each column represents a field.
A database package is a software application that helps you create and manage databases. It provides a user interface that allows you to access, edit, and query data. Access is the most popular database package. It is produced by Microsoft.
Definition of Database
A database is a collection of related data about a particular subject that is organized in a way that it can be easily stored, accessed, managed, and updated to meet a particular goal.
It is always set up for a special purpose like students’ records, inventory, address book etc. This database has a particular software that could be used to perform the above functions e.g. Paradox, MS Access, Dbase etc.
A database is composed of several tables.
You need to create separate tables to store different types of data. For example, if you have a School Management Software, you may need to create the following tables:
- Students – to store list of all students
- Educators – to create a list of all educators.
- Address – to store the addresses of students and educators.
- Grades – to store the mark scores of all students.
Database Terminologies
Entity: A person, object, event or transaction (e.g. student, employee, patient).
Entity Group: A class of people, objects, events or transactions sharing very similar characteristics (e.g. students, employees, women, patients, engineers etc.).
Field: This refers to a column of data in a table, each column or field in a table contains similar types of data for all the members of the entity group whose data are stored in the table. Field is also called attributes.
Record: This refers to a row of data in a table, each row or record in a table contains the data for a specific member or the entity group (entity) whose data are stored in the table. Record is also called tuple.
Table: A data structure that stores a collection of data in tabular form.
View: A logical representation of one or more tables from the database, which may be a subset of the columns and/or rows from those tables. Views are also sometimes called “virtual tables”.
Index: A pointer to a location in a table, which may be used to speed up the retrieval of data from that table.
Query: A set of instructions for retrieving data from a database.
Form: A layout for entering and displaying data in a database.
Report: A formatted presentation of data from a database.
Macro: A set of pre-defined instructions for performing a task, which may be stored in a database and run when needed.
Trigger: A set of instructions that are automatically executed in response to an event, such as the insertion or deletion of a record in a table. Triggers are sometimes also called “event-driven procedures”.
PRESENTATION
The topic is presented step by step
Step 1:
The class teacher revises the previous topics
Step 2.
He introduces the new topic
Step 3:
The class teacher allows the pupils to give their own examples and he corrects them when the needs arise
EVALUATION
Evaluation:
Define the following
- Access
- A Table
- Database package.
- Form
- Index
- View
- Trigger
- Report
- Macro
- Query
Objectives
- A _______is a single store of related information.
- A ________consists of records, and each record is made up of a number of fields.
- You can think of the phone book as a _____: It contains a record for each telephone subscriber, and each subscriber’s details are contained in three fields – name, address and telephone.
- A database package is a piece of ____________that enables you to organize and store related data together, so that specific pieces of information can be retrieved easily and quickly.
- Access is a database program, created by __________Office 2007
- An organised collection of related records is a________
- ____________ is a selected field in table that uniquely identifies a record.
- A database has to be named before any work is started on it. True or false?
- The use of a file cabinet to store information is called____________
the manual method b. The computerised method
the ancient method d. none of the above. - ________ is a means of storing and answering questions about information in a database
- The following are example of database program except_________
Dbase3+ b. Microsoft Word
Dbase 4 d. Microsoft Access
Conclusion:
The subject teacher gives out a short note and he or she goes round to mark. The teacher does the necessary corrections.