A database is a structured collection of information stored on a computer system, designed to efficiently manage and retrieve data. In relational databases, multiple tables are linked to reduce data redundancy, minimize entry errors, and save storage space.