Databases

Databases

1. DBMS

   • Database Management System
   • Forms
   • Reports
   • Queries
   • Edits, manages and stores data

2. Relationships

   • One-to-one
     • When each record in a table only connects to one record in another table
     • One primary key to foreign key and one foreign key to one primary key
   • One-to-many
     • Each record in a table connects to many records in another
   • Many-to-many
     • Each record can connect to each other

3. Validation

   • Lookup
   • Range
   • Presence
   • Length
   • Format

4. Data Types

   • Text
   • Alpha numeric
   • Boolean
   • Integer
   • Date/Time

5. A persistent organised store of data

6. By Josh Watkins

7. Key Terms

   • Referential Integrity
     • Any foreign key field must agree with the primary key that the foreign key references
   • Normalization
     • The process of organizing columns and tables of a relational database to improve data integrity and reduce data redundancy