Personal Experience The Motel Industry - 704 Words

Physically we live on planet Earth, a constantly accelerating body in the solar system and the only body in this body system that contains complex living organisms. Whenever, I am asked what my world consists, two things come to mind. First is the denotation of the word world. The denotation of the word world is the place of the human civilization, specifically any place that pertains to the planet Earth. Second the connotation of the word world comes to mind. The connotation is anything that defines me, whether it be my family, my culture, my ideals, my home, my environment, and etc. Personally, I am a conglomerate of two different cultures, first being my parents’ Indian heritage and the fact that I was born into an American society. As of now, two different cultures are coursing through my blood, the culture of India and the United States of America. â€Å"I am the product and expression of this world, even if suddenly it vanished, I’d still represent it; I would ar ticulate it.† This world is something that defines me and I do not want to ever lose it. I will be losing a part of me if that happens. Like I mentioned before, my parents are from India and thus have an Indian culture. My dad immigrated from Indian in the year 1989. My mother immigrated in the year 1996. Every since they have arrived, they have attempted to blend Indian heritage with the American way of life. Whether it be religious traditions or cuisine from India, my parents have attempted to incorporate in theShow MoreRelatedEhrenreich s Nickel And Dimed, By Barbara Ehrenreich1284 Words   |  6 Pagespromotes society to take action, then so be it. It is clear from Ehrenreich’s novel that the life of the working poor is not a sustainable lifestyle. Whether it s continuing to work after spraining your ankle out of fear of missing work or calling a motel or car your home, it’s not a life anyone should be forced to live. It is easy for anyone to tell that the life of the working poor is not the ideal lifestyle. Though in Ehrenreich’s words, â€Å"It is common, among the nonpoor, to think of poverty as aRead MoreEssay on Good Night Inn Case Analysis2533 Words   |  11 Pagescareer in manufacturing to purchase an independent motel, near an interstate highway exit, a short distance from a rapidly expanding resort area. Mr. Cahoon relied only upon passersby as clientele with little other advertising. For the first two years operations went smoothly, however the Goodnight Inn had not become profitable. While occupancy rates stabilized near 55%, they were still well below the industry average of 68%. Anton had run his motel avoiding â€Å"unnecessary expenses†, and as a resultRead MoreHotel Sector Five Forces Analysis7366 Words   |  30 PagesINDUSTRY PROFILE Hotels Motels in Europe Reference Code: 0201-0520 Publication Date: October 2011 www.datamonitor.com Datamonitor USA 245 Fifth Avenue 4th Floor New York, NY 10016 USA t: +1 212 686 7400 f: +1 212 686 2626 e: usinfo@datamonitor.com Datamonitor Europe 119 Farringdon Road London EC1R 3DA United Kingdom t: +44 20 7551 9000 f: +44 20 7675 7500 e: eurinfo@datamonitor.com Datamonitor Middle East and North Africa Datamonitor PO Box 24893 Dubai, UAE t: +49 69 9754 4517 f: +49 69Read MoreDistribution Based On The Hotel Website Design Essay2193 Words   |  9 PagesDistribution strategy Our motel cannot be everything to every guest. Rather the focus should be on supporting channels of distribution based on the customers the company intends to cater to. We are trying to target consumers looking for ‘best value’ while booking a room or are you only looking at the ‘price-conscious’ booker or you have some other consideration. Meeting evolving content requirements of intermediaries- Maintaining direct connection and executing new functionality calls for resourcesRead MoreGlobal Hotels and Motels7253 Words   |  30 PagesINDUSTRY PROFILE Global Hotels Motels Reference Code: 0199-0520 Publication Date: October 2010 www.datamonitor.com Datamonitor USA 245 Fifth Avenue 4th Floor New York, NY 10016 USA t: +1 212 686 7400 f: +1 212 686 2626 e: usinfo@datamonitor.com Datamonitor Europe 119 Farringdon Road London EC1R 3DA United Kingdom t: +44 20 7551 9000 f: +44 20 7675 7500 e: eurinfo@datamonitor.com Datamonitor Middle East and North Africa Datamonitor PO Box 24893 Dubai, UAE t: +49 69 9754 4517 f: +49 69 9754Read MoreI Am An Plan Of The Next Year During My Master Of Business Management Program1612 Words   |  7 Pagesendeavours to finish my studies. The Big Picture The hospitality industry is growing rapidly in this world. The hospitality business is one of the quickest developing organizations everywhere throughout the world that creates billions of cash and offers a lot of new profession and occupation chances to individuals with different foundations. The friendliness business is a major business everywhere throughout the world. India hospitality industry deals are relied upon to achieve a record $537 billion-inRead MoreEssay about Issues Surrounding the Migrant Farm Worker1442 Words   |  6 Pagesachieve the perfect selection of produce that the American consumer has come to expect, a high price must be paid by the laborers who make it possible. At the top of the list is their physical and mental well-being. Migrants and their dependents experience more frequent and more severe health problems than the general population. Their illnesses are often caused by poor nutrition, lack of resources, lack of education, or infectious diseases from overcrowding and poor sanitation. However, the healthRead MoreDynamics Of Hospitality And Tourism1003 Words   |  5 PagesAccommodation sector Tuesday, November 18, 2014. Hospitality industry comprises of a wide-range of businesses, which provide services and facilities, such as, accommodation, food and beverage, entertainment, travel services and many more related products. The accommodation sector presents a vital part in the hospitality industry, because an accommodation is essential as like food and beverage, for anyone spending time away from home. Definition:-Read MoreThe Process of Recruiting, Hiring, and Maintaining Staff in the Hospitality Industry 1258 Words   |  6 Pagesrecruiting, hiring, and maintaining staff is critical in the hospitality industry. The employees serve as direct branding and marketing for the company, supplying the customers, or guests, with an experience that meets, exceeds, or fails expectations. The experience given by the employees ultimately determines the satisfaction of new and repeat guests, therefore guiding the company toward its level of success. In my personal experiences of working at hotels, the interaction between employee and guestRead MoreMy Experience At The Hospitality Industry1083 Words   |  5 PagesThe hospitality industry is most definitely the largest industry in the world and is still growing! There are various different positions within the industry that individuals can pursue, whether it is in lodging, travel, recreation, assembly and event management, or restaurants a nd managed services. My personal interest is in lodging because that entails hotels, motels, and resorts. My ideal position is to become a resort activities director, at Universal’s Cabana Bay Beach Resort, to be specific

