Match the LIST-I with LIST-II

LIST - I		LIST - II
A.	Project Join Normal Form	I.	Concurrency
B.	The lost update problem	II.	Fifth Normal Form
C.	Discretionary Access Control	III.	SQL
D.	Data manipulation Language	IV.	Security

Choose the correct answer from the options given below:

The correct answer is Option 1.

Key Points

• Project Join Normal Form (PJNF) is associated with Fifth Normal Form (II).
  • Fifth Normal Form (5NF), also known as PJNF, is used to eliminate redundancy in relational databases.
• The lost update problem is associated with Concurrency (I).
  • The lost update problem occurs when multiple transactions are updating the same data concurrently, leading to incorrect or lost updates.
• Discretionary Access Control (DAC) is associated with Security (IV).
  • Discretionary Access Control is a type of access control where the owner of the data or resource determines who can access it, enhancing security.
• Data Manipulation Language (DML) is associated with SQL (III).
  • DML is a subset of SQL that includes commands like SELECT, INSERT, UPDATE, and DELETE, used for data manipulation in databases.

Additional Information

• Understanding the relationships between database concepts and their applications is essential for database management and security.
• Ensuring proper normalization and access control mechanisms are crucial for maintaining data integrity and security.