What is ER Model in DBMS ?
ER stands for Entity-Relationship model. It is a high level data model. If any data elements or relationship of any...
What are the disadvantages of DBMS ?
High Cost Disadvantage of DBMS is its high cost of software and hardware. For users to use a DBMS they require a high speed...
Different types of Keys in DBMS
There are 7 keys in DBMS Primary Key Key which is used to identify one and only instance of entity uniquely. An Enity can...
What are the data models in DBMS ?
There are 4 data models in DBMS Relational Data Model Edgar F.Codd described the model in 1969. Data are designed using...
Difference between Trigger and Stored procedure in DBMS
Triggers Stored Procedures A Trigger is created in such a way that it fires when a specific event occurs. A group of sql...
Difference between DBMS and File System
File System DBMS A software that manages and organizes the file in storage medium is called as file system. DBMS is ...
What are Database Management Tools ?
phpMyAdmin: PhpMyAdmin is the most popular open-source web-based database management tool by MySQL. Using phpMyAdmin we can...
What is DBMS Utilities ?
Data Loading Utility: Data loading utility helps to load data from an external format without writing programs. Backup...
Difference between RDBMS and DBMS ?
DBMS RDBMS Data is stored in file format Data is stored in table format. Data is stored either in a hierarchical form or...
Difference between Delete and Truncate
Delete Truncate Used to delete rows from a table based on the condition provided on the where clause. Used to delete...
What is joins in DBMS ?
DBMS join is a binary operation that allows to combine join product and selecting in one single statement. If data needs to...
What is modification anomalies in DBMS ?
There are 3 types of Data Modification Anomalies: Insertion Anomaly: When one cannot insert a tuple into a relationship due...
What is database architecture in DBMS ?
Data Base Architecture: A database architecture is represented as DBMS Design. Helps to design, develop, implement and...
What is the concept of ACID properties in DBMS ?
ACID stands for Atomicity, Consisency, Isolation, and Durbility property. Multiple users can share data in a safe and secure...
What is the advantages of Normalization in Database ?
Repetition of data can be reduced by using Normalization. Data base can be organized well in Normalization. Data...
What is tier-3 architecture in DBMS ?
This architecture divides the entire system into a three inter related and independent modules. Physical Level: In...
