Database Normalization
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.
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 employee table, what is the most appropriate PK?
PassportNo
DepartmentNo
EmployeeId
Dob
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
{"name":"Database Normalization", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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.","img":"https:/images/course6.png"}