Shared Flashcard Set

Details

Terms
Database Systems & Team Projects
6
Computer Science
Undergraduate 2
01/26/2016

Additional Computer Science Flashcards

 


 

Cards

Term
A _____ _____ is a collection of high-level data description constructs that hide many low-level storage details
Definition
data model
Term
Most database management systems today are based on the _____ _____ _____
Definition
relational data model
Term
A _____ _____ _____ is a more abstract, high-level data model that makes it easier for a user to come up with a good initial description of the data in an enterprise
Definition
semantic data model
Term
A _____ is similar to a set in that it is an unordered collection of elements, but there could be several copies of each element, and the number of copies is significant-two multisets could have the same elements and yet be different because the number of copies is different for some elements
Definition
multiset
Term
We can think of * as shorthand for all the columns (in the cross-product of the _____-_____ in the FROM clause)
Definition
from-list
Term
In a _____ outer join, both Sailors and Reserves rows without a match appear in the result
Definition
full
Supporting users have an ad free experience!