Chapter 6: Database Management System (LibreOffice Base) 📌 Chapter 6 – Important Topics: Database – Definition, Need, Advantages DBMS – Definition, Components LibreOffice Base – Introduction Key Terms – Table, Field, Record, Entity, Attribute, Primary Key, Foreign Key, Relationship, Query, Form, Report Steps to Create a Database Creating Tables (Design View, Data Types, Primary Key) Defining Relationships Creating Forms (Wizard, Design View, Controls, Subforms) Creating Queries (Wizard, Design View, Criteria, Computational Fields) Creating Reports (Wizard, Static vs Dynamic) Advanced Example – Ledger Creation & Voucher Entry Form Previous Year Exam Questions (2018–2024) 1. What is a Database? A database is a collection of related data that is organised so that you can easily view, access, manage and update the data. Simple Explanation: Think of a database as a smart digital filing cabinet. Instead of paper files, you store ...