Design a relational schema to support the following in SQL, must include referential integrity with primary and foreign

[answerhappygod]

Design a relational schema to support the following in SQL, mustinclude referential integrity with primary and foreign keys; Ayacht charter company requires a web-based system to manage aspectsof its holiday charter business. There are a number of customers,each of whom may book a number of holiday charters, with eachcharter booked by an individual customer. A holiday charter mayinvolve one yacht only, but each yacht may be involved in manyholiday charters. A holiday charter may visit several ports andeach port will be visited by many holiday charters. Most ports haveseveral yachts based in them (although a few smaller ports have noyachts based in them) with each yacht based in just a single homeport.Business processes to be supported include the ability to: adddetails of a new customer together with the start date and durationof the charter they have booked, but without specifying the yachtto be used or the ports to be visited. list the total length ofstay, between two given dates of yachts in the fleet in each port.get a list of yachts (by name) visiting their home port between twogiven dates, together with the date of arrival and the length ofthe stay. list the ports visited by a given customer together withthe date of arrival and length of stay, ordered by date. remove ayacht temporarily for a period of time (e.g., for servicing) andget a list of yachts that are not available..