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