According to Brewer’s theorem (also called CAP theorem), any distributed data store (like a database) can only provide two of the following three guarantees: Consistency Availability Partition tolerance Now when it comes to pain tolerance, like a network partition failure, one of the following decisions need to be made: Cancel the operation => decrease the availability but ensure… Read More »
MySQL is a relational database management system (RDBMS) based on SQL- Structured Query Language and is free and open source.MySQL was created by MySQL AB, a Swedish company in 1995 which was later acquired by Sun Microsystems in 2008. MySQL is easy to use and fast. It is one of the most famous open source databases and it… Read More »
If a table has data redundancy and is not properly normalized, then it will be difficult to handle and update the database, without facing data loss. It will also eat up extra memory space and Insertion, Update and Deletion Anomalies are very frequent if database is not normalized. Normalization : Normalization is the process of minimizing redundancy from… Read More »
Database Management System (DBMS) is a system software for easy, efficient and reliable data processing and management. It can be used for: Creation of a database. Updating the database. Managing a database. Retrieval of information from the database. Need of DBMS : Database systems are basically developed for large amount of data. When dealing with huge amount of… Read More »
An entity relationship (ER) diagram, is a graphical representation of entities and their relationships to each other. ER modelling is based on two concepts: Entities, defined as tables that hold specific information (data) Relationships, defined as the associations or interactions between entities Recursive Relationship : When there is a relationship between two entities of the same type, it… Read More »
Database Management System (DBMS) is used to optimize and manage the storage and retrieval of data from databases. DBMS offers a systematic approach to manage databases and workloads accessing the databases. DBMS allows users to create their own databases as per their requirement. DBMS has various advantages and properties over traditional file system. In this article, we learn… Read More »
Database is a collection of inter-related data which helps in efficient retrieval, insertion and deletion of data from database and organizes the data in the form of tables, views, schemas, reports etc. We can break it like this DBMS = Database + Management System. Database Management System (DBMS) is used to optimize and manage the storage and retrieval… Read More »
