Home

DBMS (Database Management System) Tutorials, Articles

DBMS – This section contains tutorials, articles on Database Management System (DBMS).

Latest Articles, Tutorials on DBMS

1. Introduction of Database Management system.
   Learn: In this article we are going to discuss about the Introduction of Database and Database Management System and its advantages.
2. Differences between DBMS and RDBMS?
   Here, we are going to learn what is DBMS and RDBMS and what are the differences between DBMS and RDBMS?
3. Introduction of ER Diagram/ER Modelling.
   Learn- In this article we study about the introduction of Entity Relationship Diagram(ER Diagram). We understand why we use ER Diagram in Database management system? What are the basic attribute of ER Model.
4. Conversion of ER Diagram to Relational Model.
   In this article we are going to discuss about the types of Relations, some basics of Relational model and how to convert a ER Diagram into Relational model?
5. Keys in Database Management System (DBMS).
   In this article, we are going to learn about Database Management System keys Super key, Candidate key, Primary key, Composite key, Compound key, Secondary or Alternative key, Non- key attribute, Non- prime attribute, Foreign key, Simple key, Artificial key.
6. SQL Joins Tutorial with Queries and Examples.
   SQL Join Tutorial - In this tutorial, we are going to learn about the SQL joins with Queries and Examples. There are two joins that we are going to discuss here - 1) Inner Join and 2) Outer Join and there sub parts.
7. File Oriented and Database Approach in DBMS.
   Learn: In this article, we are going to discuss about the File Processing System and database approach, some disadvantages of file oriented approach.
8. Functional Dependency and Attribute Closure in DBMS.
   Learn: In this article, we are going to discuss about the functional dependency and attributes closure In Database management system and check whether a functional dependency is valid or nor?

Latest DBMS Aptitude Questions and Answers

• Basic Database Management System (DBMS) Aptitude Questions and Answers.
• Basic Database Management System (DBMS) Aptitude Questions and Answers (2).
• Basic Database Management System (DBMS) Aptitude Questions and Answers (3).
• Basic Database Management System (DBMS) Aptitude Questions and Answers (4).