typing
oceanqueen
CopyofDatabaseActivity02-InstructionsforDVDdatabasev1.docxDATABASE ACTIVITY 2
1. Create a database called DVD.
2. Create a database table called DVD Collection.
3. Enter the following records in the table.
|
Field Name |
Field Type |
Field size |
|
Movie Name |
Text |
80 |
|
DVD Number |
Number |
|
|
Category |
Text |
30 |
|
Loaned to |
Text |
35 |
|
Date |
Date/Time |
|
|
Contact Number |
Text |
8 |
|
DVD Number |
Movie Name |
Category |
Loaned to |
Date |
Contact Number |
|
27691 |
The lord of the rings: the fellowship of the ring |
Sci-fi |
Michelle Jones |
26.06.03 |
437-2469 |
|
1622403 |
Pretty Woman |
Romance Comedy |
Mum |
10.10.02 |
868-home |
|
261943 |
Training Day |
Action Drama |
Dad |
11.02.03 |
452-6325 |
|
264360 |
Shrek |
Cartoon |
Shanna’s Kids |
02.06.03 |
639-5268 |
|
243869 |
Monster’s Ball |
Drama |
Sister Shari |
8.05.03 |
456-2597 |
|
261440 |
Two can play that game |
Comedy |
David |
10.01.03 |
756-9532 |
|
269900 |
The Matrix |
Sci-fi |
Kamika |
4.12.02 |
568-9547 |
|
269901 |
The Matrix Reloaded |
Sci-fi |
Kamika |
4.6.02 |
568-9547 |
|
060329 |
The English Patient |
Drama |
Ms Divica Paul |
5.5.03 |
664-5674 |
|
306269 |
Spy Kids |
Sci-fi/ Adventure Children |
Shari’s kids |
20.02.03 |
668-9547 |
|
270949 |
The Others |
Thriller Suspense |
Damian |
5.6.03 |
269-5849 |
4. The Training Day record has the incorrect ID number; change the number to 261953.
5. Ms. Divica Paul name is incorrectly spelt; change the spelling to Devica.
6. Spy Kids was not borrowed by Shari’s kids - it was borrowed by Kamika, on the same day she borrowed The Matrix Reloaded; change the record to reflect this.
