Perform a join operation on the tablesnbsptbl

Question

Part -1:

'Where are the Missing Customers?

Play Around Toys Inc. wants to lure back customers who have not purchased any of its products for a while.

Tasks:

1. Perform a Join operation on the tables tbl Customers and tbl Orders.
2. Develop a query to generate a report on customer transaction data.
3. Provide an analysis on customer behavior.
4. Provide a strategy to get customers back to the local Play Around Toys store.

Submission Requirements:

• Submit your answers, in minimum of 250 words, in an MS Word document.
• Submit a copy of the updated database.
• Font: Arial; 12-point
• Line Spacing: Double

Part -2:

Play Around Toys Goes Online
Play Around Toys Inc. wants to expand its business by creating a website where customers can shop online. Prepare a report that describes an e-commerce business and revenue model for the website. In addition, define behavioral targeting and explain how it will work on this website. Describe the factors that must be considered while designing the website.

Submission Requirements:

• Submit your answers, in minimum of 500 words, in an MS Word document.
• Font: Arial; 12-point
• Line Spacing: Double

Attachment:- lab.zip