Snake River Adventures gives its customers a chance to book a kayak trip with an instructor at the location of his/her choice. Use the table belor with the sample data and the following business rules to build a database for the company. 1. Identify the dependencies among the fields (10 points) 2. Break the table into multiple tables, putting the database in 3NF. You may need to add new fields, but cannot remove the existing data 120 points). 3. Build the Crow's Foot diagram that shows the following: a. Tables with Pks and FKs (10 points). b. Relationships and their connectivity and cardinality (10 points). c. Whether each relationships is strong or weak (10 points) THP NANE OFFICULTYM intermediate wa wa RIVER Clearwater als TRIP DATE 14/15 CUST NAME Adams CUST FNAME Nicole www.bmp Clearwater als EXPERTISE 2 Intermediate) Rad Rachapas 5/20/15 INSTRUCTOR Jackson INSTR EXP YEARS James asyl Det) ficut c.bing 3 (Advanced) Moore moeder 5/22/15 Cara 5/25/ES con Clearwater Falls W2515 Charwater Red River 01/16 Nicole Marks 2 intermediate) Alexander Amy Ene Debbins James Advanced) Advanced) 1 (Beginner) Simmons Moore Jackson ACRO Simmons Business Rules: The company sells multiple trips. Each customer can book many trips, and each trip can be booked by many customers (10 points). Each customer can book only one trip on a given day (10 points) Each booked trip has only one instructor. Each instructor can accompany many booked trips (5 points). Each river can be the base for many trips, but each trip is based only on one river (5 points) There are four possible levels of difficulty of the trips: 1 (Easyl. 2 (intermediatel. 3 (Difficult), and 4 (insane) (5 points) . There are four possible levels of customer expertize: 1 (Beginner), 2 (intermediate), 3 (Advanced), and 4 (Expert