Ask Medha

CBSE Class 10 · Information Technology · board exam 2027

Chapter 3: Database Management System using LibreOffice Base — notes

The chapter’s 8 parts in the book’s order — the first idea of each and the points Medha Ma’am writes on the board — and the summary at the end. The full lesson and a check question for each part are in the app.

This chapter’s important questions →

  1. 1. Data, Information and Database

    Okay, so, you deal with databases all the time, without even noticing.

    • • Data = raw facts (marks, prices, names)
    • • Information = processed/organised data
    • • Example: marks + roll no = data; report card = information
    • • Database = logically related data, stored in organised way

  2. 2. DBMS and its Advantages

    Okay, so — we create data, we update it, we retrieve it.

    • • DBMS = software to create, update, retrieve data
    • • Examples: MS Access, LibreOffice Base, Oracle, MySQL
    • • Advantages: organised storage, data analysis, data sharing
    • • Minimal data redundancy, data consistency
    • • Efficiency, accuracy, validity, security (encryption)

  3. 3. Data Models

    Okay, so a database can be designed in different ways, depending on what data we're storing.

    • • Data Model = structure describing storage & retrieval
    • • Hierarchical Model: tree-like, records linked in levels
    • • Network Model: many records linked to one master file
    • • Relational Model: relationships via common fields
    • • Proposed in 1970 by E. F. Codd

  4. 4. Relational Database Terms: Entity, Table, Field, Record

    Okay, so let's talk about how a database is organised.

    • • Entity = real world object (e.g. Student)
    • • Attributes = details of entity (become columns)
    • • Table = collection of logically related records
    • • Field = smallest entity, shown as column
    • • Data values = raw values (e.g. 'Abhinav', '26')
    • • Record = row = all field values for one person/object

  5. 5. Primary Key, Foreign Key and Related Keys

    Okay, so let's talk about keys in a database.

    • • Primary key = uniquely identifies a row, no blanks/duplicates
    • • Composite key = 2+ fields together as primary key
    • • Relational database = collection of related tables
    • • Foreign key = field linking to primary key of another table
    • • Candidate key = all fields eligible to be primary key
    • • Alternate key = candidate key not chosen as primary

  6. 6. Objects of an RDBMS: Table, Form, Query, Report

    Okay, so let's talk about objects in a database.

    • • Object = structure/feature to store, represent, retrieve data
    • • Table = basic unit, rows (records) & columns (fields)
    • • Form = user friendly data entry screen
    • • Query = question asked from database to retrieve data
    • • Report = formatted, formal presentation of query output

  7. 7. Data Types in LibreOffice Base

    Okay, so when you make a table in Base, you have to pick a data type for every field.

    • • Data type = kind of data a field can store
    • • Text: Memo, Text(fix)/CHAR, Text/VARCHAR
    • • Numeric: Integer, BigInt, Number, Decimal, Float, Double
    • • Currency: $100, £500, Rs. 25.50
    • • Date: Date, Time, Timestamp e.g. 12/25/2019
    • • Boolean: True/False; Binary: images/sounds

  8. 8. Creating, Editing and Organising a Table

    Okay, so let's set up a table in LibreOffice Base.

    • • Database Wizard: Create new database, No register, Finish
    • • Save with extension .odb
    • • Create table: Wizard (ready tables) OR Design View (own fields)
    • • Primary key: right-click field name -> Primary Key
    • • Enter data: type value, Tab to next field
    • • Sort: select field, click Sort Ascending/Descending

Summary

Okay, so let's look back at what we covered today. Raw facts are called data, and once we process them, they become information. A database organises related data, so it's easy to add, modify, delete or display. DBMS software, like LibreOffice Base, manages this for us. It gives us advantages like reduced redundancy, consistency, efficiency, accuracy, validity and security. Then we looked at data models, especially the relational model. Here, entities have attributes, and tables hold records made of fields and data values. Primary keys, foreign keys, candidate keys and alternate keys — these connect tables and uniquely identify information. We also saw the main objects of an RDBMS — tables, forms, queries and reports. Tables store data, forms help with easy entry, queries retrieve data, and reports present it. Finally, we learned the data types in LibreOffice Base — text, numeric, currency, date, boolean and binary. And we practised creating a database and table, setting a primary key, entering, editing, deleting and sorting data, and even editing or deleting a table itself. Now, tell me — which of these steps did you enjoy doing the most on the computer?

Ask Medha · Medha Ma’am — CBSE Class 10 Information Technology, Chapter 3. Written from the textbook, checked twice.

Questions parents and students ask

How do I get the "Database Management System using LibreOffice Base" notes as a PDF?
Press "Save as PDF" — the phone’s print sheet opens; choose "Save as PDF" there. The PDF holds the notes only.
Where are these notes written from?
From the chapter’s own textbook text, part by part, in the book’s own terms; a second, independent model then checked every part against the book. The full lesson, a check question for each part and the practice are in the Ask Medha app.

The same preparation, with Medha Ma’am — on your phone

Every question of every chapter with its model answer, practice questions in the board’s own shapes, 45 minutes of class a day, written answers marked, a test every Sunday and a WhatsApp report to parents.

StartAbout the course

Medha Ma’am is an AI teacher, not a live tutor. Every answer is checked twice; a person takes responsibility.