Shared Flashcard Set

Details

MISM CHPT 4
Database management and protocols
34
Management
Undergraduate 3
11/08/2012

Additional Management Flashcards

 


 

Cards

Term
Purpose of a database
Definition
Keep track of things
Term
Table
Definition

originally called "file" is an entity --> something you want to keep track of

each table has a single theme

used in DB

Term
Spreadsheet
Definition
single theme (topic/subject)
Term
entity
Definition
has to have a primary key (sometimes 2, b/c if you use just one, there could be multiple matches)
Term
Why is a database said to be a "self-describing collection of integrated recods"?
Definition
Because of metadata 
Term
Metadata
Definition
data that describes data (the type of datay - data type: string; text, memo, dat/time, currency, Yes/No, etc.)
Term
Attributes
Definition
listed under tables (what makes up a table) - describes an entity
Term
Record
Definition
rows in a database
Term
Field
Definition
collumn in a database
Term
Business
Definition
achieving goals & objectives
Term
Logistics
Definition
right product, right price @ right time
Term
TPS
Definition
transaction processing system - (day-to-day) feeds data to other information systems
Term
valid
Definition
what you want to test is what you're testing
Term
reliable
Definition
repeatable
Term
data
Definition
recorded facts and figures
Term
information
Definition
data in context
Term
LAN
Definition
local area network (same geographical boundaries; ex: on campus)
Term
WAN
Definition
wide area network (crosses geographical boundaries)
Term
Dirty data
Definition
duplicated data
Term
primary key
Definition
 has to be unique - it's the identifier used to relate to the other tables
Term
Why use numbers?
Definition
computers process numbers faster than anything
Term
Database
Definition
collection of tables, relationships, metadata
Term
datamodel
Definition
representation of how you see your business
Term
foreign key
Definition
copied from another table, creates a relationship with another table
Term
malformed table
Definition
poorly structured table
Term
best way to identify attributes
Definition
with numbers
Term
problem with creating another table
Definition
becomes slower
Term
data integrity
Definition
maintaining and assuring accuracy and consistency of data
Term
normalizing a table
Definition
getting rid of dirty data - each table has 1 (single) theme
AKA transforming - said to go into normal form 
Term
when would you use a non-normalized table?
Definition
if it's a simple business (ex: video rental) trying to run on low cost (one table)
Term
what type of DB would a small business most likely use?
Definition
Access, MySQL, XML --> all free
Term
What type of DB would a large business use?
Definition
SQL
Term
DB administration
Definition

person or group that administers DB - should never be a user of the DB b/c they can modify it to work best for their needs - not the good of the whole - has to be someone people feel comfortable to talk to;

help business acheive goals & objectives

Supporting users have an ad free experience!