Shared Flashcard Set

Details

MIS
MANAGEMENT INFO
35
Business
Undergraduate 4
06/06/2011

Additional Business Flashcards

 


 

Cards

Term
JUNE 6 (BASIC CONCEPTS PART 1)
Definition
Term
WHAT IS A DATABASE
Definition
-a collection (or container) of data/information.
-it is organized and structured (like a computer/ folders/subfolders)so it can be EFFICIENTLY accessed, updated, secured, etc
(photos of students in UT database)
(is a box from the past a database?)(well is it organized?)
HUMANS CONTROL DATABASES.. operating systems by themselves ARE NOT databases
Term
What are some examples of databases..what have you used recently
Definition
*current class roster (recent add/drops)
-easy acces...who added?? which one person? UT has collective database not single..prof had to compare and do most of the work himself. not convenient. yes
*google searches-No/yes...directory of databases. ehh
*McDonalds-cash register keeps and tracks sales and food..provides insight to customer behavior.
Term
more examples of databases
Definition
Home depot- similar to mcdonalds
Police-tickets, drunk driving...all info is entered into database.
Stock market
Weather channel
Term
How are these examples of DB's similar and different? Mcdonalds homedepot
Definition
Mcdonalds vs. Homedepot
--databases are identical
--similar--no negotiation w/in system (2x4,coffee)
--difference--aging products and shelf life
--inventory for multiple stores..(out of 2x4's send to different store that has them)
returning things
Simalar but with adjustments
Term
weather and stock market
Definition
observes trends, past and history ...uses complex mathematics. very similar, but nothing like homedepot vs mcdonalds
Term
DBMS COMPONENTS
Definition
Term
1.Anatomy of a DBMS (1.components) Data Definition (1.data, 2.indices)
Definition
--1.Raw data/info (names, ids, grades, info) --2. Indices- indexes/ pointers that guide you to the right page/place. Keyword searching capabilities. takes up a lot of storage space Google is 100% indices UT web-More data, less indices
Term
2.Data Manipulation (1.gui(unclebob) 2. 4gl (modern language)3. 3gl (manipulation of old databases)
Definition
-- 1. GUI interface--allow you to answer easy questions...aimed at "bob's"
--2. 4GL query processors-SQL dominant language of computer. all corporate databases support SQL (used by trained professionals)
--3. 3GL manipulation( cobalt) old language ability to link old system with new.
Term
3.Data Control (1. maintenence 2. security)
Definition
1.) Maintenance-...housecleaning caused by changing and rearranging data
2.) security- database crashes...back ups
Term
index
Definition
Pointers...like the back of a book that guide you to the right place/page ...searches...
Term
HOW IS A DATABASE USED???
BLACK-PRESENT OPERATIONAL VS. WHITE-FUTURE RESEARCH AND PREDICT
Definition
(Black) Operational/Transactional Databases (most used)
1.Ongoing Business activities
2.Dynamic Data
3.Examples
inventory control
Accounting records
Order processing
Scheduling
4.Transaction Processing Systems (TPS)

(White) Analytical/DSS Databases
1. Historical/ Time-dependent Data
2. Static Data
3. Examples
Census/Demographic Records
Sales Forecasting
4. Decision Support Systems
5. Data Mining/Business Intelligence
6. Business Analytics
****this observes the changing over time (stock market)
Term
JUNE 7 (BASIC CONCEPTS PART 2)
Definition
Term
corporate america segratages info
Definition
time frame may,june etc., or by type (male female) designing a database is maliable...and is flexible dependent on who is setting it up.
Term
segrigation of info
Definition
is solely your choice.
Term
DATA ORGANIZATION
Definition
Term
DATABASE MODEL
Definition
-logical design or organization of data -reflects basic structure "parent-child" "belongs to" "ownership " -may translate into physical file structure (hand drawn model that links to the actual database)
Term
hierarchical database model (HDM)
Definition
Inverted tree (with single root) -parent to child (who do you belong to) college (communication) staff-------Department(adv) staff-----instructor course/section student
Term
relational database model
Definition
edgar codd a relational model for large shared databases...came up with a new way to organize data. 

 mathematical/non structural approach

