Question: Instructions: Using a text editor of your choice, write the queries that accomplishes the objectives listed below. Take screenshots of the queries and results and

Instructions: Using a text editor of your choice, write the queries that accomplishes the objectives listed below. Take screenshots of the queries and results and paste them in this document where instructed below. Create a new repository on GitHub for this week's assignments and push this document to the repository. Additionally, push an .sgl file with all your queries and your ERD to the same repository. Add the URL for this week's repository to this document where instructed and submit this document to your instructor when complete. Coding Steps: You have been asked to create a database for a new social media application that your company is developing The database must store user data such as username, email, password, etc... Users are able to post and comment. So, your database must also store post and comment data. We need to know which user made which posts. We also need to know which user made which comments, and which post a comment is on. Posts and comments should both include the time they were created, and what the content of the post or comment is. Create an Entity Relationship Diagram (ERD) using draw.io to model the database you will create. Insert a screenshot of the ERD in the screenshots section below. Write a SQL script to create the database. Insert a screenshot of the SQL in your script
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
