design a flight website

I will be providing a database Table. Functions for the Customers a. can select/deselect booked flights which should display a reminder message when a selected flight will depart within 7 days, and cookie may be useful to implement this function; Done By b. can view and update his/her personal data except the customer ID and bonus point; c. can view all his/her air ticket and hotel bookings, and additional related information from the "flightschedule" and "hotel" tables; d. can view his/her bonus points and search the flights of which the bonus points can be used to redeem a free ticket (5 bonus points = $1 in ticket price). Sufficient flight information should be displayed for easy reference; Functions for the Travel Agent (Staff) a. can search and display data of a selected airline company, the display data should include [1] flight no., [2] flight schedule (departure airport and time; arrival airport and time),[3] flight class, [4] prices and tax; b. can search and display data of a selected hotel, the display data should include [1] hotel address & contact tel., [2] room type, [3] prices, [4] services listed in "RoomDesc" (e.g. smoking area, Wi-Fi, breakfast ...), [5] room size, [6] number of rooms available (only when a stay period is also specified in the search criteria); c. can add, update or delete any customer record, and the updatable data should include [1] surname and given name, [2] passport no., [3] customer ID in hotel or flight bookings; d. based on the travel plan provided by a walk-in customer, the travel agent staff can search and display matching air ticket information or/and the hotel information and automatically calculate the total amount for the air ticket(s) and hotel room(s) finally selected by the customer; Functions for Hotel Owners a. can search a customer’s check-in and check-out records by surname or mobile number; b. can search the room availability by check-in date (e.g. 28 May 2016), no. of nights to stay (e.g. 3 nights), and room type (e.g. single room, double room, superior room); c. can update the information of rooms such as price, room size, non-smoking code, and description (e.g. Wifi facility, coffee table, 2 chairs); d. can generate a room statistics report from hotel bookings by selecting the date period (e.g. from 01 Apr 2016 to 30 Apr 2016). The report data should be properly organized and it should at least contain the information such as room type, number of rooms booked and total revenue; Functions for Airline Companies a. can add new flight classes and new flight schedules to the database and the "FlyMinute" value should be automatically calculated; b. can delete any flight schedule and display the personal details of all affected passengers who have these related bookings; c. can search a passenger by surname or mobile no., then display all flight bookings of this passenger, automatically calculate the bonus points will be earned by this passenger ($1 in "TotalAmt" of "flightbooking" record = 1 bonus point), then accumulate the calculated bonus points to the current value of "BonusPoint"; d. can create an analysis report by providing different options for the user to choose : * Grouping option : group the data by flight no. or by flight class * Period filter : select flights which departs within a date period * Output option : output the total number of passengers or the total revenue * Format option : output in the form of text or graphical chart