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

Screen Shot 2016 02 18 at 1.52.57 pm

 Field

  • holds a single value for an object
  • eg a field in a database is firstName
  • eg another field in a database is LastName

Screen Shot 2016 02 18 at 1.51.26 pm

Record

  • shows the data for one object
  • usually viewed in a single row
  • eg in a row might be the following

Screen Shot 2016 02 18 at 1.50.13 pm

Table /Relation

  • a table is a collection of records
  • a table is also a collection of rows

Screen Shot 2016 02 18 at 1.46.53 pm

 

 

Learn more from wikipedia

 

 Found an error on this page? Please let us know via the contact form under the Home menu item.