Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
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