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;
20 Cards in this Set
- Front
- Back
Purpose of a database? |
To keep track of things |
|
Unlike a list or spreadsheet, a database mat store information that is more ______ than a simple list |
complicated |
|
What are the two main problems with lists? |
1. Redundancy 2. Multiple Themes |
|
What are the 3 list modifications created by redundancy and multiple themes |
1. deletion problems 2. update problems 3. insertion problems |
|
What does a relational database do? |
Store information in tables. |
|
What are the 3 things relational databases do? |
1. Minimizes data redundancy
2. preserves complex relationships among topics
3. Allows for partial data |
|
What is SQL(Structured Query Language) |
is an international standard for creating, processing and querying databases and their tables |
|
What are the four components of a database system? |
1. Users 2. Database application 3. Database Management System(DBMS) 4. database |
|
What will a user of a database do? |
1. Use a database application to track things
2. Use forms to enter, read, delete, and query data and produce reports |
|
What is a database?? |
A database is a self describing collection of related records |
|
What is metadata? |
Data describing the structure of the database data |
|
The database itself contains what? |
the definition of its structure |
|
What does a database management system do? |
1. Serves as an intermediary between database applications and the database
2. DBMS manages and controls database activities
3. DBMS creates, processes and administers the databases it controls.
|
|
10 functions of a DBMS |
1. Create databases 2. Create tables 3. Create supporting structures 4. Read database data 5. Modify(insert, update, and delete) 6. Maintain database structures 7. Enforce rules 8. Control concurrency 9. Provide security 10. Perform backup and recovery |
|
Define referential integrity constraints |
ensure that the values of a column in one table are valid based on the values in another table |
|
What is a database application |
A database application is a set of one or more computer programs that serve as an intermediary between the user and the DBMS |
|
What are the 5 functions of a database application? |
1. Create and process forms 2. Process user queries 3. Create and process reports 4. Execute application logic 5. Control database applications |
|
What are the 5 characteristics of personal database systems? |
1. Have on application 2. have only a few tables 3. are simple in design 4. involve only one computer 5. support one user at a time |
|
What are the 5 characteristics of a enterprise-class database system? |
1. Support several users simultaneously 2. include more than one application 3. involve multiple computers 4. are complex in design 5. have many tables and databases |
|
Examples of Commercial DBMS products? |
Desktop DBMS: Microsoft Access
Organizational DBMS: Microsoft's SQL server Oracle's Oracle Sun Microsystem's MySQL IBM's DB2 |