Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

f. How many users are using Instacart for the first time? (2 points) Generate the answer with a query and save the query as IsNullpriororder

image text in transcribed
f. How many users are using Instacart for the first time? (2 points) Generate the answer with a query and save the query as IsNullpriororder (5 points). g. How many users are the returning users of Instacart? (2 points) Generate the answer v a query and save the query as IsNotNullpriororder (5 points). h. Calculate and report the percentage of ordered items being reordered (3 points). Save query as reordered (2 points). i. What is the user_id of the user who has made 100 orders on Instacart? (4 points) Generate the answer with a query and save the query as Crosstaborder1 (5 points). j. Create the E-R diagram using the 4 tables. Attach the screenshot of the E-R diagram points) and explain the relationships across the tables. If correctly generated, there sho be 3 relationships. Refer to Access In-Class Exercise I.doc to correctly explain the relationships between key variables across the tables. (5 points each) i.e. - note from Access In-Class Exercise) Each trip takes only one helicopter, but a helicopter may be used for multiple trips different dates/times) or may have not been used for any trip yet. Each particular trip only one pilot assigned to it, but a pilot may be assigned to different trips (on differ dates/times) or may have not been assigned to any trip yet. Each trip belongs to particular tour type, but a specific tour type may be chosen for different trips or have not been chosen by any trip. k. Combine the tables together and create a single table with all variables of the four (with no duplicate variables). Click on the "Make Table" icon from the "Design" m to save the complete table as wholetable (5 points). 1. Use wholetable to discover and report which aisle has the most reorder incidents (5

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_2

Step: 3

blur-text-image_3

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

Management Process

Authors: Lee Long

4th Edition

978-0201822939,0201822938

More Books

Students also viewed these General Management questions

Question

write a python asteroids game using turtle module

Answered: 1 week ago