What is removing inconsistencies from the data? June 16, 2022 Data redundancy occurs when the same piece of data exists in multiple places, whereas data inconsistency is when the same data exists in different… Continue Reading
What is data redundancy explain with example? June 16, 2022 Data redundancy occurs when the same piece of data exists in multiple places, whereas data inconsistency is when the same data exists in different… Continue Reading
What is the difference between file processing system and database management system? June 15, 2022 A File System is a collection of raw data files stored in the hard-drive, whereas a database is intended for easily organizing, storing and… Continue Reading
What is redundancy and inconsistency in DBMS? June 15, 2022 In information theory, redundancy measures the fractional difference between the entropy H(X) of an ensemble X, and its maximum possible value. . Informally, it… Continue Reading
What is DBMS how it is different from traditional file system? June 15, 2022 Traditional file processing systems include manual systems and also computer based file systems that were linked to particular application programs. This is the type… Continue Reading
What are the types of integrity? June 15, 2022 A person with integrity behaves ethically and does the right thing, even behind closed doors. For instance, informing a cashier that they gave you… Continue Reading
What do you mean by redundancy how this can be avoided in DBMS? June 15, 2022 Deletion of unused data For example, you moved your customer data into a new database but forgot to delete the same from the old… Continue Reading
What does the data dictionary identify in DBMS? June 15, 2022 A data dictionary contains metadata i.e data about the database. The data dictionary is very important as it contains information such as what is… Continue Reading
What are the three data management problems caused by data redundancy? June 15, 2022 Data Redundancy Disadvantages Allows for data corruption caused by damage or errors sustained during the process of storage and transfer of data across multiple… Continue Reading
How DBMS is better than traditional file system? June 15, 2022 Storing and retrieving of data can't be done efficiently in a file system. DBMS is efficient to use as there are a wide variety… Continue Reading