chapter 9

Question 1

database configuration

Answer 1

organized collection of data/ long term memory of an org

Question 2

ERP

Answer 2

enterprised resource planning
- monster databases
- custom (if big) and off the shelf (if small company)

Question 3

netsuite

Answer 3

off the shelf ERP for small orgs
- the orgs are big enough to need a system, but small enough to not need a custom made one

Question 4

flat file data management

Answer 4

aka legacy system
- redundancy
- no up to date info

bring over from exam 1

Question 5

database approach

Answer 5

pools data into 1 singular database used by all users
- no redundancy (element stored once)
- 1 update updates the whole system for everyone
-

Question 6

relational model

Answer 6

tables are connected

Question 7

database management system

Answer 7

roles and privileges, gatekeeper

Question 8

quiry

Answer 8

trying to grab something from database

Question 9

schema

Answer 9

tables

Question 10

SQL

Answer 10

standard quiry language aka sequel
- write code to grab from table

Question 11

sequel form

Answer 11

grabs

Question 12

sequel reports

Answer 12

returns

Question 13

downsides of everyone in org writing sequel

Answer 13

• can mess up database
• isnt worth time and effort to teach all employees

Question 14

record

Answer 14

all attributes about particular entity = record

Question 15

attribute

Answer 15

Every nugget of info about entity

Question 16

3 things SQL quiry will ask

Answer 16

• select
• from
• where

Question 17

SQL select

Answer 17

attribute nuggets you want

Question 18

SQL from

Answer 18

table you need to grab it from

Question 19

SQL where

Answer 19

parameters (dont always need one)

Question 20

database administrator

Answer 20

person in charge of database management system

Question 21

data dictionary

Answer 21

describes every data element in database
aka legend of column abreviations

Question 22

entity

Answer 22

anything youd like to know about __________ (inventory, customers, sales) not a cel

Question 23

ER diagram

Answer 23

entity relationship diagram
shows links/ relationships between tables

Question 24

relation

Answer 24

link/ connection between entities and tables

Question 25

ER box ER line

Answer 25

table link

Question 26

ER pros foot ER I

Answer 26

many 1

Question 27

primary key

Answer 27

unique identifier - can show up in other tables as normal attribute and become a link between 2 tables

Question 28

foreign/ secondary key

Answer 28

regular attribute in a table - can have multiple foreign keys

Question 29

importance of primary keys

Answer 29

1 record will have 1 primary key, but can have multiple foreign keys

Question 30

database anomalies/ integrity issue

Answer 30

if something is messed up in the database/ table

Question 31

deletion anomaly

Answer 31

deletion of data from a table

Question 32

update anomaly

Answer 32

data redundancy in unnormalized table

Question 33

insertion anomaly

Answer 33

data cannot be added to a table bc of its primary key

Question 34

normalizing tables

Answer 34

standardizing something, get something on equal footing ex: convert 1 company to LIFO to better compare the 2 companies

Question 35

File

Answer 35

All records = file