Ask a question to Desklib · AI bot
2 points). Kayak Adventures gives its customers a uniqu
Added on -2019-09-18
| 1 pages
| 344 words
| 136 views
Trusted by 2+ million users,
1000+ happy students everyday
(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)
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan