Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
25 Cards in this Set
- Front
- Back
True or false: The degree (or arity) of a relation is the number of fields.
|
True
|
|
True or false: an integrity constraint limits the data that can be viewed by a database user.
|
False
|
|
A superkey is...
|
something that specifies no two distinct tuples in any state r of R can have the same value for SK
|
|
What are the three levels of abstraction?
|
Physical, conceptual, external
|
|
What is a transaction?
|
Manipulation of data
|
|
What are the two kinds of data independence
|
Conceptual. logical?
|
|
What is program-data independence?
|
The structure of the data is stored in the DBMS catalog separately from the access programs.
|
|
What is atomicity?
|
Either all of the transactions are completed or none are.
|
|
What is the degree of a relation?
|
The number of fields.
|
|
What is a superkey?
|
A superkey specifies a uniqueness constraint that no two tuples have the same values.
|
|
What is cardinality?
|
The number of records.
|
|
What is the entity integrity constraint?
|
No primary key value can be NULL.
|
|
What is the referential integrity constraint?
|
A tuple in one relation that refers to another must refer to an existing tuple.
|
|
What is data independence?
|
Hide data representation, hide data storage.
|
|
What are advantages of a DBMS?
|
Access control, centralized data administration, efficient data access, data independence, crash recovery, concurrent access, etc
|
|
Disadvantages of a DBMS?
|
High maintenance, high startup cost.
|
|
What is meta-data?
|
Describes structure of database.
|
|
What is a tuple?
|
A row of related data
|
|
What is a domain?
|
A set of atomic values.
|
|
What is an integrity constraint?
|
a condition specified on a database schema that restricts the data that can be stored in an instance and is enforced by the DBMS.
|
|
What does it mean to be union-compatible?
|
Same number of fields, same domain for every corresponding field.
|
|
What is DDL?
|
Data definition language
|
|
What is DML?
|
Data manipulation language
|
|
What is SQL?
|
Structured query language
|
|
SQL statement to count the number of unique sailor names
|
SELECT COUNT(distinct S.Sname) FROM Sailors S
|