Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

AirAsia s exclusive cheap flights return with domestic and international travel for as low as RM 1 . 0 0 . Develop an auction website,

AirAsias exclusive cheap flights return with domestic and international travel for as low as RM 1.00. Develop an auction website, where the users can bid for their low-fare tickets with benefits based on the following criteria,
a) A login and register module for each account user, and data input for fields like username, password and confirm password verified for correctness and completeness with a database table. You may use any suitable regular pattern expression (regex) for the inputs received and verified.
b) Then using menu driven interface, the user may perform the following tasks:
i. Select, edit, bid an amount for the tickets sold.
ii. Generate a booking id after the user confirms for a booking made.
iii. Provide a simple receipt view of the payment for the booking created.
iv. Logout from the system after completing a booking activity.
c) The user may choose from a selection of travel packages and discount offers detailing the flight itinerary Table 1.
Table 1 Travel package bundle offering.
Package Plan Bid Benefits
Bundle A Less than 5-tickets booked where each ticket is valued at RM800 gets a 25% discount offer from the overall total.
Bundle B 5 or more tickets booked where each ticket is valued at RM1000 gets a 50% discount offer from the overall total.
Bundle C More than 5-tickets booked where each ticket is valued at RM1200 gets a 75% discount offer from the overall total.
d) Prepare relevant database tables for login/register module, ticket bid module, and payment module.
e) Suitable error exception handling is applied with ticket booking limits for each type and for invalid inputs with a message prompt or dialogues.
General Requirements
Develop a web system, that will incorporate and frontend user interface, locally hosted with an active MYSQL database. You need to apply web design principles that may include document object model, data validation, object-oriented, XML or JSON, jQuery, AJAX, web service and database where applicable to develop a simple web system.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Constraint Databases

Authors: Peter Revesz

1st Edition

1441931554, 978-1441931559

More Books

Students explore these related Databases questions