Term
| a ___ is a self describing collection of integrated records |
|
Definition
|
|
Term
| columns are also called ___ |
|
Definition
|
|
Term
| columns or fields are grouped into rows which are called ___ |
|
Definition
|
|
Term
| a group of similar row or records is called a ___ or ___ |
|
Definition
|
|
Term
| database is a collection of tables plus ___ among the rows in those tables, plus ___ |
|
Definition
|
|
Term
| a ___ is a column or group of columns that identifies a unique row in a table |
|
Definition
|
|
Term
| databases that carry their data in the form of tables that represent relationships using foreign keys are called ___ |
|
Definition
|
|
Term
| what does self-describing mean |
|
Definition
| a database contains, within itself, a description of its contents |
|
|
Term
| ___ make database data more accessible and useful |
|
Definition
| database application system |
|
|
Term
| ___ is a program used to create process and administer a database |
|
Definition
| database management system (DBMS) |
|
|
Term
| what are some popular DBMS products? |
|
Definition
DB2
access
SQL Server
Oracle Database
MySQL |
|
|
Term
| What is a secondary function of a DBMS? |
|
Definition
|
|
Term
| the DBMS provides applications for four processing operations. What are those operations. |
|
Definition
|
|
Term
| ___ is an international standard language for processing a database |
|
Definition
| Structured Query Language (SQL) |
|
|
Term
| DBMS administrative functions include the following: |
|
Definition
backing up database data
adding structures to improve the performance of DB applications
removing data that are no longer wanted or needed |
|
|
Term
| a ___ is a collection of forms reports queries and application programs that process a database |
|
Definition
|
|
Term
| ___is an issue when two users update the same data item, but only one of those changes is recorded in the data |
|
Definition
|
|
Term
| DBMS products fall into two broad categories. Name and describe them |
|
Definition
Enterprise DBMS: processes large organizational and workgroup databases
Personal DBMS: designed for smaller simpler database applications (Fewer than 100 users) |
|
|
Term
| a ___ must be built before building the DB itself |
|
Definition
|
|
Term
| a ___ is a tool for constructing data models |
|
Definition
| entry relationship (E-R) data model |
|
|
Term
| a ___ is something the users want to track |
|
Definition
| entity (the names of entities are always singular) |
|
|
Term
| entities have ___ that describe the characteristics of the entity |
|
Definition
|
|
Term
| entities also have an ___ which is an attribute, or group of attributes, whose value is associated with one and only one entity instance |
|
Definition
|
|
Term
| entities have ___ to one another |
|
Definition
| relationships (order has a relationship to customer) |
|
|
Term
| ___ is the process of converting a poorly structured table into two or more well structured tables |
|
Definition
|
|
Term
| when is the easiest time to change the database structure? |
|
Definition
| during the modeling phase |
|
|
Term
| what is a a data integrity problem |
|
Definition
when some rows indicate one name in the database, but another calls it by a different name.
I.E. Department 100 is "accounting and Finance" in one row. Another row calls it "accounting" |
|
|
