What is file system and advantage of DBMS over file system

Definition of File system & it's advantage of DBMS over file system

What is file system?

Ans/- A file system is a database system that allows us access to single file at a time. In a file system data is directly stored in set of file. It contains flat file that have no relation to other file.

Advantage of DBMS over file system:-

1) Data redundancy: - Data redundancy refers to the duplication of data that means each data may have a single copy. A file system can’t control redundancy of data. In DBMS data redundancy removed by using of data normalization.

2) Data inconsistency: - Data redundancy leads to data inconsistency. In DBMS data redundancy is taken care by data normalization and data in consistency also been taken care of as part of it.

3) Data isolation: - In file system data stored are in various file and files may be different formats. So it is very difficult to retrieved appropriate data. But DBMS data stored in single file so retrieved appropriate data more easy.

4) Atomicity issue: - Atomicity of an instruction refers to all or nothing which means either all operation in a transaction executes or none. It is difficult to achieve atomicity in file system not in DBMS.

5) Data dependency: - In file system changing in data is depended on application program but DBMS changing in data independent.

6) Easy recovery: - Since database system keeps the backup of data. It is easier to do a full recovery of data in case of a failure.

7) Flexible: - Database system is more flexible than file processing system

Comments

Important MCQ of RDBMS( Relational database management system)-FCST

Important MCQ of RDBMS 1. A RDBMS consists a collection of ? a. Tables b. Fields c. Records d. Keys ANS/- a. table 2. The term attribute refers to a ___________ of a table a. Record b. Tuple c. Column d. Key ans/- c. Column 3. In relational model, the row of table is known to be ? a. Relation b. Entity field c. Tuple d. Attribute ans/- C. Tuple 4. . Address field of a person should not be part of primary key, since it is likely to ? a. Dependent b. Too long c. Changed d. Not changed ans/- c. Changed 5. The relational model is concerned with ? a. Data structure and Data integrity b. Data Manipulation c. Both a and b d. None of these ans/- c. Both a and b 6. Which is the false statement from the following ? a. A veiw is a named derived table b. A name relation is variable c. A veiw is a named reation and is virtual d. None of these ans/- d. None of these 7. The union of primary key...

Short notes on database schema & database independence- computer science fundamentals tutorial

Database Schema & Data Independence PDF version of this post also available. to download the click the link given at the end of this post. Database Schema : - A database schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how relat ion among them are associated. Database schema formulates all the constrains that are to be applied on the data. A database schema defines its entities and the relationship among them. It contains descriptive details of the database which can be described by means of schema diagram. A database schema can be divided into two categories. I. Physical database schema : - this schema contain to the actual storage of data and its form of storage like files, indices etc. It defines how the data will be stored in a secondary storage. ...

C program to find factorial of number using function - FCST

C program to find factorial of number using function Problem description In this program take number as input & then it show the factorial of given number as output. Problem solution 1.take a number as input. 2.declare the void Fact(int) function globally if you want or declare the function prototype into the main() function. 3.after taking input call the function into main() . 4.then define the function definition. 5.after taking function definition for loop started in this function definition. 6. In for loop i=1 & fact=1 then fact=1. after this loop is continue and incremented by1 until the n is grater than equal to i. continuity of loop is depend on what number take as input . Program code: #include<stdio.h> void Fact(int);//function prototype declearation int i,fact=1;//global variable declearation int main() { int n; printf("\n enter the number:"); scanf("%d",&n); Fact(n);//function call } //func...

Fundamentals of computer science tutorial (FCST)

Search This Blog