Indicate the changes (using the shorthand representation) that you would need to make to the original TAL Distributors database design in the event that the original Requirement 3 is changed as follows. For an item, store the items number, description, category, and price. In addition, for each storehouse in which the item is located, store the number of the store- house, the description of the storehouse, and the number of units of the item stored in the storehouse. Draw an E-R diagram for the new design.

REP CITY STATE POSTAL_CODE COMMISSION RATE $23,457.50 0.06 $41,317.00 0.08 $27,789.25 0.06 REP NUM LAST NAME FIRST NAME STREET Rafael 724 Vinca Dr. Grove 632 Liatris St. Fullton 1785 Tyler Ave. |Northfield 267 Oakley St. Conga 90092 90085 90098 9009 Cam Grade an Hui CA Sefton ane 0.00 0. CUSTOMER CUSTOMER_NUM CUSTOMER NAME STREET CITY STATE POSTAL CODE BALANCE CREDIT LIMIT REP NUM CA CA 90085 90092 90097 $1,210.25 $7,500.00 15 $575.00 $10,000.00 30 $7,500.00 45 28 Laketon St Toys Galore Brookings Direct 452 Columbus Dr. Grove Fullton 260 334 342 Magee St $2,345.75 The Everything Shop Congaree CA $879.25 $7,500.00 30 Johnsons Department Store 124 Main St Northfield CA 90098 440 3456 Central Ave. Fullton CA 90085 $345.00$5,000.00 45 Grove Historical Museum Store $5,025.75 502 586 665 Mesa Cards and More Almondton General Store Cricket Gift Sho Cress Store Unique Gifts Kline's All Season Gifts 167 Hale St 90104 $5,000.00 15 3345 Devon Ave. Almondton CA 90125 $3,456.75 $15,000.00 45 Grove 372 Oxford St 12 Rising Sun Ave. Congaree 786 Passmore St. Northfield CA 945 Gilham St 90092 90097 90098 90104 08 $678.90 $7,500.00 30 $4,234.60 $10,000.00 15 $124.75 $7,500.00 $2,475.99 $15,000.00 30 796 45 Mesa CA 82 Wildwood Ave. Fullton 35.7 500.00