How the difference between an outer join and an inner join

Assignment Help Database Management System

Reference no: EM13187961

Consider the following database that contains information about people, vacation locations, and when those people visited them.

The relations are:

Person(ID, Name)
Location(PlaceName, Country, MainAttraction)
Visited(ID, PlaceName, Year).

You should assume that place names are unique in the world.

Consider the schema given above.

(a) Give a primary key for each relation. Are there any relations for which there is an alternate candidate key which you have not chosen as the primary key? Why or why not?

(b) State all referential integrity constraints (inclusion dependencies) that should hold on these relations.

( c) Explain how the difference between an outer join and an inner join. What could be the use of each?

Explain what each of the following relational algebra queries would return:

a) π_PlaceNameσ_Year<2005(Visited)

b) π_Name(Person) ? (π_ID(Person) - π_ID(Visited)))

c) π_Name(Person) ? (π_ID,_PlaceName(Visited ÷ (π_PlaceNameLocation)))

Reference no: EM13187961

Questions Cloud

Explain method of production that lowers its marginal costs : The firm has an employee who threatens to tell all other firms in the industry about how to implement this new technique. Will it be possible to bribe the employee not to do this Explain why or why not. c What factors will determine the best numbe..

Define what is the reaction mechanism : What is the reaction mechanism (detailed with arrows) for trans-cinnamaldehyde when reacted with benzyltriphenylphosphonium chloride?

How long will it take the rock to hit : A canyon is 2000 meters deep at its deepest point. A rock is dropped from the rim above this point. Write the height of the rock as a function of time t in seconds. (Use -9.8 m/s2 as the acceleration due to gravity.) How long will it take the rock..

What is the EEOC : What is the EEOC? Explain how the EEOC influences human resources and hiring managers during the recruiting process.

How the difference between an outer join and an inner join : Give a primary key for each relation. Are there any relations for which there is an alternate candidate key which you have not chosen as the primary key? Why or why not?

Determine producer surplus plus consumer surplus : Assume the following values for Figures 5.4a and 5.4b. Q1=20 bags. Q2=15 bags. Q3=27 bags. The market equilibrium price is $45 per bag. The price at a is $85 per bag. The price at c is $5 per bag. The price at f is $59 per bag. The price g is $31 ..

How many of each type did the company sell that year : If the number sold of franchise A is twice the number sold of franchise C, how many of each type did the company sell that year.

Estimate the population and the rate of population growth : If t denotes the time in years after 1980, find a formula for N(t), the population in millions at time t. Assuming that this rapid growth rate continues, estimate the population and the rate of population growth in the year 2000.

Neoclassicism-impressionism and abstract expressionism : compares and contrasts Neoclassicism, Impressionism, and Abstract Expressionism. How each style reflects its era and the culture. Discussion of painting techniques. Formal elements

User Account

All Pages