Identify the main entities and sample attributes for the Tourist Recommendation System. Provide the primary key and/or foreign key for each entity. Assume you are only managing the tour package and bicycle reservation module. List down your answers without stating the attributes data types and ERD illustration.

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter4: Analyzing And Charting Financial Data
Section: Chapter Questions
Problem 4.6CP
icon
Related questions
Question
You are hired to develop a Tourist Recommendation System for UMS Kota Kinabalu campus.
Based on the recommendation, the tourists can book five different tour package that is: 1) Gallery
& Museum Tour, 2) Nature Delight Tour, 3) Architecture Heritage Tour, 4) Sunset Tour and 5)
Nature Education Camp. Each tour can only accommodate 100 pax of tourist per day with a
different package price. For each selected tour, the tourist can reserve a bicycle for the additional
rate of RM5 per hour based on availability.
a) Kenalpasti entiti utama dan sampel atribut untuk Sistem Pengesyoran Pelancong. Berikan
kunci utama dan/atau kunci asing untuk setiap entiti. Andaikan anda hanya menguruskan
modul pakej pelancongan dan tempahan basikal sahaja. Senaraikan jawapan anda tanpa
menyatakan jenis data atribut dan ilustrasi ERD.
Identify the main entities and sample attributes for the Tourist Recommendation System.
Provide the primary key and/or foreign key for each entity. Assume you are only managing
the tour package and bicycle reservation module. List down your answers without stating the
attributes data types and ERD illustration.
Transcribed Image Text:You are hired to develop a Tourist Recommendation System for UMS Kota Kinabalu campus. Based on the recommendation, the tourists can book five different tour package that is: 1) Gallery & Museum Tour, 2) Nature Delight Tour, 3) Architecture Heritage Tour, 4) Sunset Tour and 5) Nature Education Camp. Each tour can only accommodate 100 pax of tourist per day with a different package price. For each selected tour, the tourist can reserve a bicycle for the additional rate of RM5 per hour based on availability. a) Kenalpasti entiti utama dan sampel atribut untuk Sistem Pengesyoran Pelancong. Berikan kunci utama dan/atau kunci asing untuk setiap entiti. Andaikan anda hanya menguruskan modul pakej pelancongan dan tempahan basikal sahaja. Senaraikan jawapan anda tanpa menyatakan jenis data atribut dan ilustrasi ERD. Identify the main entities and sample attributes for the Tourist Recommendation System. Provide the primary key and/or foreign key for each entity. Assume you are only managing the tour package and bicycle reservation module. List down your answers without stating the attributes data types and ERD illustration.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Enhanced ER Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage