Solution

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.