Often abbreviated DB, a database is basically a collection of information organized in such way that a computer program can quickly select desired pieces of data. You can think of a database as an electronic filing system. You can not only store, but also insert, update and delete data from DB.
A database model is a type of data model that determines the logical structure of a database and fundamentally determines in which manner data can be stored, organized, and manipulated. The most popular example of a database model is the relational model, which uses a table-based format, but there many others data organization models exist.
Relational databases are organized by fields, records and tables. A field is a single piece of information; a record is one complete set of fields (often referred to as "row" of data); and a table is a collection of records (rows). For example, a telephone book is analogous to a table. It contains a list of records, each of which consists of three fields: name, address, and telephone number.
Relational DBs establish a well-defined relationship between database tables. Tables communicate and share information, which facilitates data searchability, organization and reporting.
- Database is a collection of information organized in such way that a computer program can quickly select, insert, update and delete desired pieces of data.
- Most popular database model is relational model organized around tables, records and fields. Tables can establish relationship with each other.