Shared Flashcard Set

Details

Database Systems: Design, Implementationa and Management; 03
Ch3
7
Computer Science
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