Databases and Normalisation
Authored by Ralph Ellis
Computers
12th Grade
Used 161+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
An entity is represented by what in a database?
Table
Row
Column
Cell
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
A record is represented by what in a database?
Table
Row
Column
Cell
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
An attribute is represented by what in a database?
Table
Row
Column
Cell
4.
MULTIPLE SELECT QUESTION
20 sec • 1 pt
Which of these are required for a relational database to meet 1st normal form?
Data must be atomic
No repeating groups of data
No repeating attributes
Sets of data must have a unique identifier
Must meet 2nd normal form
5.
MULTIPLE SELECT QUESTION
20 sec • 1 pt
Which of these are required for a relational database to meet 2nd normal form?
Must meet 1st normal form
All the non-key attributes must depend on the whole primary key
All the non-key attributes must not depend on another non-key attribute
Must meet 3rd normal form
6.
MULTIPLE SELECT QUESTION
20 sec • 1 pt
Which of these are required for a relational database to meet 3rd normal form?
Must meet 2nd normal form
All the non-key attributes must depend on another non-key attribute
All the non-key attributes must not depend on another non-key attribute
Must meet 4th normal form
7.
MULTIPLE SELECT QUESTION
20 sec • 1 pt
What is the purpose of normalisation?
Eliminate redundant data
Reduce data inconsistencies
Produce redundant data
Increase data inconsistencies
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
