Question
Hello, Need assistance answering in MICROSOFT SQL SERVER SQL. I need help with #2 but showing #1 since it's dependent on that. Create the tables
Hello, Need assistance answering in MICROSOFT SQL SERVER SQL. I need help with #2 but showing #1 since it's dependent on that.
- 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 DATEStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started