INSERT INTO [Port] ([Name], [Location], [Capacity]) VALUES ('Port Pre-School', 'Pre School USA', 1),
                                                            ('Port Elementary', 'Elementary USA', 2),
                                                            ('Port Junior High', 'Junior High School USA', 3),
                                                            ('Port High School', 'High School USA', 4),
                                                            ('Port College', 'College USA', 5)

INSERT INTO Yacht (Name, Capacity) VALUES ('USS Philippine Sea', 400),
                                          ('USS Minnow', 6),
                                          ('Anna', 13),
                                          ('Pinto', 20),
                                          ('Santa Maria', 8)

INSERT INTO Charter (PortID, YachtID, ArrivalDate, DurationInDays) VALUES (1,1,GETDATE(),7),
                                                                            (1,2,GETDATE(),7),
                                                                            (1,3,GETDATE(),7),
                                                                            (1,4,GETDATE(),7),
                                                                            (1,5,GETDATE(),7),
                                                                            (2,1,GETDATE(),7),
                                                                            (2,2,GETDATE(),7),
                                                                            (2,3,GETDATE(),7),
                                                                            (2,4,GETDATE(),7),
                                                                            (2,5,GETDATE(),7),
                                                                            (3,1,GETDATE(),7),
                                                                            (3,2,GETDATE(),7),
                                                                            (3,3,GETDATE(),7),
                                                                            (3,4,GETDATE(),7),
                                                                            (3,5,GETDATE(),7),
                                                                            (4,1,GETDATE(),7),
                                                                            (4,2,GETDATE(),7),
                                                                            (4,3,GETDATE(),7),
                                                                            (4,4,GETDATE(),7),
                                                                            (4,5,GETDATE(),7),
                                                                            (5,1,GETDATE(),7),
                                                                            (5,2,GETDATE(),7),
                                                                            (5,3,GETDATE(),7),
                                                                            (5,4,GETDATE(),7),
                                                                            (5,5,GETDATE(),7)