Sign up
Please tick the below box to proceed
I agree (or if I am under 13 my parent or guardian agrees on my behalf) to the terms and conditions of use and that:
- My test statistics may be published on the site leaderboard against my username
- My teacher(s) can review my test scores
- I can receive feedback on my tests from my teacher(s)
Please tick this box to proceed
Already have an account? Sign in
Preview lessons, content and tests
Computer Science & Programming solved. All in one platform.
1. To trial the platform and take tests, please take a few seconds to SIGN UP and SET UP FREE.2. Searching for something specific? See our text overview of all tests. Scroll right for levels, and lists. 3. Student and Teacher User Guides | Schemes of Work | Real Teacher use Videos |
Join 36000+ teachers and students using TTIO.
Files, Records and Files
By definition, a database can contain one or more tables. A flat file database contains a single table. Relational databases contain two or more related tables.
A table is organized in columns and rows, with each column identified by the type of data included, and each row representing actual data. Each row in a database table is a record, because it contains information on a single data item. A field defines the individual elements of a record. For example, fields may include item, serial number, and value. Fields, then, are table columns, whereas records are rows. Perhaps the reason the table format makes so much sense is that it is exactly the way you would most likely develop a list of records on paper as rows (records), each containing the same types of information (fields). The entire collection of records, stretching across one or more tables, is a database file.