Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Quantitative Credit Portfolio Management

Authors: Arik Ben Do, Lev Dynkin, Jay Hyman, Bruce D. Phelps

1st Edition

1118117697, 978-1118117699

More Books

Students also viewed these General Management questions

Question

3 What are the four major aspects of an organisation culture?

Answered: 1 week ago

Question

2 What does the term organisation culture mean?

Answered: 1 week ago