Shared Flashcard Set

Details

Chapter 5
NA
27
Computer Science
Graduate
03/10/2014

Additional Computer Science Flashcards

 


 

Cards

Term
a ___ is a self describing collection of integrated records
Definition
database
Term
columns are also called ___
Definition
fields
Term
columns or fields are grouped into rows which are called ___
Definition
records
Term
a group of similar row or records is called a ___ or ___
Definition
table or file
Term
database is a collection of tables plus ___ among the rows in those tables, plus ___
Definition
relationships
metadata
Term
a ___ is a column or group of columns that identifies a unique row in a table
Definition
key (AKA: primary key)
Term
databases that carry their data in the form of tables that represent relationships using foreign keys are called ___
Definition
relational databases
Term
what does self-describing mean
Definition
a database contains, within itself, a description of its contents
Term
___ make database data more accessible and useful
Definition
database application system
Term
___ is a program used to create process and administer a database
Definition
database management system (DBMS)
Term
what are some popular DBMS products?
Definition
DB2
access
SQL Server
Oracle Database
MySQL
Term
What is a secondary function of a DBMS?
Definition
process the database.
Term
the DBMS provides applications for four processing operations. What are those operations.
Definition
Read
insert
modify
delete
Term
___ is an international standard language for processing a database
Definition
Structured Query Language (SQL)
Term
DBMS administrative functions include the following:
Definition
backing up database data
adding structures to improve the performance of DB applications
removing data that are no longer wanted or needed
Term
a ___ is a collection of forms reports queries and application programs that process a database
Definition
database application
Term
___is an issue when two users update the same data item, but only one of those changes is recorded in the data
Definition
lost update problem
Term
DBMS products fall into two broad categories. Name and describe them
Definition
Enterprise DBMS: processes large organizational and workgroup databases

Personal DBMS: designed for smaller simpler database applications (Fewer than 100 users)
Term
a ___ must be built before building the DB itself
Definition
data model
Term
a ___ is a tool for constructing data models
Definition
entry relationship (E-R) data model
Term
a ___ is something the users want to track
Definition
entity (the names of entities are always singular)
Term
entities have ___ that describe the characteristics of the entity
Definition
attributes
Term
entities also have an ___ which is an attribute, or group of attributes, whose value is associated with one and only one entity instance
Definition
identifier
Term
entities have ___ to one another
Definition
relationships (order has a relationship to customer)
Term
___ is the process of converting a poorly structured table into two or more well structured tables
Definition
normalization
Term
when is the easiest time to change the database structure?
Definition
during the modeling phase
Term
what is a a data integrity problem
Definition
when some rows indicate one name in the database, but another calls it by a different name.

I.E. Department 100 is "accounting and Finance" in one row. Another row calls it "accounting"
Supporting users have an ad free experience!