Cis Lecture 3

Front 1

what is a database?

Back 1

collection of data organzied so that you can access, retrieve, and use it

Front 2

a database software allows you to what..?

Back 2

1. create database
2.add, change, and delete data
3.sort and retrieve data
4.create forms and reports

Front 3

what is the difference between data and information?

Back 3

data- raw facts
information- data that is organized and meaningful

Front 4

what is data integrit? GIGO?

Back 4

-degree to which data is correct

-Garbage in/ Garbage out... computer phrase that means that you can not create correct information from incorrect data

Front 5

what are the qualities of valuable information?

Back 5

accurate, verifiable,timely organized, accessible, useful, cost effective

Front 6

what is a heirarchy?

Back 6

-database contains files, files contains records, records contain feild, feilds contains characters

Front 7

what is a feild? feild character? feild name? data type?

Back 7

-combination of one or more characters( smallest unit)

-maximum number of characters a feild can contain

-uniquiley identifies each feild

-specifies kind of data feild contains

Front 8

what is a record?

Back 8

a group of related feilds

Front 9

what is a data feild?

Back 9

a collection of related records stored on a disk

Front 10

what is file maintenace?

Back 10

procedures that keep data current:
1.Adding records
2.Changing records
3.Deleting records

Front 11

what is validation?

Back 11

process of comparing data with a set of rules to find out if data is correct

Front 12

what are the types of validity checks?

Back 12

1.Check Digit
2.Alphabetical/ Numeric Check
3.Completeness check
4.Racnge check
4.Consistency check

Front 13

what is file processing system? what are problems with this?

Back 13

each department or area within organizaton has own set of files

-records in one file may not relate to records in any other file or data reduncy (same feilds stored in multiple files)

Front 14

what is database approach?

Back 14

many programs and users can share data in a database
-secures data so only authorized users can access certain data

Front 15

how do database application and a file processing application differ in the way they store data?

Back 15

file proces- data is duplicated

database app.- only membership code is duplicated

Front 16

what are popular datbase management systems(DBMS)?

Back 16

access, abadas, D3, DB2, Essbase

Front 17

what is data dictionary?

Back 17

contains data about each file in database and each feild within those files

Front 18

what is a query?

Back 18

reuest for a specific data from a database

Front 19

what is a report generator?

Back 19

allows user to design a report on screen, retrieve data into report design, then display or print reports

Front 20

what is a data security?

Back 20

DBMS provides means to ensure only authorized users can access data

Front 21

what are access priveleges and what are the 2 types?

Back 21

define actities that a specific user or group of users can perform

1.read-only priveleges(user can view data, but can't change it)
2.full- update priveleges

Front 22

what is a data model and the four mostpopular models?

Back 22

-rules and standards that define how database organizes data and defines how users view organization of data


1.relational
2.object- oriented
3.object relational
4.multi-dimensional

Front 23

what is relational database?

Back 23

stores data in tables that consists of rows and columns

-each row has primary key
each column has unique name

Front 24

what is a relatuionship?

Back 24

connection within data

Front 25

what is structured query language (SQL)?

Back 25

allows u to manage update and retrieve data

Front 26

what is a data warehouse? data mining? data mart?

Back 26

-huge data base system that stores and manages data required to analyze historical and current transactions

-process to find patterns and relationships among data

-smaller version of data warehouse

Front 27

what are the guidelines for developing a database?

Back 27

1. determine the purpose of the database
2.design the tables
3.design the records and feilds for each table
4.determine the relationship among the tables

Front 28

what is computer security risk?

Back 28

action that causes loss of or damage to computer system

Front 29

what is a virus, worm, trojan horse, payload?

Back 29

-potentially damaging computer program

-copies itself repeatedly, usin up resources and possibly shutting down computer or network

-hides within or looks like a legitimate program until triggered (doesn't replicate itself on other computers)

-destructive event that is delivered when u open a file run infected program, etc

Front 30

what is an anti-virus program?

Back 30

identifies and removes computer viruses, most protect against trojan horses and worms

Front 31

what is a virus signature?

Back 31

-specific pattern of virus code
-antivirus programs look for virus signatures

Front 32

what are quarentines?

Back 32

infected files that it cannot remove

Front 33

how does an antivirus "inoculate" a program file?

Back 33

1. records info about program(file size)
2.uses info. to detect if virus tampers w/ file
3. attempts to remove any detected virus

Front 34

what are some tips for preventing worms, trojan horse infections, viruses?

Back 34

1.install antivirus program
2.install a personal firewall program
3.never open an email attachment unless ur expecting or know what it is

Front 35

what is spoofing?

Back 35

makes a network or internet transmission appear legitimate

Front 36

what is a firewall?

Back 36

security system consisting of hardware/ or software that prevents unauthorized network access

Front 37

what is a personal firewall utility?

Back 37

program that protects personal computer and its data from unauthorized intrusions (informs you of attempted intrusions)

Front 38

how can companies portect against hackers?

Back 38

1.intrusion detection software
2.access control
3.audit trail

Front 39

what is user name? password? how can u make passwords more secure?

Back 39

-unique combination of characters that identifies user

-private combination of characters associated w/ the username that allows access to computer resources

-make them longer

Front 40

what is a biometric device?

Back 40

authenticates persons identity buy using personal characteristics

Front 41

what is a license agreement? encryption?

Back 41

right to use software

-safeguard against information theft

Front 42

what is a ceritificate authority?

Back 42

authorized person or comapny that issues and verifies digital certificates

Front 43

what is a secure sockets layer (SSL)?what a

Back 43

provides encryption of all data that passes between client and internet server

Front 44

what are computer ethics? IT code of conduct?

Back 44

-moral guidelines that govern use of computers and information systems

-written guideline that helps determine whether computer action is ethical (employers can distribute to employees)

Front 45

what is information privacy?

Back 45

right of individuals and and companies to restrict collection and use of info. about them

Front 46

what is an electronic profile?

Back 46

data collected when u fill out form on the web

Front 47

what is a cookie?

Back 47

small file on ur computer that contains data about u

Front 48

what is spyware, adware, and spam?

Back 48

-program placed on computer without users knowledge
-displays online advertisments
-unsolicited e-mail message sent to many recipients

Front 49

what is phishing?

Back 49

scam in which a perpertrator sends an official looking email that attempts to obtain ur personal info.

Front 50

what is content filtering? web filtering?

Back 50

-process of restricting access to certain material
-retricts access to specified sites