Design a relational schema to support the following in SQL; A yacht charter company requires a web-based system to manag

[answerhappygod]

Design a relational schema to support the following in SQL; 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. Information to be held and manipulated include: • the name,nationality, email address, phone number and id number of eachcustomer. • the name, type, model, home port, number of berths andcost of hire per day of each yacht. • the name, phone number, emailaddress and number of docking places at each port. • the charterid, start date and duration of each charter, and the visit id,expected date of arrival and duration of stay at each portvisited.