Database Definitions

1. DEFINITIONS

1.       Field: Categories/Classifications in a database.

2.      Record: Anything providing permanent evidence of or information about past events.

3.      File: Record in a public office or in a court of law.

4.      Query: Putting together questions.

5.      Database: A database is a collection of data for one or more multiple uses. One way of classifying databases involves the type of content.

6.      Report: A written document describing the findings of some individual or group.

7.      DBMS: Database management system: a software system that facilitates the creation and maintenance and use of an electronic database

8.      Data Dictionary: A centralized repository of information about data such as meaning, relationships to other data, origin, usage, and format. It helps build a database.

9.    Data Type: A classification identifying one of various types of data, as floating-point, figure, or Boolean, stating the possible values for that type, the operations that can be done on that type, and the way the values of that type are stored.

2.  File, Record and Field

3. Common databases:

• RTA database- Its got all the drivers details such as their name, phone number, address etc.
• Hospital database- The hospital database has all it's patients personal details (i.e. name, address, medical history etc.)
• School databse- The school's database has got information about the students that go to the school...they have details such as name, d.o.b, phone number, their grades throughout their school life etc.
• Library databse- Its got details about all the people registered with the library so that they can track them down if the need be. The details may include name, library card number, books/cd borrowed, phone number etc.
• Council database- The council database has information on everyone living in that area. Information may include the person's name, address, phone number etc.