A DBMS organises and manages structured data. MCA students should understand tables, relationships, keys, transactions, normalisation and query processing because database knowledge appears in many software roles. A good MCA study plan should leave time for both the theory behind DBMS and regular implementation practice. This point is specifically relevant to the DBMS aspect of MCA study. For this specific question about DBMS, the practical takeaway is to relate the concept to your own MCA learning goal.