• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/23

Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

23 Cards in this Set

  • Front
  • Back

DBMS and the 3 parts

Database Management Systems




Concept


Software application


course

RDBMS

Relational Database Manangement System

Whats largest DMBS?

Oracle

Largest ERP DBMS?

Enterprise Rescourse Planning




SAP


Systems, applications and products

ANSI

American National Standard Institute

Three lookup Brothers?

Lookup, Vlookup, Hlookup

Binary?

Divide by two


until remainder


count up to get binary code

Requires manunal commit to save but does auto save

oracle has savepoint and autocommitt for mircosoft sql and access

FTP

file transfer protocol

HTTP

Hyper text transmission protocol

5 computer languages

Machine


Assembly


Programming


Human


Natural




MAPHN

5 generations of computers

Vacuum


transistors


integrated circuits


microprocessors


artificial intelligences




VTIMA

!=

doesn't equal in sql

=

cell synchronization

*

wild card for excel and sql

Space holders

excel: ?


Sql: %

Excel


City <> "nyc"

Sql


City <> 'nyc'


city!='nyc'


or doesn't equal

phishing

attempt to scquire senstives information such as usernames, passwords and credit card details by masquerading as a trust worthy entity

3 Types of Realtionships amoung tables

1 to 1


1 to many


many to many

TSQL

Transact SQL and ANSI both microsoft server

primary key

uniquely identifies the most significant field in a table

Role of OS

Managing computer resources


provide user inference


security


computer processes

goal seek

backwards looks up solution through trial and error