Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q2) Create a Table which contains following information. Please consider, the Table have to setup properly in the Table design. The type filed is
Q2) Create a Table which contains following information. Please consider, the Table have to setup properly in the Table design. The type filed is should be defined by a student. Vendor ID Vendor Name Gambardella Toys Vendor Address 3697 Taywell Avenue City Sales Rep Kim Bowen GT36 Detroit 756-491-4689 756-491-5685 HT19 Pat Kirtland Hooper Toys Tailspin Toys Wingtip Toys, Inc. TT96 Smithfield Columbus Thomas 306-954-4681 306-954-5697 404-561-8704 414-561-8702 Stephanie Hoo WT36 945-468-9521 945-468-9500 Matt Gambard Q3) Create an appropriate relationship between these two tables. Please consider the logic before making a relationship between them. Q4) Please create a query that only shows the data for city Detroit. Save the Query as "Detroit". Q5) Please create a query that shows description starts with "P". Save the query as "Description". Q6) Please create a query that shows sales greater than 20$. 19 Mason Drive 967 Front Street 369 S. Broadway MI State TN GA OK 46879 38695 31902 75367 Zip Phone Number Fax Number
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Q3 To establish a relationship between tables we need more information about the struct...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