Field: A space allocated for a particular item of information in database management systems. Fields are them stored in a record.
Record: In database management systems , it is a complete set of information Many records will them create a file.
File:A file is a block of information or resource for storing information. It contains a number of records that have fields within them such as an adress field, phone number field and a name field.
Query: A request for information from a database.
Database: A collection of information organized in such a way that a computer program can quickly select desired pieces of data
DBM''s: A collection of programs that enables you to store, modify, and extract information from a database
Data Dictionary: . A data dictionary contains a list of all files in the database, the number of records in each file, and the names and types of each field
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.
Illustrate, with the aid of a table or diagram, what is a file, record and field.
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.
Council database- The council database has information on everyone living in that area. Information may include the person's name, address, phone number etc.
No comments:
Post a Comment