1 / 15

Coursework

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.

rollo
Download Presentation

Coursework

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Coursework Airport Departures

  2. 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

  3. Airport Lecture 5: Review

  4. Departures Board Lecture 5: Review

  5. 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

  6. 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

  7. 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

  8. Flights Table Lecture 5: Review

  9. 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

  10. 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

  11. Sample Solution Lecture 5: Review

  12. Sample Solution Lecture 5: Review

  13. Score Sheet Lecture 6: Airport Assessment

  14. 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

  15. 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

More Related