Quiz Unit 4.1

The amount of data increases ezponentially with time.

Data collected about user behavior and browsing patterns by monitoring users activities when they visit a web site.

Their content cannot be represented in a computer record like digital pictures, video, voice packets and musical notes.

No, data decays overtime.

No, data security, quality , and integrity are easily jeopardized.

A repository of subject oriented historical data that are organized to be accessible in a form readily acceptable for analytical processing.

• collection of data
• storage of data
• data warehouse or mart
• data analysis
• results from the data
• solutions from the data

• internal data
• external data
• personal data

Data is stored in a data warehouse or data mart.

• Online queries
• executive dashboards
• decision support system
• data mining

Process of extracting patterns from large sets of data.

A small data warehouse designed for a strategic business unit or department.

Both the data and knowledgeare presented to the users.

It porvides all users with access to all the data.

the same data is stured in many places.

When applications can't access data associated with other applications.

When various copies of the data don't agree.

Data meet certain constraints, such as on letters in a social security number field.

When applications and data are independent of one another, or when all applications are able to access the same data.

A binary digit; that is a 0 or a 1.

Binary means that a bit can consist only of a 0 or a 1.

A group of eight bits that represents a single character.

A byte can be a letter, number or a symbol.

A grouping of logically related characters into a small group of words, or a complete number.

A grouping of logically related fields.

Yes, a file or table are the same. They are a grouping of logically related records.

A database is a group of logically related files that stores data and the associations among them.

A definition of the way data in a DBMS are conceptually structured.

• Database Management System
• The software that provides access to a database.

A person, place, thing, or event about which information is maintained in a record.

Each characteristic or quality describing a particular entity.

The identifier field or attribute that uniquely identifies a record.

An identifier field or attribute that has some identifying information, but typically doesn't identify the file with complete accuracy.

• Entity Relationahip diagram
• A document that shows data entities and attributes and relationships among them.

• Entity Relationahip modeling
• The process of designing a database by organizing data entities to be used and identifying the relationships among them.

A grouping of entities of a given type.

A particular entity within an entity class.

An attribute that identifies an entity instance.

Entities have attributes, or properties, that describe the entitys characteristics.

Relationships between two items.

• one to one
• one to many
• many to many

In a one to one, a single entity instance of one type is related to a single entity instance of another type.

In a one to many example, a professor can have many courses, but each course can have only one professor.

In a many to many example, a student can have many courses, and a course can have many sturdents.

It's valuable because it allows database designers to talk with users throughout the organization.

A DBSM maintains the integrity of store data, manages security, user access, and recovers information in case of system failure.

Data model based on the simple concept of tables in order to capitalize on characteristics of rows and columns of data.

One big table that contains all of the records and attributes.

Structured Query Language

Query By Example

• Online Transaction Processing
• Online processing of business transactions as soon as they occur.

• Online Analytical Processing
• The analysis of accumulated data by end users.

The manner in which data are structured in a data warehouse so that they can be analyzed by different views or perspectives, which are called dimensions.

The more objective, rational, and technical types of knowledge.

The cumulative store of subjective or experiential learning; highly personal and hard to formalize knowledge. For example: skill sets, trade secrets, know how, expertise, expierences, insights, understanding, learning.

This knowledge is typically not recorded.

• Knowledge Management Systems
• Information technologies used to systematize, enhance and expedite intra and interfirm knowledge management.

The most effective and efficient ways to do things.