Shared Flashcard Set

Details

Database Systems: Design, Implementationa and Management; 03
Ch3
7
Computer Science
Graduate
02/09/2010

Additional Computer Science Flashcards

 


 

Cards

Term

Q01:

 

What is the difference between a database and a table?

Definition
Term

Q02:

 

What does it mean to say that a database displays both entity integrity and referential integrity?

 

Definition
Term

Q03:

 

Why are entity integrity and referential integrity important in a database?

 

Definition
Term

Q04:

 

What are the requirements that two relations must satisfy in order to be considered union-compatible?

 

Definition
Term

Q05:

 

Which relational algebra operators can be applied to a pair of tables that are not union-compatible?

 

Definition
Term

Q06:

 

Explain why the data dictionary is sometimes called "the database designer's database"

Definition
Term

Q07:

 

A database user manually notes that "The file contains two hundred records, each record containing nine fields."

 

Use appropriate relational database terminology to "translate" that statement.

Definition
Supporting users have an ad free experience!