Databases

Databases

1. Flat-file

   • Single table of data
   • Limited use from one pool of data
     • Data redundancy: data can be entered over and over again like customer details for every order

2. Relational Databases

   • Advantages
     • Data redundancy
     • Data consistency
     • Password access to allow access to certain areas for certian employees
   • Two or more tables
     • With links
       • Primary keys
       • Foreign keys

3. Verification and Validation

   • Proof reading
   • Double entry