June 18th

HOMEWORK AJT DUE 22nd June

Ensure that you have complete the SQL course up to DELETE

DATA VALIDATION

On BBC Bite Size complete the following:

http://www.bbc.co.uk/education/guides/zdvrd2p/revision

Watch the video

http://www.bbc.co.uk/education/guides/zdvrd2p/activity

Complete the test

http://www.bbc.co.uk/education/guides/zdvrd2p/activity

n.b. Repeat until you get all correct – note your answers.

As a reply to this post provide definitions with examples  of the following:

- Presence check

-  Range Check

- Picture check 

-  Type check

ALSO, IF YOU HAVE NOT ALREADY COMPLETED THE CHALLENGES FROM TODAY'S LESSON THESE MUST BE DONE FOR HOMEWORK.

STARTER

• Express 11001101 as DENARY
•   Express 233 as BINARY
•     Express 233 as HEX
•     Express 167 as HEX

SHOW YOUR WORKING

1.       First let’s finish our notes from Teach-ICT.com

http://www.teach-ict.com/as_as_computing/ocr/H447/F453/3_3_9/sqlintro/miniweb/pg5.htm

CHALLENGE 1

The two tables Product and Supplier form a relational database used by a shoe shop.

(a)    State the primary key of the Supplier table and justify your choice.  (2) 

(b)   List the results of executing the following SQL query on the database above. (4)

SELECT Product.Name, Product.Quantity, Supplier.PostCode

FROM Product, Supplier WHERE Product.Quantity > 40 AND Supplier.Name = ‘Trainers4Us’

AND Product.SupplierCode = Supplier.SupplierCode 

(c)    Write an SQL statement to add the following data to the Product table:  (3)

444AA  Slippers  6.99  32  100  

CHALLENGE 2

(a)    Look at the Products table. Write an SQL statement that orders the products alphabetically by supplier name (3)

(b)   Look at the Products table. Write an SQL statement that orders the by the quantity with the largest first? (3)