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 adifferent package price. For each selected tour, the tourist can reserve a bicycle for the additionalrate of RM5 per hour based on availability.a) Kenalpasti entiti utama dan sampel atribut untuk Sistem Pengesyoran Pelancong. Berikankunci utama dan/atau kunci asing untuk setiap entiti. Andaikan anda hanya menguruskanmodul pakej pelancongan dan tempahan basikal sahaja. Senaraikan jawapan anda tanpamenyatakan 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 managingthe tour package and bicycle reservation module. List down your answers without stating theattributes data types and ERD illustration.

The relational schema has been developed without any data types using the given requirements in…

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.

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.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Given the entity STUDENT and attributes: ST_INTIAL, ST_LNAME, ST_FNAME, ST_EMAIL, ST_PHONE . Use the Chen notation to depict the relationships:
When an attribute is a component of a composite primary key, that attribute is also considered to be a candidate key for the table.
Justify the index's usefulness in terms of why it requires a large enough range of values for an attribute.
Please follow this ER diagram, give a description, and make a schema diagram from it. Also, make database (constraint tables) & intent some sample data. Lastly, run some SQL functions code. Please don't copy from anywhere. I need it for my project.
Create an Entity Relationship Diagram (ERD) of the normalized version of this table using Visio's crows-foot notation. The ERD should show the PK and FK columns, plus all of the appropriate column attributes (column name, data type/size, null/not null) plus the relationships (with minimum and maximum cardinality) between tables. Requirements: Show the results of the normalization as individual tables Show the FK and PK columns using Visio's notation You must solve the multi-column issue with grades (Hint: This will require a new column) Show the 3-part column definition as noted Show min/max cardinality Tables are attached
Discuss your database table possibilities for creating subtype relationships.Talk about what you would look for in a design and how it would affect your final selection.
how can I Normalize the Schema. Add any additional Attributes that think are needed during this design check Student(Name, Address, Grade1, Grade2, Grade3, Course1, Course2, Course3, Degree’s)
- Base on the information and ERD diagram given , identify the normal form (NF) level for Staff table, Role table, Project table and Student table. - Are there any 2 NF tables identified in (a)? If yes then explain why the table is in 2 NF and convert the table to 3 NF by using relation representation
Question 7 On ERD, you can create attributes with the same name in different Entities. Question 7 options: True False
There is a great deal of flexibility in how keys are disseminated. Explain what's best and why it's the finest.
Show the SQL statements for creating relations corresponding to the entity sets and relationships. Identify any constraints in the ER diagram that you are unable to capture in the SQL statements and briefly explain why you could not express them.
When utilizing subtype associations, it is important to discuss the database table options that are available.Decide on the design you want to use and discuss the challenges that arise as a result of it.