Author Archives: Sumit Thakur - Page 8
Instances, Schema and Sub Schema In DBMS With Examples
Instances, Schema and Sub Schema In DBMS With Examples If you are interested in learning about Instances,Schema and Subschema in DBMS? You are absolutely at the right place. Instances in…
E-R Diagrams in DBMS: Components, Symbols, And Notations
E-R Diagrams in DBMS: Components, Symbols, And Notations: E-R diagram is the short form of “Entity-Relationship” diagram. An e-r diagram efficiently shows the relationships between various entities stored in a…
Hashing Algorithm And Its Techniques In DBMS
Hashing Algorithm And Its Techniques In DBMS: In a large database, data is stored at various locations. It becomes hectic and time-consuming when locating a specific type of data in…
9 Disadvantages and Limitations of Data Warehouse
9 Disadvantages and Limitations of Data Warehouse: Data warehouses aren’t regular databases as they are involved in the consolidation of data of several business systems which can be located at…
What is Deadlock in DBMS, Prevention and Detection
What is Deadlock in DBMS, Prevention and Detection + PDF: If you are running a multi-process Database management system, one of the most feared complications is the Deadlock. It often…
Data Independence in DBMS, its Types and Advantages
Data Independence in DBMS, its Types and Advantages: One of the vast advantages of DBMS is the data independence. In this article, we will discuss what is data independence in…
What is an Attribute and 11 types with Examples
What is an Attribute and types with Examples: Generally attribute explains the characteristics of an entity. In database management system (DBMS) it assigns a database component or database field. Attribute…
12 Applications of Data Warehouse
12 Applications of Data Warehouse: Data Warehouses owing to their potential have deep-rooted applications in every industry which use historical data for prediction, statistical analysis, and decision making. Listed below…
Data Warehouse Architecture With Diagram And PDF File
Data Warehouse Architecture With Diagram And PDF File: To understand the innumerable Data Warehousing concepts, get accustomed to its terminology, and solve problems by uncovering the various opportunities they present,…
Database Languages in DBMS: Explanation with Syntax
Database Languages in DBMS || Explanation with Syntax: To read data, update and store information in DBMS, some languages are used. Database languages in DBMS are given as below. DDL…