We can define a database link to be a connection between 2 databases or two or more physical databases. Database links plays an significant role in case of distributed databases. Link is Read more →
DBMS
8 postsAccording 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 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 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 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. 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 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 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. Read more →