Database Normalization

An informative illustration showing database tables with emphasized primary keys, dependencies, and normalization concepts, featuring a professional look.

Master Database Normalization

Test your knowledge about database normalization with this comprehensive quiz designed for students and professionals alike. Dive into various aspects of primary keys, dependencies, and normalization rules.

Each question is crafted to challenge your understanding, with detailed scenarios and options to choose from:

Identify appropriate primary keys.
Understand partial and transitive dependencies.
Apply normalization techniques effectively.

9 Questions2 MinutesCreated by NormalizingData101

Given the following attributes available for Student table:

StudentId, PassprtNo, DOB, PhoneNo, Name

What is the most appropriate PK?

PassportNo

PassportNo & StudentId (composite PK)

StudentId

Name

With respect to the below table, what is the most appropriate PK?

EmployeeId

DepartmentId

EmployeeId & departmentId

EmployeeId & socMediaId

If the PK for the below table is employeeId and socMediaId,all the attributes that are partially dependent on socMediaId are

DepartmentId, departmentName

SocMediaApp

EmpolyeeName

DepartmentId, depatmentName

If the PK for the below table is employeeId and socMediaId,all the attributes that are partially dependent on employeeId are

Name, dob, departmentId, departmentName

EmployeeName, dob, socMediaApId, socMedApp

SocMedAppId, socMediaApp

None of these answers are correct

If the PK for the below table is employeeId and socMediaId, a transitive dependency (TD) exists between:

EmployeeId and name

DepartmentId and deparmentName

SocMediaId and socMedApp

None of these answers are correct

A transitive dependency exists when:

A non-key attribute depends on a key attribute

When a non-key attribute depends on a non-key attribute

When non key attribute partially depends on the primary key

None of these answers are correct

If the PK for the below table is employeeId and socMediaId, only attribute that is fully dependant on the PK is:

Name

SocMedAp

Followers

None of the answers are correct

Database Normalization

Master Database Normalization

More Quizzes