Upload the prototype the assignment area part the deliverables
· Below you can find the "database" that Joe has put together with his limited data management knowledge, and your starting point.
You can assume that the quantities reflect packages and the prices are per item
| Invoice | CompanyName | Acct Balance | Acct Limit | Part | Quantity | Price |
|---|---|---|---|---|---|---|
| 87 | Mary’s IT Services | 5000 | 20000 | Bolt Nut |
50 40 |
10 20 |
| 72 | Mel’s Hotdogs | 7200 | 7200 | Bolt Screw |
100 45 |
10 30 |
| 57 | Brookings | 500 | 12000 | Screw Bolt |
60 65 |
30 10 |
| 67 | Parker’s | 1000 | 5000 | Nut | 70 | 20 |
| 3 | Action Computer’s | 1000 | 10000 | Screw | 40 | 30 |
| 7 | Kline’s | 8000 | 9999 | Bolt | 30 | 10 |
| 9 | John’s | 10000 | 30000 | Nail | 25 | 50 |
| 17 | Lee’s | 700 | 1000 | Bolt Nail |
75 120 |
10 50 |
| 19 | Al’s | 7000 | 7000 | Screw | 110 | 30 |
| 20 | Al’s | 7000 | 7000 | Nut | 90 | 20 |
