QuestionQuestion

Transcribed TextTranscribed Text

Snake River Adventures gives its customers a unique opportunity to book a kayak trip with an instructor at the location of his/her choice. Use the table with the sample data below and the following business rules to build a database for the company. Identify the dependencies among the fields. Break the table into multiple tables, so that the database is in 3NF. You may need to add new fields. Build the Crow's Foot diagram that shows the following: Tables with PKs and FKs. Relationships and their connectivity and cardinality. Whether each relationships is strong or weak. TRIP_NAME DIFFICULTY MAP RIVER CUST_INAM CUST_INAM INSTRUCTO INSTR_EXP_ TRIP_DATE EXPERTISE E E R YEARS Wikl Water Adventure 2 (Intermediate) wvabmp Ohio 5/14/15 Adams Nicole 2 (Intermediate) Jackson 12 Wild Water 2 (Intermediate) wvabmp Ohio 5/20/15 Allen James 3 (Advanced) Moore 15 Adventure Red Rock 1 (Easy) m.bmp Allegheny 5/22/15 Adams Nicole 2 (Intermediate) Simmons 13 Rapids Clearwater 3 (Difficult) c.bmp Ohio 5/25/15 Marks Amy 4 (Expert) Moore 15 Clearwater 3 (Difficult) c.bmp Ohio 5/25/15 Alexander lirie 3 (Advanced) Jackson 12 Clearwater 3 (Difficult) c.bmp Ohio 5/30/15 Allen James 3 (Advanced) Jackson 12 Red Rock 1 (Easy) m.bmp Allegheny 6/1/16 Dobbins Brenda 1 (Beginner) Simmons 13 Rapids Business Rules: The company sells multiple trips. Each customer can book many trips, and each trip can be booked by many customers. The same customer can book only one trip on one day. Each booked trip has only one instructor. Each instructor can accompany many booked trips. Each river can be the base for many trips, but each trip is based only on one river. There are four possible levels of difficulty of the trips: 1 (Easy), 2 (Intermediate), 3 (Difficult), and 4 (Insane) There are four possible levels of customer expertize: 1 (Beginner), 2 (Intermediate), 3 (Advanced), and 4 (Expert)

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution.vsdx and Solution.docx.

    $45.00
    for this solution

    or FREE if you
    register a new account!

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Database Development Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats