Vessels Search I
.
Assuming that there is a database of vessels and ships owners and the flights that carried out by these vessels, I've built simple data contains data for ships and their owners and trips which carried out, and the relationship between ships table and their owners table and table of trips which carried out, using MS SQL. As well as, I was designed and programming an web program to display and review and search in the database tables relationship, using ASP.NET and C#. So you can filter the whole database (all tables - using the relationship) by Owner Name or Boat Name or Trip from (or any other fields). Also it is possible to (hide or view) any tables of the database, and (hide or view) any field of table.
Please feel free to test your web application
Hide or View tables (Owners, Boats & Trips). View or Hide columns of each tables.
Filters tables by owner name, boat name or / and Trip from
Any other design, specific features, can be done as per your requirements
Owners
IDOwner NameAddressPhoneEmail
1Samir Fares ..Galway0876105236samir_moriss@yahoo.com
2Abanoub FaresHeadford Road00 00 00 0000aabanoub@abanoub.com
3Flobater FaresSceilg Ard10 10 10 1010flobater@flobater.com
4Sohair FaresGalway City000 111 00000sohair@sohair.com
5aSDSADASDASD
6    
7    
8My Online OneCork000 0000 00000ssaahbjhjhvldsvh@hillgiflif.khbdi
Boats
Owner NameNumberStart OnExpire On
Samir Fares311/28/2005 12:00:00 PM11/27/2015 12:00:00 PM
Samir Fares21/15/2011 12:00:00 AM1/14/2013 12:00:00 AM
Samir Fares311/18/2010 12:00:00 AM11/17/2020 12:00:00 AM
Sohair Fares48/19/1990 12:00:00 AM8/18/2015 12:00:00 AM
Sohair Fares51/22/2000 12:00:00 AM1/21/2013 12:00:00 AM
Abanoub Fares611/20/2011 12:00:00 AM11/19/2021 12:00:00 AM
Flobater Fares75/23/2008 12:00:00 AM5/22/2016 12:00:00 AM
Trips
Boat NameOwner NameTrip FromTrip To
Fish BoatSamir FaresGalwayCork
Fish BoatSamir FaresCorkGalway
Fish II BoatSamir FaresDublinMayo
Fish III BoatSamir FaresMayoDublin
Exp BoatSohair FaresGalwayDublin
Exp II BoatSohair FaresMayoDublin
Exp BoatSohair FaresMayoCork