Second Normal Form (2NF) is based on the concept of … functional dependency

If the proper subset of candidate key determines non-prime attribute, it is called … dependency

A relation that is in First Normal Form and every non-primary-key attribute is fully functionally dependent on the primary key, then the relation is in

Non-prime attribute COURSE_FEE is dependent on a proper subset of the candidate key, which is a partial dependency and so this relation is in 2NF

2NF tries to reduce the redundant data getting stored in memory.

A relation that is in First and Second Normal Form and in which no non-primary-key attribute is transitively dependent on the primary key, then it is in

If A->B and B->C are two FDs then A->C is called transitive dependency

The normalization of 2NF relations to 3NF involves the ....of transitive dependencies

is considered adequate for normal relational database design because most of the … tablesare free of insertion, update, and deletion anomalies

(2NF) :always ensures functional dependency preserving and lossless.

If it fails to satisfy the n normal form condition, the highest normal form will be …

… is a software used to manage data from a database.

DBMS provides many operations e.g. creating a database, storing in the database, updating an existing database, delete from the database.

… is a system that enables you to store, modify and retrieve data in an organized way. It also
provides security to the database

DBMS advantages

is referring to the accuracy or correctness of the data in database.

are basically Boolean expressions that must evaluate to TRUE

In any case, changes to the database are allowed to create an instance that violates any IC

We call these inherent model-based constraints

DBMS is managed by administrators who are determined to protect the database from all the
threats in the database environment