i only need the answer for part 2!
Paris Part 1: Data Insertion (15 marks) Create a GUI application in C using the GTK+ and mysql libraries. The application should perform the following operations: a. Create a data entry page which allows the user to enter customer information. The page should include five textboxes Customer Name. Passport Number. Flight Number. Flight Date, and Destination. (6 marks) b. Create a database using mysql called reservation (1 marks) c. Create a table in the aforementioned database called customers (1 marks) d. Use the data entry page (part a) to store the information provided in table 1 in the database table customers. (7 marks) CustomerName PassportNumber FlightNumber FlightDate Destination Susan AF81234 KWINI 23 20/08/2020 London Henry AS43218 KWLN123 20/08/2020 London Davidson AZ76871 KWPR456 18/08/2020 Larry QW78990 KWAM879 23/08/2020 Amsterdam Jerry DIY9922 KWIN123 20/08/2020 London QP12233 KWPR456 18/08/2020 Paris Alex WE23344 KWPR456 18/08/2020 Paris Susan EW12334 KWAM879 23/08/2020 Amsterdam Amanda AZ12334 KWAM879 23/08/2020 Amsterdam Table 1: Airline Customer information Part 2: Data Modification and Extraction (15 marks) Create a GUI application in C using the GTK+ and mysql libraries. The application should perform the following operations: a) Create a data modification page which allows the user to modify customer information. The page should include two textboxes Customer Name, and Passport Number Additionally, add a Text Label to display all customers travelling on a specific flight. (2 marks) b) Use the data modification page to update customer's information using customer name & passport number. For example, changing Susan (Passport Number: EW12334) flight from Amsterdam (KWAM879) on 23/08/2020 to London (KWLN123) 20/08/2020. (8 marks) c) Display names of all Customers who are travelling to London on a Text Label. (5 marks) Jen Paris Part 1: Data Insertion (15 marks) Create a GUI application in C using the GTK+ and mysql libraries. The application should perform the following operations: a. Create a data entry page which allows the user to enter customer information. The page should include five textboxes Customer Name. Passport Number. Flight Number. Flight Date, and Destination. (6 marks) b. Create a database using mysql called reservation (1 marks) c. Create a table in the aforementioned database called customers (1 marks) d. Use the data entry page (part a) to store the information provided in table 1 in the database table customers. (7 marks) CustomerName PassportNumber FlightNumber FlightDate Destination Susan AF81234 KWINI 23 20/08/2020 London Henry AS43218 KWLN123 20/08/2020 London Davidson AZ76871 KWPR456 18/08/2020 Larry QW78990 KWAM879 23/08/2020 Amsterdam Jerry DIY9922 KWIN123 20/08/2020 London QP12233 KWPR456 18/08/2020 Paris Alex WE23344 KWPR456 18/08/2020 Paris Susan EW12334 KWAM879 23/08/2020 Amsterdam Amanda AZ12334 KWAM879 23/08/2020 Amsterdam Table 1: Airline Customer information Part 2: Data Modification and Extraction (15 marks) Create a GUI application in C using the GTK+ and mysql libraries. The application should perform the following operations: a) Create a data modification page which allows the user to modify customer information. The page should include two textboxes Customer Name, and Passport Number Additionally, add a Text Label to display all customers travelling on a specific flight. (2 marks) b) Use the data modification page to update customer's information using customer name & passport number. For example, changing Susan (Passport Number: EW12334) flight from Amsterdam (KWAM879) on 23/08/2020 to London (KWLN123) 20/08/2020. (8 marks) c) Display names of all Customers who are travelling to London on a Text Label. (5 marks) Jen
