Databases

Databases

1. Keywords

   • Entities
     • Tables
     • A real world object
     • E.g: Appointments, doctors, patients
   • Attributes
     • Fields
     • E.g: ID, title, surname, forename, gender

2. Validation Checks

   • Type
     • Data types
   • Range
     • Specific values
   • Digits
   • Presence
     • Required
   • Length
     • Amount of characters
   • Lookup
   • Input Masks
     • Default values to choose from

3. Data Types

   • String
     • Text
     • E.g: A, b, c
   • Integer
     • Whole numbers
     • E.g: 1, 2, 3
   • Real
     • Decimal numbers
       • E.g: 0.1, 0.2, 0.3
   • Boolean
     • True/False
     • E.g: Yes, no

4. Flat File Vs Relational

   • Forms
     • Method of avoiding flat file
   • Redundancy
     • Not needed

5. Primary Keys

   • One to many

6. Foreign Keys

   • Many from one

7. DBMS

   • Database management system
   • Run report
   • Manage/maintain records in entities
   • User interfaces (Forms)
   • Run Queries
     • >< AND OR NOT
   • Benefits
     • easier to maintain/keep secure
     • Database is safe from curruption
     • Set up by the experts and used by the end user
     • Can Be Accessed In Multiple Ways (Tablet, PC, web, phone)
       • Doesn't disrupt if one application is uploaded