Lanchester Liners Hospitality Database, SQL Essay

Lanchester Liners cordial reception Database, SQL - search mannikinLanchester Liners cordial reception Database This handle presents a slender overview of architectural plan and writ of execution of hospitality Database for Lanchester Liners for prop knowledge more or less their ships, the ports visited where hospitality is offered, and either bodied team-building events organise on-board. In addition, the report in like manner offers a lucubrate word on multi-user glide slope to a database including concurrency, locking, surety and annoy control. 1. ... 85,10/01/1975,Sails) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) determine(1893233,Amsterdam,61000,05/09/1977,22.5) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(1029833,Aurora,76000,16/07/1980,24) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(1938821,Black Prince,11209,25/06/1976,24.5) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(2832911,Black Watch,28 668,31/12/1981,21) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(9283321,Dawn Princess,77000,30/03/1984,21) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3903211,Galaxy,77713,21/09/1979,21.5) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(1120322,Genesis,220000,11/11/1978,22.3) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3829111,Horizon,46811,17/03/1975,21.4) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3822211,Jewel of the Seas,90090,20/08/1982,25) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values (4833928,Norwegian Crown,34242,01/06/1981,22) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3928111,Norwegian Dawn,92250,09/02/1978,25) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3920000,Oceana,77000,28/07/1982,21) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3029992,Polynesia,430,09/05/1972,Sails) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3400049,Rhapsody,78491,23/02/1975,22) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(2939222,Sensation,70367,31/12/1975,21) INTO SHIP(shipNo, shipName, Tonnage, buildDate, speed) Values(3992019,Serenata,133500,07/11/1974,20.5) withdraw * FROM dual Populating