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. Architecture of Database Management System.
   In this article, we are going to discuss about the Architecture of database management system, components of DBMS and also the 3 level architecture of database management system.
4. Normalization in Database Management System.
   Learn: In this article, we are going to discuss the introduction of normalization different types of normal form and also discuss how to find the highest normal form in relation and types of Anomalies in Database management system.
5. Different types of Data Model in DBMS.
   In this is article, we are going to discuss about the Introduction of data model and different types of data model used in database management system (DBMS).
6. 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.
7. 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?
8. 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.
9. 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.
10. 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.
11. 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?
12. Concurrency and problem due to concurrency in DBMS.
    Learn: In this article, we are going to discuss about concurrency some advantages of concurrency and problems due to concurrency and basics about schedule in Database management system.
13. Transaction in Database Management System.
    In this article we are going to discuss about the introduction of transaction and properties of transaction and transaction states in Database management system.
14. Classification of Schedules in DBMS.
    In this article, we are going to discuss about the schedules, classification of schedules and try to find that whether the schedule is consistent or not?

DBMS Interview Questions

1. Top 50 DBMS Interview Questions and Answers.

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).