You should be able to…(NOTE: Highlighted in red is KEY information that you should learn)

  • Describe how a DBMS allows the separation of data from applications and why this is desirable

-It allows multiple/different brands of applications to access the database without having to adapt the database structure

-Different views of the data can be set up meaning you can limit what users can access

-The applications can be changed without affecting the data structure

-The data can be updated/changed without affecting the application(s) 

-Data integrity is maintained

  • Describe the principal features of a DBMS and how they can be used to create customised data handling applications

 TOPIC OVERVIEW (Test your Knowledge)