What should you do? You are designing for a large grocery store - ProProfs Discuss
Topics
Products
Follow Us:

What should you do? You are designing for a large grocery store chain. The partial database schema is shown in the Partial\r\nDatabase Schema Exhibit.\r\nThe script that was used to create the Customers table is shown in the Script for Customers Table\r\nExhibit.\r\nThe store managers want to track customer demographics so they can target advertisements and coupon\r\npromotions to customers. These advertisements and promotions will be based on the past purchases of\r\nexisting customers. The advertisements and promotions will target buying patterns by one or more of\r\nthese demographics: gender, age, postal code, and region. Most of the promotions will be based on gender\r\nand age. Queries will be used to retrieve the customer demographics information.\r\nYou want the query response time to be as fast as possible.

This question is part of Microsoft SQL Server Quiz for Beginners!
Asked by Nidhooo, Last updated: Jun 24, 2020

+ Answer
Request

1 Answer

nidhooo

Nidhooo

Answered Mar 31, 2019

Add indexes on the PostalCode, State, and DateOfBirth columns of the Customers table.
Denormalize the Customers table
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.