Shared Flashcard Set

Details

CGS Terms
Data base management
38
Computer Networking
Undergraduate 3
07/10/2014

Additional Computer Networking Flashcards

 


 

Cards

Term
A DMBS provides a
Definition
variety of techniques to restore the database to a usable form in case it is damaged or destroyed
Term
Object-oriented databases often use
Definition
Object Query Language (OQL) to manipulate and retrieve data
Term
object-oriented database (OODB) stores
Definition
data in objects
Term
Multidimensional Databases
Definition
Higher level of organization vs. relational
Avoids complex queries
Term
data warehouse is a huge database
Definition
that stores and manages the data required to analyze historical and current transactions
Term
Database Administrator (DBA)
Definition
Creates and maintains the data dictionary, manages security, monitors performance, and checks backup and recovery procedures
Term
Database Analyst (DA)
Definition
Decides on proper field placement, defines data relationships, and identifies users’ access privileges
Term
Database analysts and administrators are responsible for
Definition
managing and coordinating all database activities
Term
DBMS Security
Definition
A DBMS provides means to ensure that only authorized users access data at permitted times
Access privileges
Principle of least privilege
Only data required for legitimate purposes can be accessed
Term
A report generator
Definition
allows users to design a report on the screen, retrieve data into the report design, and then display or print the report
Term
form
Definition
is a window on the screen that provides areas for entering or modifying data in a database
Simplifies data input (and validation)
Access: Create tab/Form Wizard
Term
A query
Definition
“answers a question” about your DB
e.g. What are the values of certain fields in a table
Term
query language
Definition
consists of simple, English-like statements that allow users to specify the data to display, print, or store
Term
e.g. SQL
Definition
– Structured Query Language
Term
Query by example (QBE) provides a GUI to assist users
Definition
with retrieving data
Can be created using Access
or your favorite DBMS
Term
Reports
Definition
format data for viewing
Term
A database schema
Definition
describes the structure of a database.
Term
metadata:
Definition
“data about data"
Term
A data dictionary describes
Definition
in detail every table, field, and relationship in the database.
Term
Data validation compares
Definition
data with a set of rules or values to find out if the data is correct.
Term
One-to-one (1:1)
Definition
Exactly one of second object occurs for each instance of first
‘1’ can include 0, but not always
Term
One-to-many (1:M)
Definition
One of first relates to many of second
Each second can only relate to one of first
Term
Many-to-many (M:N)
Definition
First can relate to many of second
Second can relate to many of first
Term
data model consists of rules
Definition
and standards that define how the database organizes data
Term
A relational database model
Definition
stores data in tables that consist of rows and columns
Term
Each row has a
Definition
primary key
Term
relationship is a
Definition
"link" between tables
Uses common fields
A foreign key is a primary key from one table that is included in a different table to form a relationship
Term
record
Definition
is a group of related fields in a table
Term
Records represent
Definition
instances of the table data
Term
A key is
Definition
used for identifying, sorting, and searching records.
Term
primary key
Definition
uniquely identifies each record
Term
field is a characteristic
Definition
of an object. It is a combination of one or more bytes (e.g. alpha-numeric characters). A field includes the following attributes:
Term
A table (data file)
Definition
represents an entity (object), which may be a person, place, thing
Term
A table
Definition
contains data records, which are made up of fields
Term
A database contains
Definition
multiple tables representing objects of interest
Term
Database software, often called a database management system (DBMS), allows users to:
Definition
Create a computerized database
Add, modify, and delete data
Sort and retrieve data
Create forms and reports from the data
Term
A database (DB)
Definition
stores data
Term
The management system (MS)
Definition
is an application which manages the DB
Supporting users have an ad free experience!