CS3-CHAP4 DATA AND DATABASES

Question 1

Data warehouse:

Answer 1

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

Question 2

Data mart:

Answer 2

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.

Question 3

Data warehouses or marts are WHAT ONLY?

Answer 3

READ

Question 4

Data mining:

Answer 4

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.

Question 5

Office Support System (OSS)

Answer 5

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

Question 6

Transaction Processing Systems (TPS)

Answer 6

keeps track of everyday business activities

Question 7

Management Information System (MIS)

Answer 7

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

Question 8

Decision Support System (DSS)

Answer 8

(DSS)

Designed to help manager develop solutions for specific problems

Question 9

Enterprise Resource Planning System (ERP)

Answer 9

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

Question 10

PRO AND CONS OF EXCEL DBMS

Answer 10

Only using one table or many unrelated tables

 Needs heavy computations  Needs charting
 Limited search operations

Question 11

EVERYDAY USESAGE OF DATA BASES

Answer 11

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…

Question 12

WHAT IS A DATABASE

Answer 12

Collection of related data that is stored in a computer system

Question 13

WHAT THE PROCESS OF A DATABASE

Answer 13

Easily stored, sorted, organized, and queried

Turn data into Information

Question 14

DATABASE ADVANTAGES

Answer 14

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

• Allow flexible use of data

Question 15

DATABASE DISADVANTAGES

Answer 15

Complex to build and maintained

Time consuming • Expensive
• Privacyconcerns

Question 16

WHAT IS REALATIONAL DATABASE?

Answer 16

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

Question 17

OBJECT ORIENTED DATABASE?

Answer 17

Storesdatainobjectsrather

than in tables

Question 18

MULTIDIMENSIONAL DATABASE?

Answer 18

Stores data in more than two dimensions

Question 19

WHAT IS A FEILD?

Answer 19

A piece of information, such as:

Last name
 Address
 Phone number

 A quantity  A Picture

Question 20

WHAT IS A RECORD?

Answer 20

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.

Question 21

WHAT ARE TABLES?

Answer 21

A group of related records, such as

Address table  Products table  Students table

Question 22

DATA TYPE:

LOOKUP WIZARD

ACCESS

Answer 22

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

Question 23

DATA TYPE:

TEXT?

Answer 23

Alphabetic or alphanumeric data

Question 24

DATA TYPES

BOOLEAN?

Answer 24

Yes/No values

EXAMPLE :Married?

Question 25

DATA TYPE:

OBJECT

Answer 25

Multimedia files or documents

Question 26

There are certain field types which seems to be numeric,

but they really are text, such as:

Answer 26

Phone number

Room number

Social security number

Account number

Student ID

Question 27

What is criteria to choose a text type or numeric?

Answer 27

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

Question 28

ARE NUMBERS INCLUDED IN TEXT AND BLANK?

Answer 28

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

Question 29

(DBMS) Operations

RE: ACCESS

Answer 29

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

 Creates records: specify fields specify primary key

 Enter values for records

Question 30

DBMS

Validate data:

Answer 30

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

Question 31

VALIDATION RUKLES (DBMS)

Answer 31

Range check (within a check)

 Completeness check (required fields are filled)

 Consistency check (such as hiring date is after birth date)

 Alphabetic/numeric checks (text only, numbers only

Question 32

DBMS DATA VALIDATION:

Answer 32

a crucial part of any database system

 Some simple validations are supported

automatically by Access
 A non-numeric value is entered to a field which is

integer by definition.

 More Sophisticated validation are implemented by user

Question 33

• Garbage In, Garbage Out (GIGO)

Answer 33

no system can produce valid output from invalid input

Question 34

RELATINAL DATABASE OPERATIONS

Answer 34

Data are organized into tables

Relationships are links between tables with related data

Common fields need to exist between tables

Question 35

(DBMS)

TYPES of relationship:

Many-to-many:

Answer 35

for each record in first table, there are many record related records in second table, and conversely meaning for each record in the second table there are many related records in first table

Question 36

(DBMS)

TYPES of relationship:

One-to-many:

Answer 36

or each record in a table there is many related record in a related table (many means: 0, 1, or more)

Question 37

(DBMS)

TYPES of relationship:

One-to-one:

Answer 37

One-to-one: for each record in a table there is only one corresponding record in a related table

Question 38

DBMS Primary key:

Answer 38

A field that has a unique value for each record, such as:

 Student ID in a college
 California ID (driving license number) in California

Two tables are related by primary key and foreign key

Question 39

DBMS Normalization:

Answer 39

reduce redundancy in a database and improve data integrity AND each piece of information is stored in one place