Advantages and disadvantages of joins and nested queries

Assignment Help Database Management System

Reference no: EM13165407

One side effect of normalization is that you often need more than one table to get meaningful results. For example, you may have a table that includes a list of parts and the ID number for the vendor of each part. To find the name or phone number of the vendor, you would have to consult a table that contains vendor information. In many situations, either a join or a nested query will provide the information you need. Sometimes only one approach works, or one approach is better than the other one.

With these thoughts in mind, address the following:

What are the advantages and disadvantages of joins and nested queries?

Identify specific situations in which each technique would be preferred over the other.

Explain your reasoning.

Reference no: EM13165407

Questions Cloud

Employees may work from home : Employees may work from home up to 15 hours per week. Each project leader needs a list of current means of contacting each member of the project team: home phone and home FAX number. To contact employees "on the road" the project leaders also need..

State what is the mass percent of aceditc acid : what is the % mass of acetic acid in the vinegar? Hint: What is the mass percent of aceditc acid titrated and what is the definition of % mass?

How many moles of helium have been evolved : The temp of the water and that of the gas are identical at 26°C. How many moles of Helium have been evolved?

Explain how to calculate ksp : how to calculate ksp of Ca(OH)2 at 296.25K and 364.95K with Ca(OH)2 being titrated with 0.0523M of HCl and 7.80mL of it added at 296.25K

Advantages and disadvantages of joins and nested queries : One side effect of normalization is that you often need more than one table to get meaningful results. For example, you may have a table that includes a list of parts and the ID number for the vendor of each part. T

How ip addresses are assigned : Identify how IP addresses are assigned in the local area network at your scool or workplace. Were any other methods used to assign IP adreess prior to the current configuration? Why was the current configuration chosen?

Find the contour length : find the contour length (chain length) for a fully extended polythylene molecule that has a degree of polymerization of (n=45000),given that the length of c-c bond is 1.54 Ao.

Measure financial and non financial performance : Evaluate and use quantitative and qualitative information to measure financial and non financial performance of an organisation

What is the average thickness of the sheet in meters : If a 180 piece of gold (density =19.32 ) is hammered into a sheet measuring 2.51.0 , what is the average thickness of the sheet in meters?

User Account

All Pages