Accounting 3600 Chapter 4

Front 1

file based approach

Back 1

multiple files, ended up with many mater files

Front 2

database approach

Back 2

solution to the flawed file based approach; all facts stored in one location

Front 3

database management system dbms

Back 3

interface between the database and application programs that access the database

Front 4

data integration

Back 4

put all facts in one place

Front 5

data sharing

Back 5

share data across the organization

Front 6

data independence

Back 6

ability to change/update the data without changing the application program and reverse

Front 7

cross functional analysis

Back 7

allows for relationships among data items to be investigated/exploited

Front 8

logical view

Back 8

the way different users conceptually see/understand data ex: data, charts

Front 9

physical view

Back 9

where/how the data is actually stored

Front 10

schema

Back 10

logical structure of the database

Front 11

1. conceptual level schema
2. external level schema
4. internal level schema

Back 11

3 levels of schema (Logical structure of the database)

Front 12

conceptual level schema

Back 12

organizational wide view of all data in database

Front 13

external level schema

Back 13

consists of all different logical views of the different users, each individual has a different logical view

Front 14

sub schema

Back 14

each individual has a different logical view

Front 15

internal level schema

Back 15

low level view, correlates with the physical view, describe how and where the data is stored

Front 16

data dictionary

Back 16

describes structure of database; for every data element contained in the database, there should be an entry in the ____ describing the key things about that data element

Front 17

dbms language

Back 17

every dbms needs to provide a means of performing

Front 18

1. creating database
2. changing database
3. performing queries/querying the database

Back 18

3 basic tasks of the dbms language

Front 19

1. data definition language ddl
2. data manipulation language dml
3. data query language dql

Back 19

3 dbms languages

Front 20

data definition language

Back 20

set of commands used to
1. actually create the database
2. build the data dictionary
3. describe the logical view for different users
4. define security restrictions on different users

Front 21

data manipulation language

Back 21

set of commands used to for data maintenance, includes updating, inserting and deleting data from databases

Front 22

data query language

Back 22

set of commands that allow user to ask database questions

Front 23

data warehouses

Back 23

large databases containing large quantities of both detailed and summarized data spanning many years

Front 24

1. online analytical processing
2. data mining

Back 24

2 ways to access data in warehouse

Front 25

online analytical processing

Back 25

the use of queries to investigate hypothesized relationships among the data

Front 26

data mining

Back 26

no hypothesis, using advanced statistical techniques to discover relationships among data

Front 27

scrubbing

Back 27

verifying the accuracy of the data contained in the data warehouse

Front 28

data model

Back 28

abstract model/representation of the contents of a database; virtually all dbms use relational data model

Front 29

relational datamodel

Back 29

database contents appear to be stored in tables (logical view, conceptual view schema)

Front 30

relation

Back 30

each table within a relational database

Front 31

tuple

Back 31

each row in a table

Front 32

primary key

Back 32

attribute or combination of attributes that uniquely identify each row in a table

Front 33

foreign key

Back 33

attribute/column in one table that serves as a primary key in another table; not a requirement for a table; connects different tables together and makes running queries possible

Front 34

referential integrity rule

Back 34

foreign key can be null or have values that correspond to a primary key in another table