Database lesson - Grade 10 - ICT
1️⃣ What is a Database?
A database is a system that securely stores a lot of information (data) in one place, making it easy to search and use.
Example:
If a school's student information (name, class, age, phone number) is stored in one place, it is a Database.
2️⃣ What is data?
Data is raw information.
Examples:
Name
Age
Address
Phone number
These are data.
3️⃣ What is a Table?
In a database, data is stored in Tables.
A Table looks like an Excel sheet.
4️⃣ What is a Field?
A Field is a column.
📌 Examples:
Student ID
Name
Age
Class
These are Fields.
5️⃣ What is a Record?
A record is a row.
📌 Example:
| 01 | Nimal | 15 | 10A |
This is a Record.
6️⃣ Examples of using Database
School student information
Bank accounts
Hospital patient information
Library book list
✅ Summary
Database → Information storage system
Table → Table where data is stored
Field → Column
Record → Row
MCQ Questions
(01). What is a database?
1. A computer game
2. A system for storing information
3. An operating system
4. Drawing software
(02). What is a column in a table?
1. Record
2. Field
3. Database
4. File
(03). What is a row in a table?
1. Field
2. Record
3. Database
4. Form
(04). Which of the following is a place where a database is used?
1. Hospital
2. Bank
3. School
4. All of the above
(05). What is data?
1. Raw information
2. A computer
3. A printer
4. Software
Correct Answers
1️⃣ 2
2️⃣ 2
3️⃣ 2
4️⃣ 4
5️⃣ 1
|
| Database Short Notes
1️⃣ Database
A database is a system that stores a lot of data (information) in one place and makes it easy to search and use.
📌 Examples
Student information in a school
Bank accounts
Patient information in a hospital
2️⃣ Data
Data is raw information.
📌 Examples
Name
Age
Address
Phone number
3️⃣ Table
Data in a database is stored in tables.
A table consists of rows and columns.
📌 Examples
ID Name Age Class
01 Nimal 15 10A
4️⃣ Field
A Field is a column in a table.
📌 Examples
ID
Name
Age
Class
5️⃣ Record
A Record is a row in a table.
📌 Examples
|01|Nimal|15|10A|
This is a record.
6️⃣ Primary Key
A Primary Key is a field used to identify one record from another.
📌 Example
Student ID
7️⃣ Places where Databases are used
Schools
Banks
Hospitals
Libraries
✅ Remember (Important for Exams)
Database → Information storage system
Table → Table where data is stored
Field → Column
Record → Row
Primary Key → Field used to identify a record
📝 Past paper questions.
1. What is a record in a database?
1. A column in a table
2. A row in a table
3. A file
4. A field
2. What is the main function of a primary key in a table?
1. Deleting data
2. Identifying a record as unique
3. Printing a table
4. Copying data
3. What is a column in a database called?
1. Record
2. Field
3. File
4. Form
4. Which of the following is a database software?
1. Microsoft Word
2. Microsoft Access
3. Microsoft Paint
4. Notepad
5. What are Student ID, Name, Age in a Student Table?
1. Records
2. Fields
3. Tables
4. Files
6. What is the main advantage of keeping data secure in a database?
1. Data can be searched easily
2. Computer speed increases
3. Monitor resolution increases
4. Keyboard speed increases
Correct answers
1️⃣ 2
2️⃣ 2
3️⃣ 2
4️⃣ 2
5️⃣ 2
6️⃣ 1 |
|