Game+Console+Stocks+-+Access

Console Supplies UK Ltd supply video games consoles to shops around the UK. They keep a database of all of the stores which they distribute to, and a separate database of each console which they have sent out.

> Create a portal between Consoles and Game Shops
 * 1) In order to run effective queries on the databases, the databases need to be joined using a portal.

Open the database Consoles and answer the questions below. Make sure that you note the query you will be using


 * 1) Which shops offer a Nintendo DSi with Stylus Pack?
 * 2) How many Xbox's does David Harris' store have in stock?
 * 3) Console Supplies UK need to recall any new Playstation 3's with a serial number containing X1. Which manager(s) should they call?
 * 4) Do any shops sell used Sony Playstion 3's, and also sell board games?
 * 5) Console Supplies UK want to speak to any managers who are selling new Nintendo Wii's for under £150. Who are they?