Tech Tool:Database Software
Software Video:Database Tables
Ethan, your coworker, who unfortunately didn’t take an accounting information system course while studying accounting, wants you to help him to understand database anomalies. To help your coworker, build a table in MS Access with the following fields and data. Show Ethan deletion, update, and insertion anomalies.
Vendor No | Item Code | Vendor First Name | Vendor Last Name | Vendor City | Item Name | Item Description | Quantity | Unit Price |
120 | 23MX | Mark | Kwinsky | St. Louis | Accx 202 | Accelerator gas pedal | 3 | $60 |
234 | 10SP | Jim | Maranda | Chicago | SW6B | Switch pin | 12 | $7.20 |
127 | 10U2 | Mary | Vedette | Tulsa | 52SET | Under seat bar | 1 | $56 |
120 | PP10 | Mark | Kwinsky | St. Louis | BrkL | Left Brake | 1 | $150 |
120 | WX30 | Mark | Kwinsky | St. Louis | BrkR | Right Brake | 1 | $150 |
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.