Quiz: Second Normal Form - Removing Partial Dependencies
OCR H446 Computer Science Specification
Ready to start this lesson?
Sign in to track your progress. 12 steps including 10 interactive questions.
Sign In to Start Learning
Students also studied
Browse allSteps in this lesson (12)
Building on what you've learned about database normalisation, let's test your understanding of Second Normal Form (2NF) and removing partial dependencies!
What is the main requirement for a table to be in Second Normal Form (2NF)?
Start the lesson to answer this multiple choice question
Which of the following are characteristics of a partial dependency? (Select all that apply)
Start the lesson to answer this multi-select question
To remove partial dependencies, create a new table where the {{blank0}} becomes the primary key, and move the dependent {{blank1}} to this table.
Start the lesson to answer this fill in the blank question
Match the items on the left with their correct pairs on the right
Start the lesson to answer this matching question
Which of the following tables is NOT in Second Normal Form?
Start the lesson to answer this multiple choice question
Match the items on the left with their correct pairs on the right
Which step can help remove partial dependencies from a table?
Start the lesson to answer this multiple choice question
Which of the following are benefits of removing partial dependencies? (Select all that apply)
Start the lesson to answer this multi-select question
Second Normal Form requires a table to first be in {{blank0}} and to have {{blank1}} removed.
Start the lesson to answer this fill in the blank question
Match the items on the left with their correct pairs on the right
Start the lesson to answer this matching question
Why are partial dependencies problematic in a database?
Start the lesson to answer this multiple choice question
Want to Learn More?
Get personalised lessons, quizzes, and instant feedback from your AI tutor.
Explore More Topics