Question: Database Diagram Post User id INT Comment text VARCHAR(280) Pid INT Fid INT creation_date DATETIME # text VARCHAR(280) name VARCHAR(128) likes INT creation_date DATETIME email

 Database Diagram Post User id INT Comment text VARCHAR(280) Pid INTFid INT creation_date DATETIME # text VARCHAR(280) name VARCHAR(128) likes INT creation_date

Database Diagram Post User id INT Comment text VARCHAR(280) Pid INT Fid INT creation_date DATETIME # text VARCHAR(280) name VARCHAR(128) likes INT creation_date DATETIME email VARCHAR(320) author _id INT likes INT username VARCHAR(128) Indexes post_id INT password VARCHAR(32) author_id INT city VARCHAR(45) Community Indexes country VARCHAR(45) Pid INT time_zone VARCHAR(45) name VARCHAR(32) ip_address VARCHAR(45) # followers INT date_of_birth DATE description VARCHAR(128) job VARCHAR(45) creation_date DATETIME phone_number VARCHAR(45) Indexes Indexes Friendship Community_has_User I friend_a_id INT Community_id INT I friend_b_id INT User_id INT creation_date DATETIME Indexes IndexesInstructions Below you will find a list of business opportunities and problems that require information from the database. Your job is to carefully read all business scenarios and craft SQL statements that obtain relevant information to the business opportunity or problem. For every business opportunity and problem, you must include the following information as a response: |. SQL statement(s) and a screen capture of the SQL statement(s) a. Make sure to organize SQL statements and screen capture in the chronological order they need to be executed. b. After all your SQL statements and screen captures, include a short description in your words why all the suggested SQL statements help address the business requirements. Business opportunities 1. LSI would like to implement a feature that reads out loud content from the Social Media platform and justifies charging a subscription fee. The LSI marketing department considers that choosing a famous public personality voice to read the message will make this feature successful. However, public figure voice rights are expensive; thus, LSI must decide which voice to acquire for its initial implementation (i.e., pilot). LSI has surveyed its Social Media users to learn what voice they prefer for this feature. a. The results of the survey organized by generation are the following (see Appendix A for age groups): i. Generation Z: Olivia Rodrigo ii. Millennials: Neil DeGrasse Tyson iii. Generation X: Jane Goodall iv. Boomers: Sonia Sotomayor b. Your job is to consult the database to identify what option from above will cover the most users if you know that Generation 2 8: Millennials and Generation X & Boomer have similar preferences. Include a brief textual justification (1-2 sentences} in your recommendation

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 General Management Questions!