Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2 LSP4YOU - Learner's Support Publications
DBMS BCA Unit-1 DBMS - Introduction The File Based System Database System vs. File Based System Limitations of File Based System Database System Components Advantages of Database Approach DBMS ARCHITECTURE Three Level Architecture of DBMS External or View Level Conceptual Level Internal or Physical Level Data Independence Physical DBMS Architecture Database Manager Database Users Database Administrator (DBA) Roles and Responsibilities of DBA Data Models The Relational Data Model The Network Data Model The Hierarchical Data Model MySQL Installation in Ubuntu


Limitations of File Based System

  • Separation and Isolation of Data
    • When the data is stored in separate files it becomes difficult to access.
  • Duplication of Data
    • Decentralised approach leads to uncontrolled duplication of data, which leads wastage of storage space, time and money.
  • Inconsistent Data
    • Changes made by different people for the same information differently or Entering a wrong data.
  • Data Dependence
    • The physical structure and storage of data files and records are defined in the application code.
    • Program Data Dependence.
  • Incompatible File Formats
    • The structure of the file embedded in application program totally dependent on the programming language. This incompatibility makes them difficult to process jointly.
  • Fixed Queries
    • Query or reports needed by the organization has to be developed by the application programmer.