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;
14 Cards in this Set
- Front
- Back
the languages that comprise SQL
|
DML, DDL, DCL
|
|
DML is comprised of...
|
INSERT, DELETE, SELECT, UPDATE
|
|
DDL is comprised of...
|
CREATE, ALTER, RENAME, DROP AND TRUNCATE
|
|
DCL is comprised of...
|
GRANT and REVOKE
|
|
data model
|
a collection of conceptual tools for describing data, data relationship, data semantics, and consistency constraints.
|
|
Examples of DDL --->CREATION
|
CREATE... TABLE, TRIGGER, PROCEDURE, and SEQUENCE
|
|
What are the two types of DML?
|
Procedural and nonprocedural
|
|
What is procedural DML?
|
When the user specifies what data is needed and how to get it.
|
|
What is nonprocedural DML?
|
The user specifies only what data is needed.
|
|
What are the steps of the database planning life cycle?
|
Gather information
Object identification Object modeling Identification of information for each object Relationships identification between objects |
|
In DPLC what is...
data gathering |
tasks performed new requirements, old system and limitations, interview users
|
|
In DPLC what is...
objects identification |
Primary entities and related entities
|
|
In DPLC what is...
oject modeling |
Database model is created
|
|
In DPLC what is...
identification of information |
Where information for each object is stored...4 types of info for objects are... Catagorical, relational/referential, identifier, raw data columns
|