Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 20 8 Points The marketing team at LSI reports that retrieving users' location data from LSI's Social Media database is becoming very slow; see

image text in transcribedimage text in transcribed
Question 20 8 Points The marketing team at LSI reports that retrieving users' location data from LSI's Social Media database is becoming very slow; see the database model below. The report argues that since the last wave of users registering on the platform, their job of creating reports that can generate better location-aware advertisement campaigns is becoming more complex. Therefore, they have requested upper management to invest more resources in the IT Infrastructure so they can create reports at the country level of information. Post User P id INT Comment >text VARCHAR(280) id INT id INT name VARCHAR(128) K creation_date DATETIME # text VARCHAR(280) email VARCHAR(320) likes INT >creation_date DATETIME author_id INT likes INT username VARCHAR(128) Indexes password VARCHAR(32) post_id INT author_id INT city VARCHAR(45) Indexes country VARCHAR(45) Community time_zone VARCHAR(45) Pid INT ip_address VARCHAR(45) name VARCHAR(32) date_of_birth DATE # followers INT job VARCHAR(45) description VARCHAR(128) phone_number VARCHAR(45) >creation_date DATETIME Indexes Indexes Friendship Community_has_User friend_a_id INT Community_id INT friend_b_id INT User_id INT creation_date DATETIME Indexes Indexes LSI CTO has contacted your team about this request. After reviewing the performance of the database infrastructure, your team leader has found that there is no need to buy expensive hardware to improve performance and that adding an index to the database will help fix the problem. Therefore, your job is to add an index to the database so that the marketing department can retrieve faster country location information from LSI's Social Media database Fill in the blanks on the SQL below to complete the SQL stamen that is required to fix the problem described above. Important note: follow recommended letter casing (e.g., uppercase) to receive creditImportant note: follow recommended letter casing (e.g., uppercase} to receive credit CREATE Blank 1 idx_user_location ON Blank 2 (Blank 3)

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

Elementary Statistics

Authors: Robert R. Johnson, Patricia J. Kuby

11th Edition

978-053873350, 9781133169321, 538733500, 1133169325, 978-0538733502

Students also viewed these General Management questions

Question

please dont use chat gpt or other AI 3 8 5 .

Answered: 1 week ago