Micro Notes-CHAPTER 6 DATABASE MANAGEMENT SYSTEM FOR ACCOUNTING
DATABASE & DBMS Database: Collection of related data organised for easy access, management & update. DBMS: Software to create & maintain database (LibreOffice Base, MS Access, Oracle, MySQL). Advantages: Centralised data, portability, multiple user access, reduced redundancy, timely info. Components: Data, Hardware, Software, Users. LIBREOFFICE BASE INTRODUCTION Extension: .odb. Free & open source DBMS in LibreOffice suite. KEY TERMS Data: Raw facts ("Aneesh", 3031). Table: Rows & columns storing data. Field: Column (Student_Name). Record/Tuple: Row (one person's data). Entity: Real-world object (Student). Attribute: Property of entity (Name, DOB). Primary Key: Unique ID for each record (Admission No). Foreign Key: Field linking to primary key of another table. Relationship: Connection between tables. Query: Question to retrieve data. Form: Interface for data entry. Report: Formatted output for printing. STEPS TO CREATE D...