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…
View Answer

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…
View Answer

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…
View Answer

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…
View Answer

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…
View Answer

What is Normalization in DBMS ?

Normalization is a process of breaking down the relations with a less attributes. Process of arranging the data in the database is called Normalization. To reduce the repetition from a…
View Answer