Flashcard Set Preview
| Side A | Side B | ||
| 1 |
What is a database?
|
A database is a structured set of data accessible in various ways
|
|
| 2 |
What 4 things are databases composed of?
|
Tables - The columns and rows where data is storedFields - Columns in the database tableRecords...
|
|
| 3 |
What are some common activities associated with single user applications?
|
Spreadsheets, financial software, web design, programming, billing, word processing
|
|
| 4 |
What are the components of an integrated desktop office software package?
|
A package may include:Word ProcessingSpreadsheetsDatabase softwarePresentation managers (Powerpoint)Communication...
|
|
| 5 |
What are some things you can do with a word processor?
|
You can create professional quality documents. For instance you can control page headers and...
|
|
| 6 |
What does a presentation manager do?
|
With a presentation manager you can take multimedia like images and sounds and turn them into...
|
|
| 7 |
What are some of the uses of a database table?
|
You can generate documents, reports and query data.
|
|
| 8 |
What is a spreadsheet?
|
A spreadsheet is a grid of rows and columns, each grid has cells which can store an item of...
|
|
| 9 |
How does multimedia publishing differ from standard publishing?
|
A form of publishing that allows for video, animation, sound.
|
|
| 10 |
What are some of the functions of accounting applications?
|
Users can eliminate the duplication of data, they contain tools allowing a user to track, analyze...
|
|
| 11 |
Define "expert system"
|
A software that uses a model of the behavior or the application area which represents past...
|
|
| 12 |
What is the only time a field should occur in more than one table in a database?
|
If it is a key field for another table and is used as a part of a combined key, or it is used...
|
|
| 13 |
What is the TMSA?
|
The Management Software Association. It is a trade association for suppliers of "intelligent"...
|
|
| 14 |
What are the four main divisions of business software?
|
Managing people and projectsBusiness planningSales and financial forecastingProcess modeling...
|
|
| 15 |
What is the purpose of data normalization?
|
For relational databases to work properly with multiple tables the tables must be designed...
|
|
| 16 |
Outline the steps in data normalization
|
Data normalization is done in 3 stages.Eliminate duplicate fieldsEnsue that every data entity...
|
|
| 17 |
What is the difference between a flat file system and a relational database?
|
A flat file system has no links or "relations" between it's records and data fields, for example...
|
|
| 18 |
What is a "key" ?
|
A key is one or more fields used to create a unique identifyer for the record, allowing that...
|
|
| 19 |
What is a foreign key?
|
A key from one table that is placed as a field in another table.
|
|
| 20 |
What is a concatenated key?
|
The primary key for a table that is a combination of foreign keys (keys from other tables).
|
|
| 21 |
What is a "one to many" relationship?
|
One-to-many relationships occur when each record in TableA may have many
linked records in...
|
|
| 22 |
What is a "query"?
|
A question a users asks a database, usually using SQL.
|
|
| 23 |
What is SQL?
|
Structured Query Language. A fourth generation programming language that allows you to use...
|
No comments yet! Be the first to add a comment below!
Please login to post comments.
After login, we will forward you back to this flashcard.