After successfully completing your first database project, youre now off to an illustrious career as a database consultant! Linus, the owner of Hush Puppy Training refers his friend, Pigpen, to you for his data problem. Pigpen owns a catering company, Northwind Catering Limited, in London and wants to convert the data from his hand-written invoices into a relational database. Below is an example of the invoices Pigpen is using for his business.

How would you set up your database and the tables therein for Pigpen?

NorthWind Catering ? INVOICE No : 10248 INVOICE DATE:7/4/99!o CUST ACCNT NO: AROUT NAME: AROUND THE HORN REGION: POSTAL CODE: WA1 1DP COUNTRY: UK O ADDRESS: 120 HANOVER SQ CITY: LONDON SHIPPER: SPEEDY EXPRESS SALESMAN: 5 TELEPHONE: (503) 555-9831 UNIT PRICE DISCNT QTY EXT o 14. 00| 0 . O0 12 168 . ???? 9.80 0.00 1098.00 o O PRODUCT DESCRIPTION o11 0142 QUESO CABRLES SINGAPOREAN HAKKIEN FRIED MEE HOSARELLA DI GIOVANNI 72 34.80 0.00 5 174.00 TOTAL AMT: $440.00 0 FREIGHT: $ 32.38 INVOICE AMT: $472. 38 : o NorthWind Catering ? INVOICE No : 10248 INVOICE DATE:7/4/99!o CUST ACCNT NO: AROUT NAME: AROUND THE HORN REGION: POSTAL CODE: WA1 1DP COUNTRY: UK O ADDRESS: 120 HANOVER SQ CITY: LONDON SHIPPER: SPEEDY EXPRESS SALESMAN: 5 TELEPHONE: (503) 555-9831 UNIT PRICE DISCNT QTY EXT o 14. 00| 0 . O0 12 168 . ???? 9.80 0.00 1098.00 o O PRODUCT DESCRIPTION o11 0142 QUESO CABRLES SINGAPOREAN HAKKIEN FRIED MEE HOSARELLA DI GIOVANNI 72 34.80 0.00 5 174.00 TOTAL AMT: $440.00 0 FREIGHT: $ 32.38 INVOICE AMT: $472. 38 : o