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

1 Expert Approved Answer

Step: 1 Unlock

Q3 To establish a relationship between tables we need more information about the struct... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

1 2 Sales 3 Cash Sales 4 Credit Sales 5 COGS 6 7 8 9 Cash Sales 10 Credit Sales 11 Total Collections 12 A B D E F September October November December January 280,000 400,000 600,000 300,000 200,000...

Data 2.12 on page 119 introduces a dataset containing information on customers tipping patterns in a restaurant. The data are available in Restaurant- Tips. (a) What are the cases? What is the sample...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Find the critical points of the function. Then use the Second Derivative Test to determine whether they are local minima, local maxima, or saddle points (or state that the test fails). f(x, y) = x -...

A dielectric is pulled out from between the plates of a capacitor which remains connected to a battery. What changes occur to (a) The capacitance, (b) The charge on the plates, (c) The potential...

Decide whether the statement is true or false. If false, correct the right side of the equation. (x + y) -1 = x -1 + y -1

=+c) Can studies such as these prove causation (that wine helps prevent heart attacks, that drinking wine makes one richer, that being rich helps prevent heart attacks, etc.)? Explain.

Five years ago, when the relevant cost index was 120, a nuclear centrifuge cost $40,000. The centrifuge had a capacity of separating 1500 gallons of ionized solution per hour. Today, it is desired to...

Question 4 The following comparative statement of financial position for Prett Co. is given for the financial periods 2019 and 2020 2020 2012 PPE $430,000 Accumulated depreciation of PPE $395,000...

Peru Furniture City, Inc., sold $88,000 of furniture in May to customers who used their American Express Credit Cards. Such sales are subject to a 5% discount by American Express (a nonbank credit...

In a customer orientation, management _ _ _ _ _ _ _ _ _ _ . emphasizes the most efficient ways to produce and distribute products builds long - term bonds with customers prioritizes the satisfaction...

1. Your friend asks you to invest $10,000 in a business venture. Based on your estimates, you would receive nothing for four years, at the end of year 5 you would receive interest on the investment...

1 ) A global contracting organisation suffers from different types of organisational conflicts internally and within its clients and supply chain. You are appointed as a consultant to advise senior...

Jose own a small retail store and hires Sam as his agent to manage the store while he is away on vacation. Jose instructs Sam to only sell items at a 10% discount. However, Sam mistakenly sells a...

In South Africa, while excessive, deadly, or lethal use of force tends to be associated more often with the SAPS, private security officers have also been guilty of such activities. This connotation...

7) Bright Semiconductor specializes in semiconductors that are used in autos, communication equipment, and industrial machinery, which are cyclical industries. This high-yield-rated company's debt...

pls send as soon as possible Design a JavaScript+Jquery application to read the PAN Number and Name of an Employee. If the PAN Number does not contain exactly 10 characters and if the Name of the...

Determine by direct integration the values of x for the two volumes obtained by passing a vertical cutting plane through the given shape of Fig. 5.21. The cutting plane is parallel to the base of the...

Modify the Products form (not the Ch 12 Assignment 5 form you just created) by changing the Category ID text box control to a special combo box control, listing the choices of CategoryID and...

How do you change a relative reference to an absolute reference?

How do you add a new series of data to an existing chart?

1. Suppose one monozygotic twin is right-handed and the other is left-handed. According to Klars hypothesis, when these twins have children of their own, should we expect the left-hander to have a...

8. How do epinephrine and cortisol enhance memory storage?

7. What are three views of the contribution of the hippocampus to memory formation?