Term
|
Definition
| used to easily calculate totals for groups of records returned by the query specifications. Can calculate the sum, minimum, maximum, average, count, variance, and standard deviation |
|
|
Term
|
Definition
| getting to know the application. Computer technology appropriate? How? Defining processing, requirements, constraints, costs, and benefits. Developing functional specifications and prototypes. Reviewing specifications and prototypes |
|
|
Term
|
Definition
| also called fields or columns, are characteristics or properties of an entity class |
|
|
Term
| Concatenated (composite) primary key |
|
Definition
| Also known as composite primary key is a combination of two or more column values used to define a key in a table. |
|
|
Term
|
Definition
| entity relationship attribute diagrams; modeling doesnt focus on a particular technology |
|
|
Term
| Critical Success Factor (CSF) |
|
Definition
| a factor that is critical to an organizations success |
|
|
Term
|
Definition
| a process that begins with developing an understanding of user requirements (functional and performance) and using those requirements to create a system that effectively manages data |
|
|
Term
| Database Management System (DBMS) |
|
Definition
| software through which users and application programs interact with a database |
|
|
Term
|
Definition
| maintains information about various types of objects (inventory), people (employees), events (transactions), and places (warehouses |
|
|
Term
|
Definition
| putting together the parts (software, hardware, people, procedures, data) to provide the functionality with the right operating characteristics within budget on schedule |
|
|
Term
|
Definition
| build technical architecture. Build the database and programs. |
|
|
Term
|
Definition
| sometimes called a table, is a person, place, thing, transaction, or event about which information is stored |
|
|
Term
| Entity Relationship Diagram (ERD) |
|
Definition
| a technique for documenting the relationships between entities in a database environment |
|
|
Term
|
Definition
| a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables |
|
|
Term
|
Definition
| a graphical representation of a table. Used to add, update, and delete records in your table. |
|
|
Term
|
Definition
| What functions (tasks) the system must be able to do |
|
|
Term
|
Definition
| Install system into the organization. User documentation. Training. |
|
|
Term
|
Definition
| choosing a modeling environment: relational; object; hierarchical; network |
|
|
Term
|
Definition
| build a help desk to support system users. Provide an environment to support system changes |
|
|
Term
|
Definition
| a relationship thats between two entities in which an instance of entity A can be related to zero, one, or more instances of entity B and entity B can be related to zero, one, or more instances of entity A |
|
|
Term
|
Definition
| a relationship between two entities in which an instance of entity A can be related to zero, one, or more instances of entity B and entity B can be related to only one instance of entity A |
|
|
Term
|
Definition
| a relationship between two entities in which an instance of entity B and entity B can be related to only one instance of entity A |
|
|
Term
|
Definition
| How well does the system perform those tasks |
|
|
Term
|
Definition
| the organization of data on the physical devices of the computer system are laid out |
|
|
Term
|
Definition
| Define the system to be developed. Set the project scope. |
|
|
Term
|
Definition
| A field (or group of fields) that uniquely identifies a given entity in a table. Makes it possible to uniquely identify every row in a table. Its important to define in order to retrieve every single piece of information put into a database |
|
|
Term
|
Definition
|
|
Term
|
Definition
| a tool for extracting, combining, and displaying data from one or more tables, according to criteria you specify |
|
|
Term
|
Definition
| the duplication of information, or storing the same information in multiple places |
|
|
Term
|
Definition
| states that every non-null foreign key value must match an existing primary key value |
|
|
Term
|
Definition
| the abstraction of a set of associations that hold systematically between different kinds of things in the real world |
|
|
Term
|
Definition
| an effective way to present your data in a printed format |
|
|
Term
| System Development Life Cycle (SDLC) |
|
Definition
| Planning, Analysis, Design, Development, Testing, Implementation, Maintenance |
|
|
Term
| Benefits of the database approach |
|
Definition
| minimal cost redundancy, consistency of data, integration of data, sharing of data, enforcement of standards, ease of application development, uniform security, privacy and integrity controls, data accessibility and responsiveness, reduced program maintenance |
|
|