A Discussion On Organizational Culture - 1479 Words

It is the fourth day of the retreat and fifteen people are sitting in a conference room on the bank of the Mohican River in Ohio. The conversation is difficult; to the rhythm of brief respites of silence, the careful culling of words betrays the veiled tension. The moderator has been facilitating a discussion centred on the difference between leading and managing; many wonder: â€Å"What’s the point?† Everyone attending - mostly individuals who for years have been deeply immersed in a traditional manufacturing shop floor environment - work at Tool, Inc., a hierarchical organization where workers followed supervisor’s orders, who in turn executed the senior team’s strategy and mandates. To participants, facilitators look like supervisors, so they impatiently wait for an order. But they are not ordering, but asking. Naturally, it took them a few days to connect with the facilitators, who had been laboriously kneading them into a mind-set where such an inta ngible conversation about organizational culture would even be possible. After an hour of persistent nudging, one jaded machinist finally summarized Tool, Inc.’s culture: â€Å"Do your eight, hit the gate†. It would take more than just one retreat - and participants from every role, layer and team across the organization - to finally achieve the headroom necessary for the conversation facilitators meant to have that day. Defining the many differences between leading and managing was, of course, not a purely semantic pursuit. Tool,Show MoreRelatedTo Begin The Discussion Of Organizational Culture It Is1181 Words   |  5 PagesTo begin the discussion of organizational culture it is critical that we first define what it is that we will seek to examine. As noted in the readings, many definitions exist, however for the scope of this paper I will take the lead of Kuh and Whitt. Defining organizational culture as the â€Å"collective, mutually shaping patterns of norms, v alues, practices, beliefs, and assumptions that guide the behavior of individuals and groups in an institute of higher education and provide a frame of referenceRead Moreorganizational behaviour1261 Words   |  6 Pages Organizational Behavior MG6013 The exploration of the theories, research and practices that allow a better understanding of human behavior in organizations. Topics include motivation and job satisfaction; decision making; group dynamics; work teams; leadership; communication; power, politics and conflict; organization culture, structure and design; impact of technology; management of work stress; organizational change andRead MoreOrganisational dialouge Essay1711 Words   |  7 Pagesï » ¿ 21878 Organizational Dialogue University of Technology Sydney Autumn 2014 Assignment Question 2: A range of authors (e.g. Gerard and Ellinor 2001; Isaacs 1993, 1999; Schein 1993; Senge 1995) suggest that dialogue can positively transform organizational cultures. Do you agree with this assessment? Why? Why not? Engage with relevant academic literature in developing your argument. Student Name: Nguyen Vu Hoang Dung Student Number:Read MoreThe Organizational Structure Of General Electric ( Ge ) Essay1029 Words   |  5 PagesInternational business management A discussion of the organizational structure of General Electric (GE) Introduction GE is an American multinational conglomerate which deals in industries like aviation, oil and gas, power and water, health care and capital, to mention a few. The company has a matrix organizational structure, which is characterized by the organization of the company according to multiple metrics. In the case of GE, the structure is matrix in that it combines a functional structureRead MoreHow Can Cnn Implement Their Strategies in a Fast Changing Environment?961 Words   |  4 Pagesmission * Design of organizational architecture that allows for empowerment and communication * Creation of tactics and short-term goals at the local level * Effective Action in a context of accountability (Gurowitz) (G. R. Jones; C.W.L. hill , 2010) 2. What is organizational design (culture, structure and control) and apply on CNN. What is the role of organizational design in strategic implementation? Strategy implementation involves the use of organizational design, the process ofRead MoreEmotional Intelligence And Organizational Leadership1445 Words   |  6 PagesEmotional Intelligence and Organizational Leadership Various authors have been debating the issue of emotional intelligence and organizational leadership. However, the existing discourse on the matter has been hampered in terms of limited theoretical applications. Moreover, many analysts have failed to propose effective relationships among constructs, thus failing to offer any meaningful relationship between emotional intelligence and organizational leadership. Nevertheless, many authors offerRead MoreThe Goals Of The Organizational Culture807 Words   |  4 Pagesgoals of the organizational culture are often not compatible, resulting in unethical business ethics. Due to the profit oriented goals of the business, components of organization culture often fail as they rely strongly upon personal morals of management and employees. As per our discussions in class, an ethical culture is â€Å"one in which employees are empowered and expected to act in ethically responsible ways even when the law does not require it† (Perera, Yas anthi, â€Å"The Corporate Culture – ImpactsRead MoreIntroduction And Trends Of Organizational Time Management1589 Words   |  7 PagesI. Key Issues A. Article Introduction and Trends in Organizational Time Management The Harvard Business Review article, â€Å"Your Scarcest Resource,† addresses the modern phenomenon of the lack of control implementation for managing organizational time. Communication channels including phone calls, meetings, and emails inefficiently exhaust a company’s scarce time, due to a lack of effective management, and ultimately deplete the time they could focus on their customers. Also, decision-making and innovationRead MoreCultural Assessment Tools And Organizational Culture843 Words   |  4 PagesIntroduction Corporate culture is an intricate component of an organizations identity. Fortune 500 corporations have used corporate culture as a trademark. Best Buy, a leading electronics corporation, leverages its brand by promoting the â€Å"Geek Squad.† Walmart Corporation requires all associates to dress in dark blue shirts and beige slacks. This document will discuss cultural assessment tools used in assessing organizational culture and gaps within formal groups, leadership styles and techniquesRead MoreEmployee Organizational Culture Essay667 Words   |  3 Pagescreate what is known as organizational culture. A strong culture constructs a unified employee atmosphere, whereas a weak culture lacks a shared sense of distinction between employees. An employee’s heritage or individual culture, although different than, affects the overall organizational culture of companies. Like society, sub-cultures exist within organizations. Formed by departmental function, geographical location, and/or the personalities of employees, sub-cultures include employees who continue

Reading Strategies Free Essays

Reading Strategies Worksheet †¢ How do you currently approach the weekly readings in the course? I approach the weekly readings with a lot of energy so that when I read the material it stays fresh in my mind. I also like to take notes as I read highlighting the main points in each paragraph. I approach my readings as if it were my job and take the information provided very seriously. We will write a custom essay sample on Reading Strategies or any similar topic only for you Order Now I look at is as the tools to my trade and to not fully comprehend the text means that I can’t fully accomplish my goal of getting a degree. How might you incorporate three of the suggestions covered this week into your study time? I could incorporate some of the suggestions given to me by previewing my text. This could help tremendously because it helps you to get a view of what it is you are about to read and helps with recognizing things you already know. Another strategy is marking my textbook. This can help by letting me reference my notes rather than read through the entire material over again. One final strategy I could incorporate is readings in time blocks. This helps me to focus more on what I am reading so that I can keep the information I gain fresh in my mind. †¢ How might this plan help you accomplish your reading goals? This plan could help me accomplish my reading goals by helping me to focus and comprehend more. Also by increasing my reading level. This plan could help me to be more of a conscious reader and not just one who reads material and doesn’t retain any of the information. This can also be helpful by letting me skim over the text due to my note taking and mapping. How to cite Reading Strategies, Papers

Entity Relationship Diagram for Normalisation

Question: Discuss about the ERD for Normalization Functions. Answer: ERD: Normalization: First Normalization Form: Eliminating repeating groups VIPStatus (VIPStatusID, VIPStatusName, DiscountPtge) Company (CompanyID, CompanyName, Address, Phone, Fax, Email) Customer (CustomerID, FirstName, LastName, Address, City, State, CompanyID, Mobile, PostCode, Email, CustomerTypeName, FFDiscount, VIPStatusID) Staff (StaffID, StaffName, Address, Phone, Email, SupervisorID, CompanyID) Location (LocationID, LocationName, State, City, PostCode) TravelBooking (TravelID, DepartureDate, ArrivalDate, OverallTravelAmount, CustomerID, StaffID, CompanyID, NumAdult, NumChild, InvoiceDate, TravelPackageAmount, IsAmountPaid, TravelPackageID, Description, PackageAmount, DatePkgIssued, DatePkgExpired, DepartingDate, ReturnDate, AirlineID, AirlineName, DepartureLocationID, DestinationLocationID, FlightID, FlightName, DateOfDeparture, DateOfArrival, CabinClass, AirlineCharges, HotelID, HotelName, LocationID, Phone) Second Normalization Form: Eliminating redundant data VIPStatus (VIPStatusID, VIPStatusName, DiscountPtge) Company (CompanyID, CompanyName, Address, Phone, Fax, Email) Customer (CustomerID, FirstName, LastName, Address, City, State, CompanyID, Mobile, PostCode, Email, CustomerTypeName, FFDiscount, VIPStatusID) Staff (StaffID, StaffName, Address, Phone, Email, SupervisorID, CompanyID) Location (LocationID, LocationName, State, City, PostCode) Hotels (HotelID, HotelName, LocationID, Phone) TravelPackage (TravelPackageID, Description, PackageAmount, DatePkgIssued, DatePkgExpired, DepartingDate, ReturnDate) Airline (AirlineID, AirlineName, DepartureLocationID, DestinationLocationID, FlightID, FlightName, DateOfDeparture, DateOfArrival, CabinClass, AirlineCharges) TravelBooking (TravelID, DepartureDate, ArrivalDate, OverallTravelAmount, CustomerID, StaffID, CompanyID, NumAdult, NumChild, InvoiceDate, TravelPackageAmount, IsAmountPaid, TravelPackageID, AirlineID, HotelID) Third Normalization Form: Remove Transitive Dependency CustomerType (CustomerTypeID, CustomerTypeName) Company (CompanyID, CompanyName, Address, Phone, Fax, Email) Customer (CustomerID, FirstName, LastName, Address, City, State, CompanyID, Mobile, PostCode, Email, CustomerTypeID) Staff (StaffID, StaffName, Address, Phone, Email, SupervisorID, CompanyID) VIPStatus (VIPStatusID, VIPStatusName, DiscountPtge) VIP (CustomerID, VIPStatusID) FrequentFlyer (CustomerID, FFDiscount) Location (LocationID, LocationName, State, City, PostCode) Flight (FlightID, FlightName) Hotels (HotelID, HotelName, LocationID, Phone) TravelPackage (TravelPackageID, Description, PackageAmount, DatePkgIssued, DatePkgExpired, DepartingDate, ReturnDate) Airline (AirlineID, AirlineName, DepartureLocationID, DestinationLocationID, FlightID, DateOfDeparture, DateOfArrival, CabinClass, AirlineCharges) TravelBooking (TravelID, DepartureDate, ArrivalDate, OverallTravelAmount, CustomerID, StaffID, CompanyID, NumAdult, NumChild) TravellingDetails (TravelPackageID, AirlineID, TravelID) StayAt (HotelID, TravelID, TravelPackageID) Invoice (InvoiceID, InvoiceDate, TravelPackageAmount, IsAmountPaid, TravelID, CustomerID) Note: Primary Key - Underline Foreign Key - Italics Relational Schema: CustomerType (CustomerTypeID, CustomerTypeName) Primary Key (CustomerTypeID) Company (CompanyID, CompanyName, Address, Phone, Fax, Email) Primary Key (CompanyID) Customer (CustomerID, FirstName, LastName, Address, City, State, CompanyID, Mobile, PostCode, Email, CustomerTypeID) Primary Key (CustomerID), Foreign Key (CompanyID) References Company (CompanyID), Foreign Key (CustomerTypeID) References CustomerType (CustomerTypeID) Staff (StaffID, StaffName, Address, Phone, Email, SupervisorID, CompanyID) Primary Key (StaffID), Foreign Key (SupervisorID) References Staff (StaffID), Foreign Key (CompanyID) References Company (CompanyID) VIPStatus (VIPStatusID, VIPStatusName, DiscountPtge) Primary Key (VIPStatusID) VIP (CustomerID, VIPStatusID) Primary Key (CustomerID), Foreign Key (CustomerID) References Customer (CustomerID) Foreign Key (VIPStatusID) References VIPStatus (VIPStatusID) FrequentFlyer (CustomerID, FFDiscount) Primary Key (CustomerID), Foreign Key (CustomerID) References Customer (CustomerID) Location (LocationID, LocationName, State, City, PostCode) Primary Key (LocationID) Flight (FlightID, FlightName) Primary Key (FlightID) Hotels (HotelID, HotelName, LocationID, Phone) Primary Key (HotelID), Foreign Key (LocationID) References Location (LocationID) TravelPackage (TravelPackageID, Description, PackageAmount, DatePkgIssued, DatePkgExpired, DepartingDate, ReturnDate) Primary Key (TravelPackageID) Airline (AirlineID, AirlineName, DepartureLocationID, DestinationLocationID, FlightID, DateOfDeparture, DateOfArrival, CabinClass, AirlineCharges) Primary Key (RestaurantID), Foreign Key (DepartureLocationID) References Location (LocationID), Foreign Key (DestinationLocationID) References Location (LocationID), Foreign Key (FlightID) References Flight (FlightID) TravelBooking (TravelID, DepartureDate, ArrivalDate, OverallTravelAmount, CustomerID, StaffID, CompanyID, NumAdult, NumChild) Primary Key (TravelID), Foreign Key (CustomerID) References Customer (CustomerID), Foreign Key (StaffID) References Staff (StaffID), Foreign Key (CompanyID) References Company (CompanyID) TravellingDetails (TravelPackageID, AirlineID, TravelID) Primary Key (TravelPackageID, AirlineID, TravelID), Foreign Key (TravelPackageID) References TravelPackage (TravelPackageID), Foreign Key (AirlineID) References Airline (AirlineID), Foreign Key (TravelID) References TravelBooking (TravelID) StayAt (HotelID, TravelID, TravelPackageID) Primary Key (TravelPackageID, AirlineID, TravelID), Foreign Key (TravelPackageID) References TravelPackage (TravelPackageID), Foreign Key (HotelID) References Hotels (HotelID), Foreign Key (TravelID) References TravelBooking (TravelID) Invoice (InvoiceID, InvoiceDate, TravelPackageAmount, IsAmountPaid, TravelID, CustomerID) Primary Key (InvoiceID), Foreign Key (TravelID) References TravelBooking (TravelID), Foreign Key (CustomerID) References Customer (CustomerID) Database Schema: DROP TABLE IF EXISTS CustomerType ; CREATE TABLE IF NOT EXISTS CustomerType ( CustomerTypeID INT NOT NULL, CustomerTypeName VARCHAR(45) NOT NULL, PRIMARY KEY (CustomerTypeID)); -- ----------------------------------------------------- -- Table Company -- ----------------------------------------------------- DROP TABLE IF EXISTS Company ; CREATE TABLE IF NOT EXISTS Company ( CompanyID INT NOT NULL, CompanyName VARCHAR(45) NOT NULL, Address VARCHAR(60) NOT NULL, Phone VARCHAR(15) NOT NULL, Fax VARCHAR(15) NOT NULL, Email VARCHAR(45) NOT NULL, PRIMARY KEY (CompanyID)); -- ----------------------------------------------------- -- Table Customer -- ----------------------------------------------------- DROP TABLE IF EXISTS Customer ; CREATE TABLE IF NOT EXISTS Customer ( CustomerID INT NOT NULL, FirstName VARCHAR(25) NOT NULL, LastName VARCHAR(25) NOT NULL, Address VARCHAR(60) NOT NULL, City VARCHAR(30) NOT NULL, State VARCHAR(3) NOT NULL, Mobile VARCHAR(15) NOT NULL, PostCode INT NOT NULL, Email VARCHAR(45) NOT NULL, CustomerTypeID INT NOT NULL, CompanyID INT NOT NULL, PRIMARY KEY (CustomerID), INDEX fk_Customer_CustomerType_idx (CustomerTypeID ASC), INDEX fk_Customer_Company1_idx (CompanyID ASC), CONSTRAINT fk_Customer_CustomerType FOREIGN KEY (CustomerTypeID) REFERENCES CustomerType (CustomerTypeID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_Customer_Company1 FOREIGN KEY (CompanyID) REFERENCES Company (CompanyID) ON DELETE NO ACTION ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table Staff -- ----------------------------------------------------- DROP TABLE IF EXISTS Staff ; CREATE TABLE IF NOT EXISTS Staff ( StaffID INT NOT NULL, StaffName VARCHAR(45) NOT NULL, Address VARCHAR(60) NOT NULL, Phone VARCHAR(15) NOT NULL, Email VARCHAR(45) NOT NULL, CompanyID INT NOT NULL, SupervisorID INT NULL, PRIMARY KEY (StaffID), INDEX fk_Staff_Company1_idx (CompanyID ASC), INDEX fk_Staff_Staff1_idx (SupervisorID ASC), CONSTRAINT fk_Staff_Company1 FOREIGN KEY (CompanyID) REFERENCES Company (CompanyID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_Staff_Staff1 FOREIGN KEY (SupervisorID) REFERENCES Staff (StaffID) ON DELETE NO ACTION ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table VIPStatus -- ----------------------------------------------------- DROP TABLE IF EXISTS VIPStatus ; CREATE TABLE IF NOT EXISTS VIPStatus ( VIPStatusID INT NOT NULL, VIPStatusName VARCHAR(45) NOT NULL, DiscountPtge FLOAT NOT NULL, PRIMARY KEY (VIPStatusID)); -- ----------------------------------------------------- -- Table VIP -- ----------------------------------------------------- DROP TABLE IF EXISTS VIP ; CREATE TABLE IF NOT EXISTS VIP ( CustomerID INT NOT NULL, VIPStatusID INT NOT NULL, INDEX fk_VIP_Customer1_idx (CustomerID ASC), INDEX fk_VIP_VIPStatus1_idx (VIPStatusID ASC), PRIMARY KEY (CustomerID), CONSTRAINT fk_VIP_Customer1 FOREIGN KEY (CustomerID) REFERENCES Customer (CustomerID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_VIP_VIPStatus1 FOREIGN KEY (VIPStatusID) REFERENCES VIPStatus (VIPStatusID) ON DELETE NO ACTION ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table FrequentFlyer -- ----------------------------------------------------- DROP TABLE IF EXISTS FrequentFlyer ; CREATE TABLE IF NOT EXISTS FrequentFlyer ( CustomerID INT NOT NULL, FFDiscount FLOAT NOT NULL, INDEX fk_FrequentFlyer_Customer1_idx (CustomerID ASC), PRIMARY KEY (CustomerID), CONSTRAINT fk_FrequentFlyer_Customer1 FOREIGN KEY (CustomerID) REFERENCES Customer (CustomerID) ON DELETE NO ACTION ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table Location -- ----------------------------------------------------- DROP TABLE IF EXISTS Location ; CREATE TABLE IF NOT EXISTS Location ( LocationID INT NOT NULL, LocationName VARCHAR(45) NOT NULL, City VARCHAR(30) NOT NULL, State VARCHAR(3) NOT NULL, PostCode INT NOT NULL, PRIMARY KEY (LocationID)); -- ----------------------------------------------------- -- Table Flight -- ----------------------------------------------------- DROP TABLE IF EXISTS Flight ; CREATE TABLE IF NOT EXISTS Flight ( FlightID INT NOT NULL, FlightName VARCHAR(45) NOT NULL, PRIMARY KEY (FlightID)); -- ----------------------------------------------------- -- Table Hotels -- ----------------------------------------------------- DROP TABLE IF EXISTS Hotels ; CREATE TABLE IF NOT EXISTS Hotels ( HotelID INT NOT NULL, HotelName VARCHAR(45) NOT NULL, Phone VARCHAR(15) NOT NULL, Location_LocationID INT NOT NULL, PRIMARY KEY (HotelID), INDEX fk_Hotels_Location1_idx (Location_LocationID ASC), CONSTRAINT fk_Hotels_Location1 FOREIGN KEY (Location_LocationID) REFERENCES Location (LocationID) ON DELETE NO ACTION ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table TravelPackage -- ----------------------------------------------------- DROP TABLE IF EXISTS TravelPackage ; CREATE TABLE IF NOT EXISTS TravelPackage ( TravelPackageID INT NOT NULL, Description VARCHAR(60) NOT NULL, PackageAmount FLOAT NOT NULL, DatePkgIssued DATE NOT NULL, DatePkgExpired DATE NOT NULL, DepartingDate DATE NOT NULL, ReturnDate DATE NOT NULL, PRIMARY KEY (TravelPackageID)); -- ----------------------------------------------------- -- Table Airline -- ----------------------------------------------------- DROP TABLE IF EXISTS Airline ; CREATE TABLE IF NOT EXISTS Airline ( AirlineID INT NOT NULL, AirlineName VARCHAR(45) NOT NULL, DateOfDeparture DATE NOT NULL, DateOfArrival DATE NULL, CabinClass VARCHAR(30) NOT NULL, AirlineCharges FLOAT NOT NULL, DepartureLocationID INT NOT NULL, DestinationLocationID INT NOT NULL, FlightID INT NOT NULL, PRIMARY KEY (AirlineID), INDEX fk_Airline_Location1_idx (DepartureLocationID ASC), INDEX fk_Airline_Location2_idx (DestinationLocationID ASC), INDEX fk_Airline_Flight1_idx (FlightID ASC), CONSTRAINT fk_Airline_Location1 FOREIGN KEY (DepartureLocationID) REFERENCES Location (LocationID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_Airline_Location2 FOREIGN KEY (DestinationLocationID) REFERENCES Location (LocationID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_Airline_Flight1 FOREIGN KEY (FlightID) REFERENCES Flight (FlightID) ON DELETE NO ACTION ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table TravelBooking -- ----------------------------------------------------- DROP TABLE IF EXISTS TravelBooking ; CREATE TABLE IF NOT EXISTS TravelBooking ( TravelID INT NOT NULL, DepartureDate DATE NOT NULL, ArrivalDate DATE NOT NULL, OverallTravelAmount FLOAT NOT NULL, NumAdult INT NOT NULL, NumChild INT NOT NULL, CustomerID INT NOT NULL, StaffID INT NOT NULL, CompanyID INT NOT NULL, PRIMARY KEY (TravelID), INDEX fk_TravelBooking_Customer1_idx (CustomerID ASC), INDEX fk_TravelBooking_Staff1_idx (StaffID ASC), INDEX fk_TravelBooking_Company1_idx (CompanyID ASC), CONSTRAINT fk_TravelBooking_Customer1 FOREIGN KEY (CustomerID) REFERENCES Customer (CustomerID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_TravelBooking_Staff1 FOREIGN KEY (StaffID) REFERENCES Staff (StaffID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_TravelBooking_Company1 FOREIGN KEY (CompanyID) REFERENCES Company (CompanyID) ON DELETE NO ACTION ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table TravellingDetails -- ----------------------------------------------------- DROP TABLE IF EXISTS TravellingDetails ; CREATE TABLE IF NOT EXISTS TravellingDetails ( TravelID INT NOT NULL, TravelPackageID INT NOT NULL, AirlineID INT NOT NULL, INDEX fk_TravellingDetails_TravelBooking1_idx (TravelID ASC), INDEX fk_TravellingDetails_TravelPackage1_idx (TravelPackageID ASC), INDEX fk_TravellingDetails_Airline1_idx (AirlineID ASC), PRIMARY KEY (TravelID, TravelPackageID, AirlineID), CONSTRAINT fk_TravellingDetails_TravelBooking1 FOREIGN KEY (TravelID) REFERENCES TravelBooking (TravelID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_TravellingDetails_TravelPackage1 FOREIGN KEY (TravelPackageID) REFERENCES TravelPackage (TravelPackageID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_TravellingDetails_Airline1 FOREIGN KEY (AirlineID) REFERENCES Airline (AirlineID) ON DELETE NO ACTION ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table StayAt -- ----------------------------------------------------- DROP TABLE IF EXISTS StayAt ; CREATE TABLE IF NOT EXISTS StayAt ( HotelID INT NOT NULL, TravelID INT NOT NULL, TravelPackageID INT NOT NULL, INDEX fk_StayAt_Hotels1_idx (HotelID ASC), INDEX fk_StayAt_TravelBooking1_idx (TravelID ASC), INDEX fk_StayAt_TravelPackage1_idx (TravelPackageID ASC), PRIMARY KEY (HotelID, TravelID, TravelPackageID), CONSTRAINT fk_StayAt_Hotels1 FOREIGN KEY (HotelID) REFERENCES Hotels (HotelID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_StayAt_TravelBooking1 FOREIGN KEY (TravelID) REFERENCES TravelBooking (TravelID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_StayAt_TravelPackage1 FOREIGN KEY (TravelPackageID) REFERENCES TravelPackage (TravelPackageID) ON DELETE NO ACTION ON UPDATE NO ACTION); -- ----------------------------------------------------- -- Table Invoice -- ----------------------------------------------------- DROP TABLE IF EXISTS Invoice ; CREATE TABLE IF NOT EXISTS Invoice ( InvoiceID INT NOT NULL, InvoiceDate DATE NOT NULL, TravelPackageAmount FLOAT NOT NULL, IsAmountPaid VARCHAR(1) NOT NULL, TravelID INT NOT NULL, CustomerID INT NOT NULL, PRIMARY KEY (InvoiceID), INDEX fk_Invoice_TravelBooking1_idx (TravelID ASC), INDEX fk_Invoice_Customer1_idx (CustomerID ASC), CONSTRAINT fk_Invoice_TravelBooking1 FOREIGN KEY (TravelID) REFERENCES TravelBooking (TravelID) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT fk_Invoice_Customer1 FOREIGN KEY (CustomerID) REFERENCES Customer (CustomerID) ON DELETE NO ACTION ON UPDATE NO ACTION);