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

IPT Year 12 - RIS

ELKE SCHNEIDER

Review of RDB design & some SQL

1     2   3        
   
  4      
 
5                 6  
7    
8   9                
       
       
      10  
11           12      
         
    13        
   
14        

Across
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
Down
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!




Google
 
Web armoredpenguin.com

Copyright information Privacy information Contact us Blog