Data Software Flashcards
What is Data Probability?
Ability to move and transfer files easily between different computer systems without the need to re-create
What is Data Compression?
Converting a file to a compressed format
Advantages of Data Compression
- Quality maintained
- Reduced file size
- Fast internet use
What are the common compressed Image/Graphic files?
JPEG and Gif
What are the common compressed files for Text?
- CSV (Comma Separated Value)
- RTF (Rich Text Format)
- ASCII (American STANDARD Code for Information Interchange)
What is CSV?
Data/fields separated by commas, first line field names and other lines.
It is highly portable e.g transfer between spreadsheet&database
What is RTF?
It is highly portable and saves letters, numbers and simple formatting. It can transfer between different email or word processing programs
What is ASCII?
Highly portable, used to transfer between different word processing programs. It saves letters, numbers and NOT simple formatting
What are the common compressed video files?
MPEG4, MP4
What are the common compression of Audio files?
MP3, WAV, MIDI (Musical Instrument Digital Interface)
What is PDF?
Portable Document Format
A portable file that is a read only document. Highly portable, uses Adobe Reader
Advantage of PDF
• Free to download
What is Winzip Compression?
Zipping files for email or internet transfer
What is Data Capture and its types?
Can be paper or screen based
- Paper - hard copy
- Screen - soft copy
Importance of Paper based form design
Very relevant as it allows a quick transfer to a computer
What is the purpose of Validation checking?
To ensure that the data entered is sensible
What is the purpose of Verification checking?
To ensure if data is accurate
What is a Database Software?
A program that stores data in tables using relationships
What is an Input Mask?
Where data must be entered in a certain format
What is Validation Rules?
Rule that checks the data entered
What are Forms?
On screen data capture for updating in tables
What is a report?
Query results that are presented in a table format. It can include graphics to enhance the report, calculations
What is Queries?
Used in a criteria to find records
What is a Flat File?
Only contains One table with no relationships included
What are the problems using a Flat File?
- Data Redundancy - Flat file data is repeated unnecessarily, therefore it causes error-prone and slows down searching
- Data Integrity - data error-prone therefore data might be inaccurate or unreliable
What is a Relational Database?
More than one table is included. These tables are linked using key fields
Advantages of Relational Database
- Since tables are linked together with key fields, it helps avoid data redundancy and ensures good integrity
- Makes searching and sorting quicker
- Data is stored centrally - easier to keep secure
