Database

Database

1. Entity

   • Attribute

2. Boolean

3. Foreign Key

4. Primary Key

5. Flat file database

   • Relationship Database
     • Data redundancy

6. Validation check

   • Inputmask
     • making sure the data is entered in the right format for example a date of birth
   • range check
     • Make sure that the data entered is limited and has a boundary for example 1 to 10
   • Length check
     • Making sure that only the right amount of data is entered
   • Presence check
     • Making sure data is entered in the database
   • Look up
     • Having a drop down list to allow the user to choose the data from the data set
   • Type check
     • Making sure that the correct numbers like decimals yes or no letters or who numbers are entered

7. real

8. Integer

9. String

10. DBMS

    • Run queries
    • Manage queries
    • Run Report
    • Manage records in tables
    • Benefits
      • Set up by experts
      • easier to maintain
      • Keep sucure
      • Safe from curruption
      • Multiple people can access
      • Dosent distrupted if one isn't updated
    • Validate data