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?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Explain normal form is denormalized table

Which field or fields cause a table to no longer be in third normal form? In which normal form is denormalized table?

  Create a crow''s foot erd using a specialization hierarchy

Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms

  Write program to ask user to enter last name of customer

Write a program that will ask the user to enter the last names of our candidates in a class officer's president election and the number of votes received each candidate.

  Create database of measured meteorological data

You are creating a database of measured meteorological data for use in weather and climate research. Explain a structure type measured_data_t with components site_id_num.

  Draw an e-r diagram

Draw an E-R Diagram and draw an E-R Diagram for Student Information System.

  Convert table to equivalent collection of tables

determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables.

  Determine a list of n numbers has no duplicates

Express given five loosely described problems carefully in { Instance, Question } form as utilized in "Computers and Intractability". Determine that a list of n numbers has no duplicates.

  Explain leaf of b tree which holds a sublist

Artificially small example of B+ tree is shown here (pdf). (Note only part of tree is shown in detail.) What nodes of example B+ tree are visited to find posting list for "dune"?

  Design and implement a small database application

Perform the conceptual database design using Entity-Relationship model. You must submit the Entity-Relationship diagram of your database and develop queries in the target DBMS

  Create an er diagram using the set of requirements

Create an ER diagram using the set of requirements provided for Oxford City Council's bicycle sharing scheme and identify the minimal set of functional dependencies and all candidate keys for the relation R

  Characteristics of database

Describe the database and describe the four characteristics of the database? Explain the Relational Database and generate a relational database for five employees.

  Justify a question on database management

When a student has not chosen a major at a university, the university often enters a value of "Undecided" for the major field. Is "Undecided" a way to represent the null value? Should it be used as a default value? Justify your answer carefully.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd