What is Database?
A database is a collection of interrelated data, which allows the user to retrieve, update and manipulate data very easily as and when required. The telephone directory, your personal address book, dictionary, records of students are examples of databases. The hospitals, universities and many other organizations are using database management systems to properly maintain their records. In Pakistan, NADRA (National Database & Registration Authority) has recently developed a database of all the cities of Pakistan.
In a database, related fields such as student’s roll number, name, address etc. are grouped together to form records. Mostly, in a database the data is organized in tables. (in tabular form). The columns represent the related fields and a row is equivalent to a record. In most databases, data is organized in related tables. These types of databases are known as relational databases. Each table contains rows and columns; the rows are called records and columns are called fields. A table is given below that contains four records and each record contains four fields.
| Code | Name | Address | Marks |
|---|---|---|---|
| 0303 | John Valley | New York | 755 |
| 0304 | Antioco | California | 725 |
| 0305 | Ashur | Texas | 699 |
| 0306 | Bailey | Pennsylvania | 788 |