alptium / airlines

Alptium Airlines
MIT License
0 stars 0 forks source link

Flight DB #15

Open vasilijajoksimovic opened 6 years ago

vasilijajoksimovic commented 6 years ago

Make a database schema (CREATE TABLE) script. Read tutorials regarding Java JDBC e.g. http://www.mkyong.com/tutorials/jdbc-tutorials/ see section "Quick Start" and "JDBC & Statement". Implement saving of new data (INSERT), e.g. after you've created a reservation object (or whatever other data is in your project), then save that into the corresponding DB table. Implement retrieving data (SELECT), so that I have a menu option to see the list of all flight (or whatever else is in your project). Implement deleting data (DELETE), that I can for example select which flight to delete, and then it's deleted from the DB. Implement editing data (UPDATE), e.g. I select a flight and change some of the data. [BONUS] Read about ERD & foreign keys, make relationships between the data.

vasilijajoksimovic commented 6 years ago

@Tamaralb See the task above.