Term
|
Definition
| A collection of persistent data that can be shared and interrelated. |
|
|
Term
|
Definition
| data that reside on stable storage |
|
|
Term
|
Definition
| a database that can have multiple uses and users |
|
|
Term
|
Definition
| data stored as separate units can be connected to provide a whole picture. |
|
|
Term
| A database management system (DBMS) is |
|
Definition
| a collection of components that support data acquisition, dissemination, maintenance, retrieval, and formatting. |
|
|
Term
|
Definition
| A named, two-dimensional arrangement of data. It stores collections of entities. |
|
|
Term
| Structured Query Language (SQL) |
|
Definition
| an industry standard database language that includes statements for database definition, database manipulation, and database control. |
|
|
Term
| The most important feature of a DBMS is the ability to |
|
Definition
|
|
Term
|
Definition
| requests for data to answer a question. |
|
|
Term
| ______ allows users with limited computing skills to submit queries. |
|
Definition
|
|
Term
|
Definition
| a tool to enter and edit data |
|
|
Term
|
Definition
| enhance the appearance of data that is displayed and printed |
|
|
Term
|
Definition
| reliable and efficient processing of large volumes of repetitive work. |
|
|
Term
|
Definition
| a unit of work that should be processed reliably without interference from other users and without loss of data due to failures. (is a movement or exchange) |
|
|
Term
| According to International Data Corporation sales of enterprise database software reached ____ in ____. |
|
Definition
|
|
Term
| _____ is the leader in the open source DSMS market |
|
Definition
|
|
Term
| _____ dominates the market for desktop database software. |
|
Definition
|
|
Term
|
Definition
| where database has a separate identity from the applications |
|
|
Term
|
Definition
| allows geographically dispersed computers to cooperate when providing data access. |
|
|
Term
|
Definition
| a program that submits a request to a server |
|
|
Term
|
Definition
| processes requests on behalf of a client |
|
|
Term
|
Definition
| a management position that performs planning and policy setting for the information resources of an entire organization. |
|
|
Term
|
Definition
| given a report or some data extracted from a database |
|
|
Term
|
Definition
| requests existing forms or reports using parameters |
|
|
Term
|
Definition
| builds a form or report when needed |
|
|
Term
|
Definition
| responsible for clooecting requirements, designing applications, and implementing information systems |
|
|
Term
|
Definition
| a set of related components that work together to accomplish some objectives. |
|
|
Term
|
Definition
| accepts data from its environment, processes data, and produces output data for decision making. |
|
|
Term
| The role of a database is to |
|
Definition
| provide long-term memory for an information system. |
|
|
Term
| The components of information systems are |
|
Definition
| databases, people, procedures, input data, output data, software and hardware. |
|
|
Term
| The traditional life cycle is often known as the waterfall model because |
|
Definition
| the result of each phase flows to the next phase. |
|
|
Term
| Preliminary investigation phase |
|
Definition
| produces a problem statement and feasibility study |
|
|
Term
|
Definition
| Produces requirements describing processes, data, and environment interactions |
|
|
Term
|
Definition
| produces a plan to efficiently implement the requirements |
|
|
Term
| Systems implementation phase |
|
Definition
| Produces executable code, databases, and user documentation |
|
|
Term
|
Definition
| produces corrections, changes, and enhancements to an operating information system |
|
|
Term
| All development methodologies include: |
|
Definition
| data model, process model, environment interaction model |
|
|
Term
| The goal of database development is to |
|
Definition
| create a database that provides an important resource for the organization. |
|
|
Term
| As a database designer, you need two different kinds of skills: |
|
Definition
|
|
Term
|
Definition
| Computer Aided Software Engineering |
|
|
Term
|
Definition
| Structured Query Language |
|
|
Term
| • The CREATE TABLE statement in SQL (Structured Query Language) is used to define the _____ part of the table. |
|
Definition
|
|
Term
|
Definition
| a two-dimensional arrangement of data. A table consists of a heading defining the table name and column names and a body containing rows of data. |
|
|
Term
| Entity Integrity (Primary Key) |
|
Definition
| each table must have a column or combination of columns with unique values. |
|
|
Term
|
Definition
| the column values in one table must match column values in a related table. |
|
|
Term
|
Definition
| a column or combination of columns containing unique values for each row. |
|
|
Term
|
Definition
| a column or combination of columns in which the values must match those of a candidate key. It must have the same data type as the associated candidate key. |
|
|
Term
|
Definition
| a connection between two tables in which one row of a parent table can be referenced by many rows of a child table. These are the most common kind of relationship. |
|
|
Term
|
Definition
| a connection between two tables in which rows of each table can be related to many rows of the other table. |
|
|
Term
|
Definition
| retrieves a subset of rows of the input table that satisfy a given condition. |
|
|
Term
|
Definition
| retrieves a subset of columns of the input table |
|
|
Term
|
Definition
| the operation that retrieves all the rows in either table. |
|
|
Term
|
Definition
| the operation that retrieves just the common rows. |
|
|
Term
|
Definition
| the operation that retrieves the rows in the first table but not in the second table |
|
|
Term
|
Definition
| Each table must have the same number of columns and each corresponding column must have compatible data type. |
|
|
Term
|
Definition
| an operator that produces a table with rows that summarize the rows of the input table. Aggregate functions such as count, min, max, average and sum are used to summarize the rows of the input table. |
|
|
Term
|
Definition
| – an operator that produces a table in which the values of a column from one input table are associated with all the values from a column of a second input table. |
|
|
