ISDD+Keys

media type="custom" key="28065233"

Questions

1. Which of the following would make suitable primary keys in a table?
 * National Insurance Number in the table EMPLOYEE
 * Date of Birth in the table EMPLOYEE
 * Serial Number in the table IPAD STOCK
 * Product Name in the table PRODUCTS SOLD
 * Club Nickname in the table FOOTBALL CLUBS
 * Racehorse Name in the table RACEHORSES
 * Driving Licence Number in the table DRIVERS
 * Driving Licence Number in the table EMPLOYEES

2 (a) Choose a suitable primary key for the following table:

(b) Download the Books database file and change the primary key to the one you chose in part (a) above

3. Choose a suitable primary key for the following table:

4. Choose a suitable primary key for the following table:

5. Choose a suitable compound key for the following table, and explain why a compound key is needed:

6. The Edinburgh Movie Store keep a record of all of their DVDs in a database. (a) Explain why this database needs a surrogate key (b) Copy and complete the table, adding in your own surrogate key

7 (a) The Kennel Club maintain a database of registered dogs, split into two relational tables as shown below

In order to join the tables, Owner ID should be a foreign key in the dog table.

Copy the dog table and add a foreign key Owner ID. Use the details below to fill out the fields:
 * Mrs Kettle owns Rudi
 * Mr McBride owns Jess and Harry
 * Mrs Bain owns Scamp
 * Mrs James owns Goldie

(b) (i) Create a new database in Microsoft Access, and add 2 tables Owner and Dog. (ii) Make sure that Owner ID and Dog ID are the primary keys in each table (iii) Link the 2 tables by making Owner ID a foreign key in the Dog table