Database Definitions

This is Activity 2 in the Term 1 Activities
1. Definitions
Field- It is an allocated space for a specicfic item of information. Fields are the smallest units of information which are able to be accessed.
Record-They are composed of fields and each of these contains one item of information. Then these set of records "constitutes"a file.
File-Is a collection of data or even information that has a name, known as the filename. Information stored in a computer is put in a file and these different files contain different information.
Query- It is a request from a database.
Database- It is a collection of information in such a way that the actual computer program can immediately "select desired pieces of data." Its mainly an electronic filing system.
Report- It is formatted as well as presented data.
DBMS- Also known as Database Managment System. It is a collection of programs that are you are able to store,modify as well as extract information from a database. There are different types a small system which runs on personal system and a large system which runs on mainframes.
Data Dictionary: In DBMS systems, it is a file that defines the basic organization of database. So what does a data dictionary actually contain? Well it contains:
-a list of files in the database
-number of records in a file
-names and types of each field
In short a database doesnt actual contain data but instead a bookkeeping information for managing it.
Data Type- A data type in "programming languages" is an attribute of data which tells the computer and programmer what specific data it is.
2. This is a diagram of a database of music including the album's title, song title, artist and genre and there are 10 songs. The field, record and file are all labeled!
3. Commonly used databases include:
1. White Pages.
2.Itunes(Music).
3.Dictionaries(database of words)-Paper based database.
4.Libraries- Paper based database.
5. Address Book on your phone.