need the answer s  for all of them  n  with screen shots too 

 

Lanchester Liners Hospitality Database– 55 Marks (15%)Assignment – 50 MarksValidation Individual work- 5 MarksHanded out on 3rdNov. 2016.Due in (Before Lecture-hard copy) on 22thNov. 2016.A. Database Design and ImplementationA corporate hospitality database is required to support the world-wide operations ofLanchester Liners. The main requirement is to hold information about their ships, theports visited where hospitality is offered, and any corporate team-building eventsorganised on-board.The modelling process has identified the following information requirements:Shipinformation about ships:ship number, ship name, tonnage, build date and speed.Portinformation about ports:The port id, port country and the port nameEventinformation about events:The event identifier and the event name.ShipPortinformation linking ships and ports.PortEventinformation linking ports and events.The schemas of the generated tables, with the primary keys underlined, are as follows:Ship(shipNo, shipName, tonnage, buildDate, speed)Event(eventId, eventName)Port(portId, portCountry, portName)ShipPort(shipNo, portId)PortEvent(portId, eventId)The information related to these schemas is shown in Appendix A.TaskYou are required to create an Oracle database that will support the queries listed below.You should selectappropriate data types for each of the attributes in the tables. Thedatabase should be populated with the sample data provided in Appendix A. Clearly youwill have to deduce the data from the table (Appendix A) that shouldbe entered in theindividual tables and insert additional information when required.You should submit the following in the form of a simple report.You should include aprint of the Oracle spool file as an appendix.

Attachments:

• 1494223430-LanchesterLinersHospitality Section s11.doc