In this section the student is required to develop a technic

In this section, the student is required to develop a technical debate based on his/her understanding using available scientific literature. The answer to this question should not exceed three A4 Pages. In the traditional file systems, each file is independent of other file, and data in different files can be integrated only by writing individual program for each application. The database system can be defined as an organization of components that define and regulate the collection, storage, management and use of data in a database. In this part of the assignment, the student has to debate on whether traditional file systems are better than database system. Debate on \"Traditional File Systems are always faster than Database Systems\" The report should contain the following lines All Introduction to file system and database system A1.2 Explain merits and demerits of file system with examples A1.3 Explain merits and demerits of database system with examples A1.4 Justification for the stance taken and conclusion

Solution

File System: File system is a method and structure that an operating system uses to keep track of files on the disk. This is the way files are organised on the disk.

Database System:

Database system is a high level definition of structure and relationship between stored data, a database or databases, users and the hardware or operating system used for the storage

Merits of file system:

Demerits of File system:

Data Isolation: Because data are scattered in various files, and files may be in different formats, writing new application programs to retrieve the appropriate data is difficult.

Duplication of data – Redundant data

Dependency on application programs – Changing files would lead to change in application programs.

Merits of database system:

·         No redundant data – Redundancy removed by data normalization

·         Data Consistency and Integrity – data normalization takes care of it too

·         Secure – Each user has a different set of access

·         Privacy – Limited access

·         Easy access to data

·         Easy recovery

·         Flexible

Demerits of Database system:

·         DBMS implementation cost is high compared to the file system

·         Complexity: Database systems are complex to understand

·         Performance: Database systems are generic, making them suitable for various applications. However this feature affect their performance for some applications