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 specified system can defined using this model. Conceptual design for…
Month: June 2022
16 posts
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 processor and huge memory size and…
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 contains multiple keys, and keys which…
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 rows and column within a table. So data and…
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 commands that can be reused again and…
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 software application that is used for creating, accessing and…
What are Database Management Tools ?
phpMyAdmin: PhpMyAdmin is the most popular open-source web-based database management tool by MySQL. Using phpMyAdmin we can create or manage databases, tables, DB users, optimize and check errors in your…
What is DBMS Utilities ?
Data Loading Utility: Data loading utility helps to load data from an external format without writing programs. Backup utility: In case of crashes and disasters this utility helps to take…
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 navigational form Tables have an identifier called…
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 the entire data from rows from the table.…
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 be retrived from two or more tables we…
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 to lack of data is called as Insertion Anomaly. Deletion…
What is database architecture in DBMS ?
Data Base Architecture: A database architecture is represented as DBMS Design. Helps to design, develop, implement and maintain the database management system. Database system that can be divided into individual…
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 way using these properties. Atomicity: Atomicity is based on the principle…
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 Consistency within the database can be achieved. Database design is more…
What is tier-3 architecture in DBMS ?
This architecture divides the entire system into a three inter related and independent modules. Physical Level: In data, information about the location of database objects in the data store…
