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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!