How To CIS 515: Tour Operator Agency Database

There are several other aspects of travel and accommodation arrangements that should also be recorded, such as a track of any available discounts, a record of all bookings made and all relevant research into the travel or accommodation arrangements that has been made.

Identify the different types of entities, attributes, keys and relationships you will want to consider when designing the database.

* As explained throughout this course, entity relationship modeling is a critical element of database design. If the database is not properly modeled, it is unlikely that the database will be properly developed. Using this knowledge, explain the key reasons why entity relationship modeling is important, and determine at least (1) way in which it impacts the overall development of the database.

# 6: Given a physical database containing tables and relationships and business requirements, create the necessary queries.

Henry Ou, Derrick Kwok, the President and the Vice President of Air & Sea Travel Center also serves as Tour Director of our company who would plan, organize, and conduct short-distance, long-distance travel, tours, and expeditions for individuals and groups. Mr. Ou and Mr. Kwok have experiences of planning and organizing trips, make sure everything runs according to the itinerary and make sure our valued clients safe and enjoy the trip. To be a successful Tour Director, personal skills and qualities are often more important than formal qualification. In memorable trip, our clients expect not only what they are going to visit, eat, and play, but also the excellent “people” skills of our Tour Directors who would bring them happiness, surprises, and make sure that arrangements for the group to run as smoothly and enjoyably as possible since the tourism industry is characterized by high-contact services in which co-creation of clients plays a major role (Grissemann & Stokburger-Sauer, 2012). Joylyn, Ina, and Phoebe are responsible for organizing and setting up the tour by making reservation for hotels, restaurants, cruises, gate tickets, and more. In most of the time, they would make a reservation earlier and deliver special requests to the service provider from the client in order to have availability to everyone in the group and make our client feel that they are valued because we listen and we care.

1.4 For the tables you created in Review Question 1.3, what are the primary keys of each table? Do you think that any of these primary keys could be surrogate keys?

There are three stages to normalization, 1st NF, 2nd NF, and 3rd NF. In the 1st NF stage must ensure that the table has no multivalued attributes. If there are the table should be broken down into separate tables so that there are no multivalued attributes. The 2nd NF stage requires that we break the tables down even more to ensure that all attributes and functional dependency entirely to the primary key and has met all requirements of the 1st NF. Then, and only then will it be considered to have met 2nd NF requirements. To transform the database to 3rd NF you must identify the primary key in the 2nd NF table. Then we must identify functional dependencies in the relationship to ensure there are no transitive dependencies. These types of dependencies can cause insertion, deletion, and update

Hence, this session has enhanced my understanding about normalization and how essential to create a data that is well organized with the relationships clearly defined and established between the tables (based on the business rules) in order to eliminate data redundancy and inconsistency.

In each element within this chain has their own specific needed; the producer should take account along with the needs of their consumer. The first level of the chain of distribution is the Principal. Principals are the one who provides the products or service to pass down to the next organisation in the chain of distribution; the principals are the one who produces the products or services. Tour operators are the one who combine or mix all the principals together to pass it down to the Travel Agents which is the next level of the chain of distribution.

Although Change Request No. 3 seems fairly simple, it will bring to light any issues that might have been encountered while interpreting the tables from the ERD Diagram. It is not uncommon for changes to be needed to the database after it has been created from the ERD. Moreover, now is the best time to catch these issues before the system is fully functioning making it much more difficult to make certain changes.

Draw an REA diagram with cardinalities and tables with primary keys, foreign keys, and non-key attributes for the following business:

Organization: Rentals are split evenly between reservations and walk-in customers. Reservation are entered in loose leaf binder which are separated by tabs for each business activity. Linda has created a Microsoft access database to record a reservation. She also uses and inexpensive accounting package to keep HKS books. Janet Jacobs who is a local college student, helps to handle telephone inquiries and reservations. Linda print out a reservation list each day and for reference she color codes lines to show the available or reserved status of each rental kayak.

For this video rental store, the movie database contains three kinds of records namely customers, tapes, and rentals. Whenever a customer visits the video store, the database is looked at to determine whether the store attendants already know the new customer; and if not, a new record is added to update the new customer’s details (Beynon-Davies, 2004). In the database, important information about the customer that is stored includes the customer's name and each customer is given a unique identifier; usually an ID whenever their details have been entered into the database. In addition, in compiling the database, the customer's birth dates are vital in gauging whether they should be allowed to rent certain movies or not.

There may be several purposes for business travelers to travel. Trade, meeting, convention and exhibition can be one of those travel purposes. However, business people also consume similar products and services as general tourists do. They would also spend their money on entertainment and recreation while they are at their destinations. Some unique characteristics of business tourists can be found as following:

The buyers of the services of travel agencies are consumers, that is, individuals and businesses. For this industry we are dealing with a small degree of concentration, due to the wide range of services.