Record: a set of fields like name, phone no. and address
File: is made of records
Query: a search for information from a database
Database: collection of related data organised for easy access
Report: a printed report of the information in the database
DBMS (database managment system): the software which manages the database
Data Dictionary: it 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: what the data is, like date/time, text or numeric. you use numeric for calculations.
Here is an example
Each column is a field, a row is a record and this whole table is a file.
No comments:
Post a Comment