CS3-CHAP4 DATA AND DATABASES Flashcards Preview

CS 3 INTRO TO PROGAMING > CS3-CHAP4 DATA AND DATABASES > Flashcards

Flashcards in CS3-CHAP4 DATA AND DATABASES Deck (39)
Loading flashcards...
1

Data warehouse:

Large scale electronic repository of data that contains and organizes all the data related to an organization in one place.

2

Data mart:

Small slices of data warehouse used in single department or by specific employee group to meet the particular demands of a specific group of users within the organization.

3

Data warehouses or marts are WHAT ONLY? 

READ 

4

Data mining:

process by which great amount of data are analyzed and investigated to spot customer trends. Is a process used by companies to turn raw data into useful information. By using software to look for patterns in large batches of data, businesses can learn more about their customers and develop more effective marketing strategies as well as increase sales and decrease costs.

5

Office Support System (OSS)

designed to improve communications and assist employees in accomplishing their daily task, such as Microsoft Office

6

Transaction Processing Systems (TPS)

 

keeps track of everyday business activities

7

Management Information System (MIS)

provides timely and accurate information that enables manager to make critical decisions

8

Decision Support System (DSS)

(DSS)

Designed to help manager develop solutions for specific problems

9

Enterprise Resource Planning System (ERP)

Broad-based software system that integrates multiple data sources and ties together the various processes of an enterprise

10

PRO AND CONS OF EXCEL DBMS

Only using one table or many unrelated tables

 Needs heavy computations  Needs charting
 Limited search operations

11

EVERYDAY USESAGE OF DATA BASES 

You logged in to this computer; You emailed a friend;
You searched for a topic;
You purchased grocery;

You called your parents; You put gas in your vehicle; And many more...

12

WHAT IS A DATABASE 

Collection of related data that is stored in a computer system

13

WHAT THE PROCESS OF A DATABASE 

Easily stored, sorted, organized, and queried

Turn data into Information

14

DATABASE ADVANTAGES 

Store and retrieve large quantities of information • Enable information sharing
• Provide data centralization
• Promote data integrity

• Allow flexible use of data

15

DATABASE DISADVANTAGES 

Complex to build and maintained

Time consuming • Expensive
• Privacyconcerns

16

WHAT IS REALATIONAL DATABASE? 

Organizes data in two-dimensional tables, rows and columns, format by logically grouping similar data in a relation

17

OBJECT ORIENTED DATABASE?

Storesdatainobjectsrather

than in tables

18

MULTIDIMENSIONAL DATABASE? 

Stores data in more than two dimensions

19

WHAT IS A FEILD?

A piece of information, such as:

Last name
 Address
 Phone number

 A quantity  A Picture

 

20

WHAT IS A RECORD?

A group of related fields, such as

 

 

A car’s make, color, model, price, mileage, etc.

Bank account record: person’s name, address, phone#, account number, balance, etc.

 

21

WHAT ARE TABLES? 

A group of related records, such as

 

 

Address table  Products table  Students table

22

DATA TYPE:

LOOKUP WIZARD 

 

 

ACCESS

EXAMPLE LOOK UP A state name from one 50 statesFROM WITHING THE DATABASE 

23

DATA TYPE:

TEXT?

Alphabetic or alphanumeric data

24

DATA TYPES

BOOLEAN?

Yes/No values

EXAMPLE :Married?

25

DATA TYPE:

OBJECT

Multimedia files or documents

26

There are certain field types which seems to be numeric,

but they really are text, such as:

Phone number

Room number

Social security number

Account number

Student ID

27

What is criteria to choose a text type or numeric?

If the field is used for counting and/or in calculations, you have to use numeric, otherwise you must use text.

28

ARE NUMBERS INCLUDED IN TEXT AND BLANK? 

Remember: text always includes numbers (0-9, as symbols), but these number are not involved in calculations or counting.

29

(DBMS) Operations

 

 

RE: ACCESS

 Create fields: name of field, type of field, length of field 

 Creates records: specify fields  specify primary key

 Enter values for records

30

DBMS

Validate data:

process of ensuring that data entered into the database is correct (or at least reasonable) and complete