Question 1

Given the relation Employees containing the attributes Name, Address, and BirthDate, what question is answered by the following sequence of operations?
Temp $\leftarrow$SELECT from Employees where BirthDate < "January 4, 1975"
Result $\leftarrow$ PROJECT Name from Temp
________________________________

Accepted Answer

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

Question 2

Place an X in the space before those requests below that require data mining techniques rather than traditional database techniques. Leave the other spaces blank.
_____ Identify all shoppers who bought dog food last week.
_____ Identify items that tend to be purchased by common shoppers.
_____ Identify any correlation between time-of-day and items purchased.
_____ Identify the items purchased during the first hour after opening the store.

Accepted Answer

The answer of Place an X in the space before...

Question 3

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 4

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 5

Place an X in the space before those questions whose answers might be obtained by means of sequential pattern analysis. Leave the other spaces blank.
_____ What are progressing stages in youthful behavior that led to criminal activity?
_____ What are the symptoms of the various stages of a particular progressing disease?
_____ What crimes does a particular judge punish most harshly?
_____ What items had the highest sales volume last week?

Accepted Answer

The answer of Place an X in the space before...

Question 6

List four data mining techniques.
_____________________
_____________________
_____________________
_____________________

Accepted Answer

The answer of List four data mining techniques.
_____________________
_____________________
_____________________
_____________________...

Question 7

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 8

Place an X in the space before those questions whose answers might be obtained by means of outlier analysis. Leave the other spaces blank.
_____ Which are the flawed parts on a production line conveyor belt?
_____ What items have not sold during the last two days?
_____ What sales region generated the most orders over the last sales period?
_____ Which shoppers in a busy shopping mall are potential shoplifters?

Accepted Answer

The answer of Place an X in the space before...

Question 9

The term "lossless decomposition" refers to a decomposition of one relation into several relations such
that _____________________________________________ .

Accepted Answer

The answer of The term "lossless decomposition" refers to a...

Question 10

Suppose a relation X had the attributes Name, EmployeeID, and Address. Complete the following statement to obtain a list of the names and addresses of all employees.
Result $\leftarrow$___________________________________ from X

Accepted Answer

The answer of Suppose a relation X had the attributes...

Question 11

Suppose a relation X had the attributes PartID (part identification number), StockGoal (quantity held when fully stocked), and CurrentQuantity (quantity actually in stock). Complete the following statement to obtain information about those parts that are not fully stocked.
Result $\leftarrow$SELECT from X where _________________________________________

Accepted Answer

The answer of Suppose a relation X had the attributes...

Question 12

Given the relation Employees containing the attributes Name, Address, and CurrentJobID and the relation Jobs containing the attributes JobID, SkillRating, Department, what question is answered by the following sequence of operations?

Accepted Answer

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

Question 13

Place an X in the space before those structures that are designed to provide efficient access to randomly chosen items. Leave the other spaces blank.
_____ Sequential file
_____ Indexed file
_____ Hash file
_____ Hash table

Accepted Answer

The answer of Place an X in the space before...

Question 14

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 15

Which of the operations SELECT, PROJECT, and JOIN are actually used when executing the following SQL instruction?
select A, B
from X
where C = D
________________________________

Accepted Answer

The answer of Which of the operations SELECT, PROJECT, and...

Question 16

In a relational database, information is presented as though it were stored in tables called
_________________ , each of which has columns called _________________ and rows
called _________________ .

Accepted Answer

The answer of In a relational database, information is presented...

Question 17

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

Accepted Answer

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

Question 18

Identify two database models.
____________________
____________________

Accepted Answer

The answer of Identify two database models.
____________________
____________________...

Question 19

Translate the following query into a single SQL statement.

Accepted Answer

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

Question 20

Place an X in the space before those issues that are not problems associated with data mining. Leave the other spaces blank.
_____ Cascading rollback
_____ Deadlock
_____ Incorrect summary problem
_____ Lost update problem

Accepted Answer

The answer of Place an X in the space before...

Quiz 8: Data Abstractions

List four data mining techniques. ___________ _ _ ___________

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.

The term "lossless decomposition" refers to a decomposition of one relation into several relations such that _____________________________________________ .

Suppose a relation X had the attributes Name, EmployeeID, and Address. Complete the following statement to obtain a list of the names and addresses of all employees. Result $\leftarrow$ ___________________________________ from X

Given the relation Employees containing the attributes Name, Address, and CurrentJobID and the relation Jobs containing the attributes JobID, SkillRating, Department, what question is answered by the following sequence of operations?

Place an X in the space before those structures that are designed to provide efficient access to randomly chosen items. Leave the other spaces blank. ___ Sequential file _ Indexed file _ Hash file ___ Hash table

Which of the operations SELECT, PROJECT, and JOIN are actually used when executing the following SQL instruction? select A, B from X where C = D ________________________________

In a relational database, information is presented as though it were stored in tables called _________ , each of which has columns called _ and rows called _________ .

Identify two database models.

Translate the following query into a single SQL statement.

Place an X in the space before those issues that are not problems associated with data mining. Leave the other spaces blank. ___ Cascading rollback _ Deadlock _ Incorrect summary problem ___ Lost update problem

Quiz 8: Data Abstractions

List four data mining techniques. _____________________ _____________________ _____________________ _____________________

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.

The term "lossless decomposition" refers to a decomposition of one relation into several relations such that _____________________________________________ .

Suppose a relation X had the attributes Name, EmployeeID, and Address. Complete the following statement to obtain a list of the names and addresses of all employees. Result ←\leftarrow← ___________________________________ from X

Given the relation Employees containing the attributes Name, Address, and CurrentJobID and the relation Jobs containing the attributes JobID, SkillRating, Department, what question is answered by the following sequence of operations?

Place an X in the space before those structures that are designed to provide efficient access to randomly chosen items. Leave the other spaces blank. _____ Sequential file _____ Indexed file _____ Hash file _____ Hash table

Which of the operations SELECT, PROJECT, and JOIN are actually used when executing the following SQL instruction? select A, B from X where C = D ________________________________

In a relational database, information is presented as though it were stored in tables called _________________ , each of which has columns called _________________ and rows called _________________ .

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

Identify two database models. ____________________ ____________________

Translate the following query into a single SQL statement.

Place an X in the space before those issues that are not problems associated with data mining. Leave the other spaces blank. _____ Cascading rollback _____ Deadlock _____ Incorrect summary problem _____ Lost update problem

List four data mining techniques. ___________ _ _ ___________

Suppose a relation X had the attributes Name, EmployeeID, and Address. Complete the following statement to obtain a list of the names and addresses of all employees. Result $\leftarrow$ ___________________________________ from X

Place an X in the space before those structures that are designed to provide efficient access to randomly chosen items. Leave the other spaces blank. ___ Sequential file _ Indexed file _ Hash file ___ Hash table

In a relational database, information is presented as though it were stored in tables called _________ , each of which has columns called _ and rows called _________ .

Identify two database models.

Place an X in the space before those issues that are not problems associated with data mining. Leave the other spaces blank. ___ Cascading rollback _ Deadlock _ Incorrect summary problem ___ Lost update problem