2 points). Kayak Adventures gives its customers a uniqu

Added on 2019-09-18

1 Pages344 Words136 Views

(2 points)Kayak Adventures gives its customers a unique opportunity to book a kayak trip with an instructor at thelocation of his/her choice. Use the table with the sample data below and the following business rules to build a database for the company.1.Break the table into multiple tables, so that the database is in 3NF. You may need to add new fields.2.Identify the tables with PKs and FKs.TRIP_NAMEDIFFICULTYMAPRIVERTRIP_DATECUST_LNAMECUST_FNAMEEXPERTISEINSTRUCTORINSTR_EXP_YEARSWild Water Adventure2 (Intermediate)wva.bmpOhio5/14/15AdamsNicole2 (Intermediate)Jackson12Wild Water Adventure2 (Intermediate)wva.bmpOhio5/20/15AllenJames3 (Advanced)Moore15Red Rock Rapids1 (Easy)rrr.bmpAllegheny5/22/15AdamsNicole2 (Intermediate)Simmons13Clearwater3 (Difficult)c.bmpOhio5/25/15MarksAmy4 (Expert)Moore15Clearwater3 (Difficult)c.bmpOhio5/25/15AlexanderEric3 (Advanced)Jackson12Clearwater3 (Difficult)c.bmpOhio5/30/15AllenJames3 (Advanced)Jackson12Red Rock Rapids1 (Easy)rrr.bmpAllegheny6/1/16DobbinsBrenda1 (Beginner)Simmons13Business 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), and4 (Insane).There are four possible levels of customer expertize: 1 (Beginner), 2 (Intermediate), 3 (Advanced), and 4 (Expert)

2 points). Kayak Adventures gives its customers a uniqu_1

End of preview

Want to access all the pages? Upload your documents or become a member.