Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
25 Cards in this Set
- Front
- Back
The impact of database technology on business can easily overstated
|
False
|
|
Multiple characters make up a record
|
False
|
|
A database itself is a collection of several related files, but DBMs do all the work- structuring files storing data and linking records
|
True
|
|
Data is accessed in a database by sending messages call "protocols" which request data from specific records and / or fields and direct the computer to display the results
|
False
|
|
Sometimes a key is composed of several recores so that their combination provides a unique key.
|
False
|
|
One of the most useful manipultions of object-oriented databases (ODB) is the creation of a new table from two or more other tables
|
False
|
|
A schema describes the structure of the database being designed: the names and types of fields in each record type and the general relationship among different set of records or files
|
True
|
|
The conceptual blueprint of the database is called an entity relationship diagram (ERD)
|
True
|
|
The very fact that manipulation of the data requires a programmer is probably the greatest disadvantage of the ___
|
file approach
|
|
Often the traditional file approach to storing data leads to low
|
data integrity
|
|
In the database approach, data pieces are organized about ____
|
entities
|
|
Acollection of related records, such as all the records of a college's students is called a ____
|
file
|
|
A _____ is the general logical structure in which records are stored within a database and the method used to establish relationship among the record
|
data model
|
|
To design a ______ you need a clear ida of the different entities and how they relate
|
relational database
|
|
to link records from one table with records of another talbe, the tables must have at least one field in common and field must a _____ field for one of the tables
|
primary key
|
|
A _____ can be maintained, for instance for professors and students in a college database
|
Many to Many relationship
|
|
The combied storage of both data and the procedures that manipulate them is referred to as _______
|
encapsulation
|
|
A____ is created "on the fly" as a result of a query and exists only for the duration the user wishes to view it or to create a paper report from it.
|
join table
|
|
Many____ also allow a builder to positively indicate when a field is not unique, meaning that the value in that fieldmight by the same for more than one record
|
DBMSs
|
|
____do not replace transactinal database, which are updated, which are updated with daily transactions such as sales, billing, cash receipt and returns
|
Data warehouse
|
|
If ____ need to be used as one large data warehouse, special soft ware tools can unify them and make them appear as on e large data warehouses
|
data marts
|
|
Because of capacity needs, organization often choose ____ to store and manage data warehouse
|
mainframe computers with multiple CPD
|
|
To uncover the valuable information contained in their data, organization must use software that can effectively ____ data warehourse
|
mine
|
|
The designers of data warehouse keep in mind_____ the ability of the data
|
scalability
|
|
In the _____ phase of transferring data from a transactional database to a data warehouse, specialisits "cleanse" the data and modify it into a form that allows inseration into the data warehouse
|
transformation
|