Consider the following database that contains information

Assignment Help Database Management System

Reference no: EM13380039

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

Questions Cloud

Erp software and service industryoriginally the sap erp : erp software and service industryoriginally the sap erp software was developed for and implemented by mostly

1 what is the role of the project manager why is : 1. what is the role of the project manager? why is leadership so important for project managers?2. discuss the

Fiction corporation is a large national retail chain of : fiction corporation is a large national retail chain of 10000 employees and 500 retail outlets. fiction is moving its

Your database has been a hit you have been called back to : your database has been a hit. you have been called back to the customers headquarters and they want a detailed report

Consider the following database that contains information : consider the following database that contains information about people vacation locations and when those people visited

Suppose we have a relation employees ssn name department : suppose we have a relation employees ssn name department salary.nbspfor each of the following queries either write the

1 a discuss the importance of scada securityb why are scada : 1. a. discuss the importance of scada security.b. why are scada systems particularly vulnerable to cyber treats? c.

Design reportthe design report is a single team report that : design reportthe design report is a single team report that describes the functionality of the application in its final

Question 1describe a malware attack that causes the victim : question 1describe a malware attack that causes the victim to receive physical advertisement.question 2suppose that a

User Account

All Pages