Introduction to Databases Flashcards
This is the system that manages the data
Database Management System (DBMS)
What is data in non-computing terms?
Facts & statistics with no context
What is information in non-computing terms?
Facts provided about someone or something with context
What is the data lifecycle in order?
- Collected
- Stored
- Processed
- Shared
- Presented
Explain what type 4 data processing is
Generation of lists & reports through grouping, filtering, and sorting
Explain type 2 data processing.
Mathematical processing (updating & deleting data)
Explain type 1 data processing.
Relating data together to form records
Explain type 3 data processing.
Relating records with each other
What does it mean for information to be secure?
Information is kept secured from unauthorized users
What does it mean for information to be economical?
The value of the information gathered should be equal to or more than the cost & production of retrieving the information
Give an example of how information can be accurate (Input/Ouput)
Input -> Ensure that the user can only put the necessary characters in a field (i.e., Cannot put letters when trying to input a cellphone number)
Output -> Show a summary of what information has been provided so far before submitting
What does it mean for information to be timely?
Information retrieved must come from an updated source
This information comes only from a trustworthy source. What dimension of quality information is this?
Reliable
Explain the single monolithic application.
Input data -> database application -> information
All processing is done by a single application
The Client Server consists of how many parts?
- The database application and the database server
