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

Minterm and maxterm in Digital logic design - Computer Science fundamentals tutorial

Minterm and Maxterm First thing to know before we proceed towards what is ‘minterm’ and ‘maxterm’ we have to know the sum of product and product of sum. Sum of product: - The logical sum of two or more logical product term is called sum of products expression. It is basically an OR operation of AND operated variables such as Y = AB+BC+ABC Product of Sum: - The logical product of two or more logical sum term is called product of sums expressions. It is basically an AND operation of OR operated variables such as Y = (A+B).(B+C).(A+B+C) Minterm: - Product term containing all the k variables of the functions is either complimented or uncomplimented form is Minterm. Canonical form of sum of product: - It is defined as the logical sum of all the minterms derived from the rows of a truth table for which value of the function is 1. It is called a minterm canonical form. The canonical sum of product expression can be given in a compact form by lis...

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...

Solve-write C program to find grade of student by using nested else-if statement

C program to find grade of student by using nested else-if statement Problem Description This program take input as your number then show your grade. Problem Solution 1. enter your marks as input. 2. then check your marks with 'If' block's condition. if it satisfied then show your grade as output. 3. if it not satisfied then it checks with all else-if block's condition repeatedly. 4. print the grade according to your given marks as input and exit. Program codes:- #include<stdio.h> main() { int n; printf("\n enter the marks:"); scanf("%d",&n); if(n>89) printf("O"); else if(n>79) printf("E"); else if(n>69) printf("A"); else if(n>59) printf("B"); else if(n>49) printf("C"); else if(n>39) printf("D"); else printf("F"); } Program explanation:- 1. enter your marks. for example we take 70 . ...

Fundamentals of computer science tutorial (FCST)

Search This Blog