← All printables
QCE Digital Solutions Unit 2 · Modules 305–336

Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.

A free printable QCE Digital Solutions Unit 2 crossword with 10 clues, built from the key terms of Prototype Data Solutions (Modules 305–336) — Insert, update and delete anomalies, First normal form (1NF) (Prototype Data Solutions), Second normal form (2NF) (Prototype Data Solutions), Third normal form (3NF) (Prototype Data Solutions), Evaluating a database against the normal forms, Modifying a database to 3NF and more. Print it or save it as a PDF — the answer key starts on its own page. No login needed.

QCE Digital Solutions Unit 2 Crossword: Prototype Data Solutions (Modules 305–336)

Name:
Date:
Class:
✎

Crossword

Read each clue and write the matching term in the grid. Numbers in brackets show the letters in each word.

1
2
3
4
5
6
7
8
9

Across

  1. 1. First normal form: every field holds one atomic value, with no repeating groups or multi-valued fields, and the table has a primary key to identify each row. (3)
  2. 6. Test a table against 1NF, then 2NF, then 3NF, naming each dependency problem found (repeating group, partial or transitive) and backing it up with an example row. Word 2 of: normal ____ _____ (4)
  3. 8. Word 3 of the term in 6 Across: normal ____ _____ (5)
  4. 9. Word 3 of the term in 2 Down: IN (______ _________ ____ _______) (9)

Down

  1. 2. A sub-query is a ______ inside brackets in a WHERE clause. It returns a list of values, and IN keeps only the rows whose value is in that list. NOT IN keeps the rows that are not in it. Word 4 of: IN (______ _________ ____ _______) (4)
  2. 3. Second normal form: a table is in 1NF and no non-key field depends on only part of a composite primary key. Removing partial dependencies means each field relies on the whole key. (3)
  3. 4. Word 2 of the term in 2 Down: IN (______ _________ ____ _______) (6)
  4. 5. A sub-query in brackets returns one value, like the average. The outer WHERE compares each row's field to it. MIN or MAX work too. Word 2 of: WHERE ____ > (______ AVG(____) ____ _______) (4)
  5. 7. Word 5 of the term in 2 Down: IN (______ _________ ____ _______) (7)
  6. 8. Saves a SELECT query under a name so you can query it like a table. A view stores the query, not a copy of the data, so it always shows current rows. Remove it with DROP VIEW. Word 1 of: ______ VIEW (6)

Answer Key

QCE Digital Solutions Unit 2 · Modules 305–336
11
N
2F
32
R
4S
5M
N
O
E
A
6F
O
7R
M
L
R
E
8C
H
E
C
K
S
R
C
9S
T
U
D
E
N
T
I
D
L
A
T
T
S
E
Across
11NF — First normal form: every field holds one atomic value, with no repeating groups or multi-valued fields, and the table has a primary key to identify each row.
6FORM — Test a table against 1NF, then 2NF, then 3NF, naming each dependency problem found (repeating group, partial or transitive) and backing it up with an example row. Word 2 of: normal ____ _____
8CHECK — Word 3 of the term in 6 Across: normal ____ _____
9STUDENTID — Word 3 of the term in 2 Down: IN (______ _________ ____ _______)
Down
2FROM — A sub-query is a ______ inside brackets in a WHERE clause. It returns a list of values, and IN keeps only the rows whose value is in that list. NOT IN keeps the rows that are not in it. Word 4 of: IN (______ _________ ____ _______)
32NF — Second normal form: a table is in 1NF and no non-key field depends on only part of a composite primary key. Removing partial dependencies means each field relies on the whole key.
4SELECT — Word 2 of the term in 2 Down: IN (______ _________ ____ _______)
5MARK — A sub-query in brackets returns one value, like the average. The outer WHERE compares each row's field to it. MIN or MAX work too. Word 2 of: WHERE ____ > (______ AVG(____) ____ _______)
7RESULTS — Word 5 of the term in 2 Down: IN (______ _________ ____ _______)
8CREATE — Saves a SELECT query under a name so you can query it like a table. A view stores the query, not a copy of the data, so it always shows current rows. Remove it with DROP VIEW. Word 1 of: ______ VIEW

Modules this crossword covers

Every module has its own free printable worksheet with an answer key, and students can practise the same terms interactively on Cloodit.

Part of: QCE Digital Solutions Unit 2 — Prototype Data Solutions

More QCE Digital Solutions Unit 2 printables

This printable is free — no login needed.

Make a free class, give it a journey, and you also get:

Create a free teacher account →

No credit card. No setup fee. Make a class and invite students in under three minutes.