DBMS Flashcards
1
Q
What is the role of the DBMS?
A
It’s a software that is responsible for managing the interaction and access to the database.
2
Q
What are the 7 advantages of the DBMS?
A
- Maintainable
- Little to no data duplication
- Scalable
- Isolated data storage
- Unified DML
- Concurrent accessibility
- Improved security
3
Q
What are the 10 functions of the DBMS?
A
- Storage, update, access
- Concurrent usage
- System catalogue
- Recovery procedures
- Transaction support
- Integrity
- Authorisation
- Communication
-Data independence - Utility services
4
Q
What are some disadvantages of the DBMS?
A
- Complex software
- Large software
- May run slower due to being programmed for generic use
- DBMS centralisation means if failure occurs it has a larger impact
