ist any four disadvantages of file system approach over database approach.
Question
ist any four disadvantages of file system approach over database approach.
Solution
-
Data Redundancy and Inconsistency: In file system approach, the same data may be duplicated in several files which leads to data redundancy. This redundancy can lead to inconsistency in data, i.e., the same data may have different values in different files.
-
Difficulty in Accessing Data: In file system approach, it is difficult to access data as it does not support querying (SQL). To access data, the application should be written to perform the operations on the data.
-
Data Isolation: Since data is scattered in various files, and files may be in different formats, writing an application to retrieve data becomes more complex.
-
Integrity Problems: The file system approach does not have any mechanism to enforce integrity constraints. Therefore, the application has to implement the integrity constraints while processing the data.
Similar Questions
List any four disadvantages of file system approach over database approach. Differentiate between physical and logical data independence. What is the difference between DROP and DELETE command? What are different Integrity Constraints?List all prime and non-prime attributes In Relation R(A,B,C,D,E) with FD set F = {AB→C, B→E, C→D}. Explain MVD with the help of suitable example. Discuss Consistency and Isolation property of a transaction. Draw a state diagram and discuss the typical states that a transaction goes through during execution. List the four functions of DBA. When a relation set is called a recursive relationship set? What do you mean by currency with respect to database?What is Relational Calculus? What is Equi-Join in database? What is a CLAUSE in terms of SQL? When is a transaction Rolled Back? List the various levels of locking?Discuss Conservative 2PL and Strict 2PL.Describe how view serializability is related to conflict serializability.A database is being constructed to keep track of the teams and games of a sport league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of players participating in each game for each team, the positions they play in that game and the result of the game. Design an E-R schema diagram for this application. Map the E-R diagram into relational model.What are Joins? Discuss all types of Joins with the help of suitable examples.14:50
Describe any four disadvantages of the file-based systems (4 Marks)(b) Discuss the five components of the database management system (5 Marks)(c) Identify the roles of the following people(i) Database designer (1 Mark)(ii) Database administrator (1 Mark)(iii) Database user (1 mark)(d) With respect to information management, compare the following concepts;(i) Instance and schema (4 Marks)(ii) Tuple and attribute (4 Marks)(iii) File system and DBMS (4 Marks)(e) There are three default database schemas that found in SQL namely informationschema, mysql and test. Discuss each showing its role in DBMS. (6 Marks)
Which of the following is NOT the limitation or disadvantage of File System Data Management?a.Security features likely to be inadequateb.Increased cost due to high requirement of hardware and softwarec.Difficult to make changes to existing structuresd.Requires extensive programming
Explain four disadvantages of flat file approach over relational database approach in respect to data management.
Which of these is/are not the advantage(s) of DBMS over file system A provides redundancy issuesB provides safetyC provides multiple viewsD data inconsistency
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.