ADAIS (ACC 4071)
Data Management (Chapter 13)

Question 1

You are given two tables regarding a club database. Table 1 is driver and table 2 is racing car. Based on these two tables, provide answers for the following questions.

Table 1: Driver DriverID | Name | Hometown | Phone No | Joined Date | Gender | Club Fee | 0001 | AZLI | PUCHONG | 036196 | 12/01/2000 | M | $1,800 | 0002 | MAN | BANGI | 045555 | 05/04/2000 | M | $2,000 | 0003 | SARA | PUTRAJAYA | 038313 | 10/10/2001 | F | $3,500 | 0004 | LEE | BANGI | 031111 | 12/10/2001 | M | $5,500 | 0005 | JEMI | AMPANG | 052222 | 29/11/2002 | M | $3,750 |

Table 2: Racing Car DriverID | Brand | Plat No | Class | 0001 | TOYOTA | WEL122 | 2000 | 0002 | PROTON | WPA322 | 1500 | 0003 | PROTON | BKH101 | 1800 | 0004 | TOYOTA | BKA444 | 2000 | 0005 | HONDA | BKB211 | 1000 |

Required:

a) Redraw the tables by showing ONLY the attributes (fieldnames) and make a link to show relationship between the tables.

b) What is the most suitable data type for each field name in Table 1: Driver

c) List all the fields in Driver that meets the criteria club fee > $2,000.

d) List record(s) that fulfil the fields DriverID, Name, Phone No and brand “TOYOTA”.

e) What are FOUR main modules which are available in Microsoft Access 2007?

Question 2

a. Given the following tables: Table 1: Menu Item Code | Food Name | Selling Price (RM) | B10 | Beef burger | 10.00 | C10 | Chicken burger | 8.00 | F10 | Fish fillet | 7.00 | K10 | Ice cream | 4.00 | P10 | French fries | 5.00 | R10 | Coke | 3.50 | R11 | Juice | 4.00 | R12 | Coffee | 2.00 | V10 | Coleslaw | 4.00 | | | |

Table 2: Order Item Code | Quantity | B10 | 9 | C10 | 5 | F10 | 5 | P10 | 3 | R10 | 5 | R11 | 5 | V10 | 4 |

i. List all the fields in Menu that meets the criteria Selling Price > RM 4.00 ii. List all the fields in Menu that meets the criteria Selling Price between RM4.00 and RM6.00 (both inclusive) iii. List the fields Item Code, Food Name and Quantity equal to five (5).

b. For each of Field Name below, what is the most suitable field type? Field Name | Field type | Student Name | Text (done for you) | Student ID | | Age | | Gender | | Address | | Fees Paid | | Birth Date | | Number of Course | | Matric Number | |