Untitled
unknown
plain_text
a year ago
1.3 kB
5
Indexable
Certainly, here are the SQL statements to insert one value at a time for each table: For Sailors table: ```sql INSERT INTO Sailors (sid, sname, rating, age) VALUES (101, 'Jack', 8, 25); INSERT INTO Sailors (sid, sname, rating, age) VALUES (102, 'Emily', 7, 28); INSERT INTO Sailors (sid, sname, rating, age) VALUES (103, 'David', 6, 22); INSERT INTO Sailors (sid, sname, rating, age) VALUES (104, 'Sarah', 9, 30); INSERT INTO Sailors (sid, sname, rating, age) VALUES (105, 'Michael', 5, 27); ``` For Boats table: ```sql INSERT INTO Boats (bid, bname, color) VALUES (201, 'Sea Queen', 'Blue'); INSERT INTO Boats (bid, bname, color) VALUES (202, 'Sunset', 'Red'); INSERT INTO Boats (bid, bname, color) VALUES (203, 'Voyager', 'White'); INSERT INTO Boats (bid, bname, color) VALUES (204, 'Marina', 'Green'); INSERT INTO Boats (bid, bname, color) VALUES (205, 'Wave Rider', 'Yellow'); ``` For Reserves table: ```sql INSERT INTO Reserves (sid, bid, day) VALUES (101, 201, '01-Apr-2024'); INSERT INTO Reserves (sid, bid, day) VALUES (102, 202, '03-Apr-2024'); INSERT INTO Reserves (sid, bid, day) VALUES (103, 203, '05-Apr-2024'); INSERT INTO Reserves (sid, bid, day) VALUES (104, 204, '07-Apr-2024'); INSERT INTO Reserves (sid, bid, day) VALUES (105, 205, '09-Apr-2024
Editor is loading...
Leave a Comment