Ravindra Singh  Gohil
Ravindra Singh Gohil answered
Disadvantages/Demerits of DBMS:-
  • High cost for implementing DBMS.
  • May involve more expensive hardware
  • Specific programming skills
  • Database file conversion
  • Slower processing of less critical applications
  • Increased vulnerability as resources are centralized
  • More sophisticated recovery required when concurrent updates allowed.
Ravindra Singh  Gohil
Ravindra Singh Gohil answered
  • It is an individual user's partial view of the database.
  • Sub-schema provides different view of the data to the users and the programmers, who  do not need to know all the data contained in the entire database.
  • Sub-schema enhances security factors and prohibit data compromise.
  • Sub-schema aid DBA while assuring data integrity.