Database Flashcards
Database Management system (DBMS)
group of programs used as an interface between the database and its application programs or between a database and the users
structured Query language (SQL)
special-purpose programming language for accessing and manipulating data stored in a relational database
database activities
- Provides view of the database
- adding 7 modifying data
- storing & retrieving data
- Manipulating the data and generating reports
Data definition language (DDL)
- Collection of instruction and commands used to define and describe data and relationships in a specific database
- SQL is a DDL
Data dictionary
description of all the data used in the database
Advantages of data dictionary
- Reduced data redundancy
- Increased data reliability
- Assists program development
- easier modification of data
concurrency control
A method dealing with a situation where 2 or more people are trying to access the same record at the same
Query by example (QBE)
a visual approach to developing database queries or requests
Data Manipulation language (DML)
The commands that are used to manipulate the data in a database
manipulating data
- Selecting
- Projecting
- Joining
- Linking
Selecting
eliminating rows according to certain criteria
Projecting
eliminating columns in a table
Joining
combining two or more tables
Linking
combing two or more tables through common data attributes to form a new table with only the unique data attributes
