Databases

?
  • Created by: millard
  • Created on: 04-05-16 14:58

A DBMS helps by:

CRUD:

  • Create
  • Retrieve
  • Update
  • Delete

Also, it has:

  • Integrity - Even if the data changes the applications using the data do not need to be changed
  • Backups - easily backs up the data which means that the database is unlikely to be lost
  • Consistency - the data is the same regardless of who is viewing it
  • Security - Can control who can access which data
  • By using unique identifiers data redundancy can be avoided, which reduces the file size
1 of 3

Benefits of using DBMS:

  • Allows different views of the database 
  • The external view of the DB is done by people who input or view the data
  • A conceptual view is useful for the DB designer
  • An internal view is used for the detailed programming of the DB
2 of 3

Forms & Reports

Form:

Used to input data into a table 

Reports:

Used to export data and present it in an easy to read format

3 of 3

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »See all Databases resources »