Q.Explore LibreOffice Base and compare it with MySQL

When a family chooses between keeping accounts in a notebook, a spreadsheet, or proper accounting software, they are weighing the same trade-offs an organisation weighs when choosing how to store its data. Comparing the storage approaches — plain files, spreadsheets, and database management systems — on clear criteria is what database comparison is about, and the criteria matter more than any single verdict.

The sensible dimensions of comparison:

• Volume of data. A spreadsheet is comfortable up to thousands of rows; beyond that it slows and becomes unwieldy. A database is engineered for lakhs and crores of records without breaking stride.
• Number of simultaneous users. A file or spreadsheet is fundamentally single-user; two people editing at once invite lost updates. A database is built for many users reading and writing concurrently, with the system coordinating them so their changes never trample each other.
• Redundancy and consistency. In files, the same fact gets copied into many places and drifts out of agreement. A database stores each fact once and links to it, so an update lands everywhere at once.
• Integrity enforcement. A spreadsheet will accept any typo in any cell. A database checks every entry against declared rules — types, uniqueness, valid references — and rejects what violates them.
• Security. File-level protection is all-or-nothing. A database grants rights per user and per table, so the accounts clerk and the principal see different slices of the same data.
• Querying power. Answering a new question of a file needs a new program; of a spreadsheet, laborious manual filtering. A database answers arbitrary questions on demand through a query language, combining tables freely.
• Recovery. A corrupted file is often simply lost. A database keeps logs and backups and can restore itself to a consistent state after a failure. …