Answered step by step
Verified Expert Solution
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
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
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