Question

1. this is sql developer question I just need the format of how to answer question!
2. Create sequences (2) that can be used to number the member ID and group ID values starting with 3 (since you already have 1 and 2).
3. Write an INSERT statement that adds another row to the Groups table, make up a group name. Use the NEXTVAL pseudo column to get the value for the next group ID from the sequence that you created in #5. Then, write a SELECT statement that gets all of the data for all of the rows in the Groups table to make sure your sequence worked correctly.
4. Write an ALTER TABLE statement that adds two new columns to the Members table: one column for annual dues that provides for three digits to the left of the decimal point and two to the right; and one column for the payment date. The annual dues column should have a default value of 52.50.
5. Write an ALTER TABLE statement that modifies the Groups table so the group name in each row has to be unique. Then, re-run the INSERT statement that you used in #6 to make sure this works.

Answer 1

1)

CREATE SEQUENCE seq_1
START WITH 3
INCREMENT BY 1
MAXVALUE 999
CYCLE;

2)

INSERT INTO Groups(GroupID, GroupName) VALUES (seq_1.nextval, "Sample Group");

NOTE: Since you have not mentioned the table structure, I am inserting dummy row into unknown columns.

SELECT * FROM Groups;

3)

ALTER TABLE Members ADD AnnualDues DECIMAL(3, 2) default 52.50,

ADD PaymentDate DATE;

4)

ALTER TABLE Groups ADD UNIQUE(GroupName);

INSERT INTO Groups(GroupID, GroupName) VALUES (seq_1.nextval, "Sample Group");