My Puzzles
Report bug
Collected Puzzles
User listed puzzles
Random Puzzle
Log In/Out

IPT Year 12 - RIS


Review of RDB design & some SQL

1     2   3        
5                 6  
8   9                
11           12      

1._____________ database management system (RDBMS)
4.this SQL clause states on what table this column or columns are found
5.___________ Integrity is the linking between tables using primary key & foreign key relationships
8.data ________ is where there is data duplication due to the same field being used in many tables
11.__________ keys (in the child table), which can be made up of one or more columns, are primary keys in another table
13.A database has _______ that include columns & rows
14.HAVING clause eliminates groups that do not satisfy its condition. However, the ________ clause eliminates rows before the GROUP BY and HAVING clauses are applied
2.this function returns the average within a group of rows
3.data that has a specific meaning in context
6.__________ functions group together data to produce a single result
7.____________ key, is a column or set of columns that uniquely identifies a row in a table
9.The use of DISTINCT in the SELECT list eliminates ___________ data
10.raw facts
12.an unknown value

Use the "Printable HTML" button to get a clean page, in either HTML or PDF, that you can use your browser's print button to print. This page won't have buttons or ads, just your puzzle. The PDF format allows the web site to know how large a printer page is, and the fonts are scaled to fill the page. The PDF takes awhile to generate. Don't panic!

Web armoredpenguin.com

Copyright information Privacy information Contact us Blog