150 likes | 350 Views
Coursework. Airport Departures. How to fly. Buy the ticket – you now have a place reserved on a flight. You now have a ticket (often this is “virtual”) Check in – go to the right desk, identify yourself and hand over bags You are given a boarding pass.
E N D
Coursework Airport Departures
How to fly... • Buy the ticket – you now have a place reserved on a flight. • You now have a ticket (often this is “virtual”) • Check in – go to the right desk, identify yourself and hand over bags • You are given a boarding pass. • Clear security – your boarding pass is checked. • Board the plane – your boarding pass is checked. Lecture 5: Review
Airport Lecture 5: Review
Departures Board Lecture 5: Review
Data is Shared • Departures data is public, passengers need to see this information. • The departures data may be available on the internet. • Data on tickets is not public but it is shared, check in desk, boarding gate, flight crew. Lecture 5: Review
Database • A database can be shared. • One server holds the data and serves it to many clients. • As the data is stored in one place only there can be only one version of the data. • Any updates are available to all clients immediately. Lecture 6: Airport Departures
What can go wrong? • Someone who has no booking can try to check in. • Someone who has not checked in can try to board. • Someone who has a booking does not check in. • Someone who has checked in does not board. Lecture 5: Review
Flights Table Lecture 5: Review
Task - Compulsory • Create the departures board: • The board must show the next 50 flights. • It must show the time of departure, the destination, the flight number, the gate, notes. • The board should be easy to read. • The board should have text as big as possible. • Edit Flight Data • Provide a list of all flights. Allow an operator to change details (CRUD). Lecture 5: Review
Task - Optional • The departures board must show destinations in English and Chinese. These alternate every 5 seconds. • Where the same flight has two or more flight numbers it must take only one line. The flight codes must cycle every 2 seconds. Lecture 5: Review
Sample Solution Lecture 5: Review
Sample Solution Lecture 5: Review
Score Sheet Lecture 6: Airport Assessment
Tomorrow • At the tutorial you will practice how to use a database. • At tomorrow’s lecture I will explain how it works. Lecture 5: Review
Summary • You will build the application on your own. • I will show you examples using a different database. • You can apply the examples to the Flights database. • I will check your work on Thursday. • You will need to explain, in English, what your program does. Lecture 5: Review