Database and Records
A database (db) is a structured collection of records or data that is stored in a computer system. It can be, for example, a library database containing data on books and authors, or a company database containing data on products, orders, employees and so on.
Structured information on one object (book, author or product) is called a record. For example, if there are 5 books in our database, we can say there are 5 records in the database.
Record type (form)
What type of data is stored in a record is defined by a record type or a form. In case of a library database, there will be two forms: book and author. In case of a company database, we will need correspondingly such forms as product, order, employee and so on.
Simple and Relational databases
If all records in a database have one form (for example, in a contacts database), such database is called simple. If there are several forms in a database that are related to each other (books and authors, orders and products and so on), such database is called relational.
A form consists of fields. For example, the form 'Book' will have the following fields: author, cost, number of pages, year of issue. And the form 'author' can have the following fields: name, date of birth and photo. Fields are used to store, process and display data.
However, information stored in fields is saved not in a form, but in a record. A form only defines with the help of fields with what kind of data we want to work.
There can be fields of different types, for example:
Changing the fields values is called editing a record.
Traditionally, records are presented in the form of a table or a form:
In case records are displayed as a table, every line of a table represents a separate record. Displaying a record as a form is more convenient for editing a record.
Operations with records
What operations can be performed in Brilliant Database?
Copyright (C) 2001-2010 Binary Brilliant Inc. All Rights Reserved.