QUIZ 3 Flashcards Preview

Business IT > QUIZ 3 > Flashcards

Flashcards in QUIZ 3 Deck (25)
Loading flashcards...
1
Q

RDBMS

A

(Relational Data-Base Management System)

terminology

design phases and techniques

2
Q

types of data and information found in organizations

A

levels

formats

granularities

3
Q

Transactional Data

A

all of the data contained within a single business process

primary purpose is to support performing daily operational tasks

4
Q

Analytical Information

A

all organizational information and its primary purpose is to support the performance of higher-level analysis tasks

5
Q

functions of database management systems

A

data filtering and profiling

data quality

data synchronization

data enrichment

data maintenance

6
Q

Relational DBMS

A

represent data as two dimensional tables called relations or files

7
Q

Physical/logical view of data

A

how data is organized

how data appearss

8
Q

entity
entity class
attributes

A

rows
tables
columns

9
Q

Data Definition Language (DDL)

A

data dictionary

10
Q

Data Manipulation Language (DML)

A

used to manipulate data

used to get data into and out of a database

11
Q

operations of a relational DBMS

A

select

Join

project

12
Q

Master data (attributes)

A

describes the core entities of the enterprise

13
Q

transaction data (specific)

A

activities or transactions

14
Q

Binaey Large Objects (BLOB)

A

digitized image and multimedia

15
Q

typical database design phases

A

requirement gathering

report design

data design

table design

form design

16
Q

Entity-Relationship Diagram (ERD)

A

methodology for documenting databases illustrating relationships between database entities

a key tool employed in the design of databases

17
Q

ERD parts

A

entity

relationship

connectivity

cardinality

business rules

18
Q

Query

A

set of instructions

select
criterion
parameter

19
Q

database normalization

A

process of removing redundant data from your tables tom improve storage efficiency, data integrity, and scalability

usually involves splitting existing tables into multiple ones

20
Q

three basic query operations to develop useful sets of data

A

select

join

project

21
Q

structured query language (SQL)

A

most popular query language

perform complicated searches by using relatively simple statements or key words

22
Q

DBMS products fall into two categories

A

enterprise DBMS

personal/desktop dbms

23
Q

Data warehouses/data marts

A

used for business decision-making purposes, data from many sources and over many time periods must be gathered together and organized in a consistent and useful way

24
Q

ETL

A

extraction, transformation, and loading

25
Q

characteristics of a data warehouse

A

organized by business dimension or subject

use inline analytical processing

integrated

time variant

non-volatile

multidimensional