Create an ERD diagram for the Colonial Adventures database, make sure to add the primary and foreign key dependencies. Using Microsoft Visio or similar tool for this.

order 51613, and what is t introduction to T a & Lock up the CUSTOMER NUM value in the ORDERS table for iradey is CISTOMER NUM vale of 386. Using the REP NUM value, Rta Colonial Adventure obtain answers to t In running the guides, trips, custo W hat is the name of the customer that placed order number 51613 and obesio the number 3ss. Then find the eustommer in the C of the rep in the REP table) name of the rop a Johnsces Papartneet Store is the eustomer, and M the CUSTOMER table wio J which is 30, find Adventure Tours. Colonial Adventur postal code, telep Q & A all tems that appear in order 51617. For each item, give the hem number NLS9, description: Wood Block Set (62 piece), number ondered 3, and quoted price $116.95. (Look up each ORDER LINE table umber 811599. Also, item number: TW35, description:eerdeed row on which and gaoted price: the onder number is 51617. Each of these rows contains an item number, the W ondered, and the quoted price. Use the item number to look up the corres description in the ITEM table.) corresponding iten FIGURE 1-4 Q & A Figure number that the trip's sta (in miles), th Question: Why is the QUOTED PRICE column in the ORDER LINE table? Can't use the item number and look up the price in the ITEM table? Answer: If the QUOTED-PRICE column did not appear in the ORDER-LINE table, you wouald need to obeain the price for an item on an order line by looking up the price in dh ITEM table. Altbough this approach is reasonable, it prevents TAL Distributors from you just t customers for the same item. Because TAL Distributors wants the flexibility to quote and charge different prices to different custo- mers, the QUOTED PRICE column is included in the ORDER LINE table. If you examine the ORDER LINE table, you will see cases in which the quoted price matches the actual price in the ITEM table and cases in which it differs. For example, in order number 51608, Toys Galore bought five Wood Block Sets (48 piece), and TAL Distributors charged only 88699 per set, and not the regular price of 889.49 THE COLONIAL ADVENTURE TOURS DATABASE Colonial Adventure Tours is a small business that ordanizes day-long, guided trips oi Endland. Like the management of TAL Distributors, Colonial Adventure Tours to store its data in a database. The company wants to achieve the wants to ensure that its data is current and accurate. In addition, the m nf