Notes · Class 10 · CBSE Information Technology (402)

Database Management System using LibreOffice Base notes

Revision notes for the chapter: the key points, definitions and exam tips to remember.

A database is an organised collection of data. A DBMS (Database Management System) stores, retrieves and manages it. LibreOffice Base is a DBMS.

KEY CONCEPTS

  • Table: rows (records/tuples) and columns (fields/attributes).
  • Primary key: field that uniquely identifies each record (e.g. Roll No). Cannot be null or repeated.
  • Foreign key: field in one table that refers to the primary key of another; links tables.
  • Advantages of DBMS: less redundancy, consistency, data sharing, security, backup.
  • RDBMS: data in related tables (Base, MySQL, Oracle).

DATA TYPES

  • Numeric (integer, decimal), text/alphanumeric (VARCHAR, CHAR), date and time, binary (images), Boolean (Yes/No).

WORKING IN BASE

  • Create a database (.odb) → create tables in Design View or with a wizard; set the primary key.
  • Relationships: one-to-one, one-to-many, many-to-many. Tools → Relationships.
  • Queries: find data meeting criteria (Design View or SQL). Sort and filter.
  • Forms: user-friendly way to enter and view data.
  • Reports: formatted output of data for printing.

SQL BASICS

  • SELECT * FROM Student WHERE Marks > 80 ORDER BY Name;
  • DDL (CREATE, ALTER, DROP), DML (INSERT, UPDATE, DELETE, SELECT).
Memory hook: "Tables store, Queries ask, Forms enter, Reports show."

Database Management System using LibreOffice Base: practice questionsDatabase Management System using LibreOffice Base cheat sheet

More Class 10 · CBSE Information Technology (402) notes

Practise Database Management System using LibreOffice Base

Sign up free to practise the full chapter after revising. Questions you get wrong come back until you've mastered them.

Start practising free

Free to start · No credit card needed