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"}
More Quizzes
Database SQL Quiz8
1587
DBMS-DIAGNOSTIC TEST -1
1050
Comic Book Day
1260
DISCOVER THE BEST ONLINE SIDE HUSTLES FOR YOU
420
Free 5.03: Probability of Events
201025872
National Mulligan Day Trivia - Test Your Golf Knowledge
201027692
Free 2.12 Unit Test: Theme & Characters - Part 1
201024957
Which Bath and Body Works Sanitizer Suits You Best?
201032486
Which Hair Color Looks Best on Me? Take the Free!
201027692
Find Your Camp Rock Character: Free Personality!
201029199
Free Investing Knowledge Assessment
201026114
Can I Sing: Discover Your True Vocal Talent!
201031296