Question 1

Given the relation Parts containing the attributes PartName,PartNumber,and SupplierID as well as the relation Suppliers containing the attributes SupplierID,Address,FaxNumber,write a sequence of SELECT,PROJECT,and JOIN operations to obtain the supplier identifications and fax numbers for all the suppliers that supply the part whose part number is X4J26.

Accepted Answer

The answer of Given the relation Parts containing the attributes...

Question 2

What does it mean to say that an object is persistent?

Accepted Answer

The answer of What does it mean to say that...

Question 3

Describe the wound-wait protocol.

Accepted Answer

The answer of Describe the wound-wait protocol....

Question 4

Describe a scenario in which computing the total deposits in a bank while also transferring $100 from account X to account Y would result in a final sum that is $100 too great.Then describe a scenario in which the final sum turns out to be $100 too small.

Accepted Answer

The answer of Describe a scenario in which computing the...

Question 5

Given a relation called People whose attributes are Name,Father,and Mother (containing each person's name as well as the name of that person's parents),write an SQL statement to obtain a list of all the children of Nathan.

Accepted Answer

The answer of Given a relation called People whose attributes...

Question 6

Describe the distinction between a traditional database and a data warehouse.

Accepted Answer

The answer of Describe the distinction between a traditional database...

Question 7

Given the relation Parts containing the attributes PartName,PartNumber,and SupplierID as well as the relation Suppliers containing the attributes SupplierID,Address,FaxNumber,write an SQL statement to obtain the supplier identifications and fax numbers for all the suppliers that supply the part whose part number is X4J26.

Accepted Answer

The answer of Given the relation Parts containing the attributes...

Question 8

Translate the following query into a single SQL statement.
Temp ← SELECT from X where A = B
Result ← PROJECT A,C from Temp

Accepted Answer

The answer of Translate the following query into a single...

Question 9

What information is available from a relational database containing one relation with the attributes Name,Employee identification number,and Address that is not available from a database containing two relations,one with attributes Name and Address and the other with attributes Address and Employee identification number? Explain your answer.

Accepted Answer

The answer of What information is available from a relational...

Question 10

Given the two relations X and Y below
  
draw the relation Result that would be produced by the following statements?
Temp ← JOIN X and Y where X.A > Y.D
Result ← PROJECT X.B,Y.C from Temp

Accepted Answer

The answer of Given the two relations X and Y...

Question 11

Describe the distinction between class description and cluster analysis.

Accepted Answer

The answer of Describe the distinction between class description and...

Question 12

If a database contained a relation containing information about individual people (name,address,birthday,etc.)and another relation containing information about music composers (name,style,education level,etc.),how would you extend the database's design to include links between each individual and his or her favorite composer?

Accepted Answer

The answer of If a database contained a relation containing...

Quiz 9: Database Systems