Primary Key fields (30/08/2012)

Download and save the database in the link below in your desktop and answer the questions following in your note book

http://www.teach-ict.com/ecdl/module_5/resources/dvds/dvds.mdb

1. Name all the number of tables in dvds database above.
2. Which field is the primary key field in the Customers table?
3. Which field is the primary key field in the DVDs table?
4. Which field is the primary key field in the Rentals table?
5. How many records are in the customers table?
6. How many records are in the DVD table?
7. How many records are in the Rental table?
8. What is the field length for "Intial" and "Sex" fields in customers' database?
9. What field length would you recommend for "Intial" and "Sex'' fields in the customers database?
10. What are the field sizes for "Title", "Genre","Rating","Lead Actor" fields in the DVDs table?

Online quiz
Attempt the following online activities

1. http://teach-ict.com/xml/finished/709/qopt.htm

2. http://teach-ict.com/gcse/software/db/starters_plenaries/gcsedatayesno.htm

3. http://teach-ict.com/ks3_old/unit7_5/starters/wordsearchMOD2.html

Data Bank Unit: Task 2

Create a simple library database that can be used by the librarian to organize book records.

The following are the expected field names in the database

• Title 
• Book number
• Author
• Year Published
• Publisher
• Category
• Image of the book
• Condition of book (Good or Bad) 

For homework

Answer question 1-9 only in the link below

http://teach-ict.com/gcse/software/db/tasks/worksheet1.doc 

Print and stick the work in your note book.