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
1586
DBMS-DIAGNOSTIC TEST -1
1050
DBMS
1050
DBMS
8430
Database Design Quiz
10517
Introduction to database concept
1050
QUIZ: Relation Database Model
6329
PROGRAMMING IN MY SQL
211035
Master Your SQL Skills
201055
DB SEQ
84420
Sustav za upravljanje bazom podataka (34. - 70.)
371866
Brie's Bonus Bonanza Quiz
432224