Table 3: Pandu Jaya Customer CusilD Address CarlD CarName PlateNum Location RentHour Name KDH7722 Kedah PJJ1122 Penang F373 Kenari ABC3367 Perak KDH7722 Kedah RH6534 Perlis PJJ1122 Penang BAT123...

Subject - Fundamentals to Databse

Question 3

The
Table 3 below shows several records about rent car services by Pandu Jaya Sdn. Bhd.

Normalize the given
Table 3into:

(a) 1NF

(b) 2NF

Table 3: Pandu Jaya<br>Customer<br>CusilD<br>Address CarlD CarName PlateNum Location RentHour<br>Name<br>KDH7722 Kedah<br>PJJ1122 Penang<br>F373 Kenari ABC3367 Perak<br>KDH7722 Kedah<br>RH6534 Perlis<br>PJJ1122 Penang<br>BAT123 Selangor<br>А101<br>Myvi<br>B204 Kancil<br>001<br>Nordin<br>Jitra<br>2<br>4<br>002 Fatimah<br>Sik<br>A101<br>Myvi<br>3<br>003<br>Ismail Langkawi<br>С 192<br>Saga<br>B204 Kancil<br>2<br>D121<br>Waja<br>3<br>Baling B204 Kancil PJJ1122 Penang<br>Waja<br>E306 Persona JKK4311<br>004<br>Jamilah<br>D121<br>BAT123 Selangor<br>3<br>Johor<br>4<br>

Extracted text: Table 3: Pandu Jaya Customer CusilD Address CarlD CarName PlateNum Location RentHour Name KDH7722 Kedah PJJ1122 Penang F373 Kenari ABC3367 Perak KDH7722 Kedah RH6534 Perlis PJJ1122 Penang BAT123 Selangor А101 Myvi B204 Kancil 001 Nordin Jitra 2 4 002 Fatimah Sik A101 Myvi 3 003 Ismail Langkawi С 192 Saga B204 Kancil 2 D121 Waja 3 Baling B204 Kancil PJJ1122 Penang Waja E306 Persona JKK4311 004 Jamilah D121 BAT123 Selangor 3 Johor 4

Jun 04, 2022

SOLUTION.PDF

Table 3: Pandu Jaya Customer CusilD Address CarlD CarName PlateNum Location RentHour Name KDH7722 Kedah PJJ1122 Penang F373 Kenari ABC3367 Perak KDH7722 Kedah RH6534 Perlis PJJ1122 Penang BAT123...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment