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;
8 Cards in this Set
- Front
- Back
Describe the purpose of a database(1.3) |
is to help people keep track of things |
|
What is an ID column?(1.7) |
A unique identifier for a column |
|
Describe in your own words and illustrate with tables how relationships are represented in a relational database(1.14) |
Relationships are represented in a relational database through the use of queries that search multiple tables and bring up important information that interact with one another. |
|
Name the four components of a database system(1.15) |
1. Users 2. The database application 3. The database management system(DBMS) 4. The database |
|
Define the term database(1.16) |
A collection of related tables and other structures |
|
List the specific functions of a DBMS(1.23) |
1. Create database 2. Create tables 3. create supporting structures 4. Read database data 5. Modify database data 6. Maintain database structures 7. Enforce rules 8. Control concurrency 9. Provide security 10. Perform backup and recovery |
|
List the functions of a database application(1.26) |
1. Create and process forms 2. Process user queries 3. Create and process reports 4. Execute application logic 5. Control application |
|
GO STUDY (1.5), (1.8), (1.32) |
GO STUDY (1.5), (1.8), (1.32) |