Database System

• Fields:(also known as attributes) columns - surname, first name, number, address (seperated into street, sub, postcode etc) 
• Record: (tuple)  rows
• Singe table: - flat file database - alot of redundant data (repeated)
• Relational Database: multiple table, minimises redundancy -> linking tables together with different fields/ data (tables are linked through common fields) uses Primary key: a unique identifier, I.D field - >table
• Data Types: texts (alpha numeric - number, symbols and letters), numeric, boolean - yes/no or true/false or 0,1, memo - unlimited length, date/time, objects (digital - pictures/images/audio files, docs), html\
• Database Management System: e.g. access, file maker