Shared Flashcard Set

Details

Introduction to SQL
Vocab for the SQL Datebase Chapter
6
Other
Undergraduate 3
03/19/2018

Additional Other Flashcards

 


 

Cards

Term
Relational DBMS (RDBMS)
Definition
A database management system that manages data as a collection of tables in which all data relationships are represented by common values in related tables
Term
Catalog
Definition
A set of schemas that, when put together, constitute a description of a database
Term
Schema
Definition
A structure that contains descriptions of objects created by a user, such as base tables, views, and constraints, as part of databases.
Term
Data definition language (DDL)
Definition
Commands used to define a database, including those for creating, altering, and dropping tables and establishing constraints.
Term
Date maniplulation language (DML)
Definition
Commands used to maintain and query a database, including those for updating, inserting, modifying, and querying data.
Term
Data Control language (DCL)
Definition
Commands used to control a database, including those for administering privileges and committing (saving) data.
Supporting users have an ad free experience!