mis exam 1

Helpfulness: +1
Set Details Share
created 6 years ago by collegestudent4lyfe
205 views
first exam
Grade levels:
College: Third year
show moreless
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
Show:
1

Access

database management system

2

attributes

columns

3

entity

tables

4

data model

logical representation of database data

5

database

self-describing collection of integrated records

6

DBMS

(database management system)- program used to create, process, and adminster a database

7

entity relationship diagram

tool for constructing data models

8

fields

columns

9

form

read,insert,modify, and delete data

10

normalization

process of converting poorly structured table into two or more well-structured tables

11

primary key

a column or group of columns that identifies a unique row in a table

12

foreign key

keys in a different table than the one they reside in

13

query

request for data from a database

14

record

a row

15

relation

represents a relation using foreign keys

16

report

show data in a structured context

17

row

record

18

SQL

(structured query language)- international language used for processing a database

19

table

group of similar rows or records

20

HUB

sends packet of information to all computers

21

router

moves packet traffic according to rules of IP protcol

22

switch

a special-purpose computer that receives and transmits data across a network

23

web

internet based network of browsers and servers that process http or https

24

virtual

virtual world within computer

25

vertical market application

serves needs of specific industry

26

horizontal market application

software that provides capabilities across the industry

27

URL

uniform resource locator
a documents address on the web

28

thick client

application needs preinstallation

29

thin client

application that runs within a browser and doesn't need preinstallation

30

TCP/IP

transmission control protocol

31

RAM

random access memory
main memory consisting of cells that hold data or instructions

32

protocol

set of rules that 2 communication devices follow

33

packet

piece of a message handled by programs that implement IP

34

operating system

program that controls the computer resources

35

non-volatile

content survives after machine is turned off

36

volatile

content is lost when machine is turned off

37

machine language

source code read by computers

38

license

to use a program

word office

39

IP address

series of dotted decimals in a format that identifies a unique device on a network or internet

40

html

hypertext markup language

41

hardware

computer itself
monitor

42

software

goes on the hardware

word office the sims

43

FTP

file transfer protocol
layer-5 protocol used to copy files from one computer to another

44

custom developed software

tailor made software

45

cloud computing

organization obtain server resources from vendor that specialize in server processing

46

CPU

center processing unit
"brain of the computer"

47

client

computer that provides word processing, spreadsheets, database access and usually a network connection

48

server

provides service

49

byte

bites grouped into 8 bit chunks

50

binary digit

either 0 or 1

51

LAN

local area networks
small like home

52

WAN

wide area networks

web

53

business processes

a sequence of activities for accomplishing a function

54

information

data factors
accurate,timely, complete, revelant, correct and granulant, easy to use

55

information quality

knowledge derived from data

56

five forces model

accesses industry characteristics and profitability by means of 5 competitive forces
bargaining power of suppliers, threat of substitution, bargaining power of customers, rivalry among firms, and threat of new entrants

57

systems and systems thinking

components working together to accomplish a goal

58

moore's law

number of transistors per square inch on an integrated chip doubles every 18 months

59

collaboration

...

60

one-to-many relationship

involving 2 entity types in which an instance of one type can relate to many instances of the second type

61

one-to-one relationship

involving 1 instance to another instance