his idea was turned down by ibm and got picked up by oracle 

Term
RDM
Definition
-model is so easy to use/ abuse
Term
Basic terminology
Definition
3 relationships
man-women 1:1(one to one)dont happen often
one to Many (1:N)-happen the most
Many-Many (M:N)( happen all the time
Term
JUNE 8
ER DIAGRAMS
ROLE OF KEYS PK&FK
M:N RELATIONSHIPS (BRIDGES)
MICROSOFT VISO TOUR
ALTERNATIVE DB MODELS
Definition
Term
relationships w/in tables
Definition
bianary (2 people, 2 relationships, 2 tables)
Uniary-(loops)2 people, 2 relationships, ONE table
Term
keys
Definition
Primary key ___(pk)
Uniquely identifies record in a table
Foreign Key___(fk)
Uniquely identifies the "parent"record
Term
How do you represent a 1:N relationship
Definition
1.Child record "Points" to its parent record
2.Fk in the child table is the PK of the Parent table
1 to many (point up)
1:1- place restriction-no two men can have the same wife

How do you represent a M:N relationship?
Break the relationship into two 1:N relationships
Store these new relationships as FK's in a new "bridge" or "composite" table.
Term
SQL
Definition
  • DDL-....CREATE....ALTER....DROP
  • DML-...SELECT...INSERT...UPDATE...DELETE
  • DCL...GRANT...REVOKE...DENY
Term
DDL
Definition
Term

DDL: Data Definition Language 

Definition

 

CREATE---LAND READY,READY TO GO

ALTER---REMODELING, ADDING ROOMS..ALLOWS TO MODIFY ONE TABLE/OBJECT AT A TIME...(EX. UTEID)

DROP---BULLDOZER...KNOCKING OUT WHAT IS NO LONGER NEEDED...THERE IS NO UNDO.

Term
CREATE, ALTER, DROP
Definition
  • CREATE TABLE
  • CREATE INDEX 
  • ALTER TABLE
  • DROP TABLE
  • DROP INDEX
*THERE ARE MANY OTHER VARIATIONS OF THE CREATE,ALTER, AND DROP COMMANDS.
Term
CREATE TABLE SYNTAX
Definition

CREATE TABLE TBL NAME (

COLUMN NAME 1 DATA TYPES ATTRIBUTES, 

COLUMN NAME 2 DATA TYPES ATTRIBUTES,

TABLE ATTRIBUTES)

 

 

Term
CREATE TABLE
Definition

CREATE TABLE TABLE NAME(

COLUMN NAME DATA TYPE ATTRIBUTES,


COLUMN NAME

*USE LETTERS AND DIGITS ONLY

NO RESERVED WORDS IN COLUMN

AVOID SPECIAL SYMBOLS

EX...(FIRST NAME) 

 

DATA TYPE

CHAR (X)- (JOHN MOTE)

VARCHAR (X)

INT

DECIMAL (X,Y)

MONEY

DATE/TIME

 

ATTRIBUTES

NULL OR NOT NULL

DEFAULT VALUES

PRIMARY KEYS 

REFERENCES (FK'S)

CHECK CONSTRAINTS (VALIDATING VALUES)

 

Term
employee table simple PK
Definition

CREATE TABLE tblEmployee(

  • FirstName Varchar(20) Not Null
  • MiddleName Varchar(20) Null,
  • Last Name Varchar (30) Not Null, 
  • EmployeeID Int (10) identity Primary Key, 
  •  PayType Char (1) Not Null Default "H"             Check (paytype='H' or pay type='F'),
  • PayRate   Money    Not null                           check  (payrate>0))

 

*primary keys cannot be null 

*Primary keys must be unique 

*Identity works for intergers (do not fill gaps)

 check constraignts 

 

Term
Check number of characters in X
Definition

LenX counts number of charactars in X 

LastName Varchar (30) Not null 

Check (LEN(Last Name)>=2),

Zip Char (5) Not null 

Check (LEN (Zip =5) or Check (LEN(zip=10)

 

Term
Create Clustered index 
Definition

Clustered Index index name 

On table name(Column Name 1 order, 

ect :)

 

Supporting users have an ad free experience!