Here are the SQL statements to accomplish the tasks you've described:
INSERT
statement:INSERT INTO VENUE (name, address, capacity)
VALUES ('Maracana Stadium', 'Avenida Maracana', 78838);
Make sure to replace name
, address
, and capacity
with the actual column names in your VENUE table if they are different.
Sport
to the EVENT table, you can use the following SQL ALTER TABLE
statement:ALTER TABLE EVENT
ADD Sport VARCHAR(50);
This assumes that the Sport
attribute will be a string with a maximum length of 50 characters. You can adjust the data type and length as needed based on your requirements.