Hello, Need assistance answering in MICROSOFT SQL SERVER SQL. I need help with #2 but showing #1 since it's dependent on that.

1. Create the tables in the social networking schema, including all of their columns, datatypes, and constraints. Create sequences for each table, which will be used to create primary key in next step.

2. Populate the tables with data, ensuring that there are at least 3 people, at least 6 posts, and at least 3 likes. Make sure to use sequences to generate the primary key values. For the content field in Post table, make it whatever you like, such as Take a look at these new pics or Just arrived in the Bahamas, and set the summary as the first 12 characters of the content, followed by .

3. Create a stored procedure named add_zana_sage which has no parameters and adds a person named Zana Sage to the Person table. Execute the stored procedure, and list out the rows in the Person table to show that Zana Sage has been added.

Post Person + PK post_id FK1 person_id content created_on summary DECIMAL(12) NOT NULL DECIMAL(12) NOT NULL VARCHAR(255) NOT NULL DATE NOT NULL VARCHAR(15) NOT NULL PK person_id first_name last_name username DECIMAL(12) NOT NULL VARCHAR(32) NOT NULL VARCHAR(32) NOT NULL VARCHAR(20) NOT NULL Likes PK likes_id FK1 person_id FK2 post_id liked_on DECIMAL(12) NOT NULL DECIMAL(12) NOT NULL DECIMAL(12) NOT NULL DATE