Chapter 1 Vocab

Question 1

Structured Data

Answer 1

1. numeric, character, and dates

2. stored in tabular form (tables, relations, arrays, spreadsheets)

Question 2

Unstructured Data

Answer 2

multimedia data

Question 3

Database

Answer 3

an organized collection of logically related data

Question 4

Data

Answer 4

stored representations of objects and events that have meaning and importance in the user’s enviornment

Question 5

Information

Answer 5

data that has been processed in a way to increase the knowledge of the person who uses the data

increases knowledge

Question 6

Metadata

Answer 6

data that describes the properties or characteristics of end-user data and the context of that data

Question 7

Database Application

Answer 7

an application program that is used to perform a series of database activities
ex. create, read, update, and delete

Question 8

Data Model

Answer 8

graphical systems used to capture the nature and relationships among data

Question 9

Entity

Answer 9

A person, a place, an object, an event, or a concept in the user enviornment about which the organization wishes to maintain data

Question 10

Relational Database

Answer 10

A database that represents data as a collection of tables in which all data relationships are represented by common values in related tables

Question 11

Database Management System (DBMS)

Answer 11

a software system that is used to create, maintain, and provide controlled access to used databases

Question 12

Data Independence

Answer 12

the separation of data descriptions from the application programs that use the data

Question 13

User View

Answer 13

a logical description of some portion of the database that is required by a user to perform some task

Question 14

Constraint

Answer 14

a rule that cannot be violated by database users

Question 15

Computer-aided Software Engineering (CASE) tools

Answer 15

software tools that provide automated support for some portion of the systems development process

Question 16

Repository

Answer 16

a centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components

Question 17

Enterprise Data Modeling

Answer 17

the first step in database development, in which the scope and general contents of organizational databases are specified

Question 18

Systems Development Life Cycle (SDLC)

Answer 18

the traditional methodology used to develop, maintain, and replace information systems

Question 19

Conceptual Design

Answer 19

a detailed, technology independent specification of the overall structure of organizational data

Question 20

Logical Schema

Answer 20

the representation of a database for a particular data management technology

Question 21

Physical Schema

Answer 21

specifications for how data from a logical schema are stored in a computer’s secondary memory by a database management system

Question 22

Prototyping

Answer 22

an iterative process of systems development in which requirements are converted to a working system that is continually revised through close work between analysts and users

Question 23

Agile Software Development

Answer 23

an approach to database and software development that emphasizes individuals and interactions over processes and tools, working software over comprehensive documentation, customer collaboration over contract negotiation, and response to change over following a plan

Question 24

Project

Answer 24

a planned undertaking of related activities to reach an objective that has a beginning and an end

Question 25

Enterprise Resource Planning (ERP)

Answer 25

a business management system that integrates all functions of the enterprise (manufacturing,sales, finance, marketing, inventory, accounting, HR)

Question 26

Data Warehouse

Answer 26

an integrated decision support database whose content is derived from the various operational databases