Syllabus Detail
- The hierarchical structure of data; character/byte, field, record, table/relation. 11 ATAR, 12 GEN
Character / Byte
- the smallest possible item you can see on a screen is character
- the number 1, is a character and seen on the screen
- for the number 1, inside the computer is binary 00000001
Field
- holds a single value for an object
- eg a field in a database is firstName
- eg another field in a database is LastName
Record
- shows the data for one object
- usually viewed in a single row
- eg in a row might be the following
Table /Relation
- a table is a collection of records
- a table is also a collection of rows
Learn more from wikipedia,
Found an error on this page? Please let us know via the contact form under the Home menu item.