Q2) Create a Table which contains following information. Please consider, the Table have to setup properly...

Transcribed Image Text:

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 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