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;
50 Cards in this Set
- Front
- Back
File Oriented system |
stores data in one or more separate files |
|
Database Management System |
All the tables are connected by common fields |
|
data Redundancy |
Data common to two or more information systems is stored in several places |
|
Data Integrity |
The accuracy and consistency of data stored in a databse |
|
Master file |
Stores Permanent data |
|
Table File |
Reference data |
|
Transaction File |
Stores records for day-to-day business and operational data |
|
Work File |
Temporary file for a single task |
|
Security File |
Saved for backup and recovery |
|
History File |
Archiving purposes |
|
Scalability |
system and be modified or downsized easily to meed rapidly changing needs |
|
Economy of scale |
Efficiency of high-volume processing on larger computers |
|
ODBC (Open Database Connectivity) |
software from different vendors to interact and exchange |
|
JDBC (Java Database Connectivity) |
Java applications can exchange data with any database that uses SQL statements |
|
intranet |
private, company owned network to provide web based access to internal users |
|
extranet |
extension of intranet for the external users (Customers, suppliers) |
|
entity |
person, place, thing, event, data |
|
field |
single characteristic or fact about an entity |
|
Primary Key |
Uniquely identifies each record in the table. |
|
Candidate Key |
any field that could serve as a primary key |
|
foreign key |
field in one table that matches a primary key in another table |
|
Secondary Key |
field or combination of fields that can be used to access or retrieve records |
|
Referential Integrity |
rules that avoids data inconsistency |
|
One-to-One Relationship (1:1) |
The parent record has 0 or 1 Child record. |
|
One to Many Relationship (1:M) |
Parent record in one table can reference many child records in another table. |
|
Many-to-Many relationship (M:M) |
Parent row in one table contains several child rows in the second table and vice versa. |
|
Normalization |
reorganizing data in a database so there is no redundancy and data dependencies are logical. |
|
1NF |
Does not contain a repeating group |
|
2NF |
in 1NF and all fields not part of primary key are functionally dependent on the primary key |
|
3NF |
in 2NF and if no nonkey field is dependent on another nonkey field. |
|
Sequence Codes |
Specific order |
|
Abbreviation codes |
uses alphabetic abbreviations |
|
Mnemonic Codes |
specific combinations that are easy to remember |
|
Cipher Codes |
Keyword to encode a number |
|
Data Warehouse |
Integrated collection of data |
|
Data Mart |
Serve the needs of a specific department |
|
Network Topology |
the way a network is configured |
|
Physical Topology |
describes the actual network cabling and connections |
|
logical Topology |
Describes the way the components interact |
|
Hierarchical Network |
one or more powerful servers control the entire network |
|
bus network |
single communication path connects the central server |
|
Ring network |
a circle where data flows in one direction |
|
Star Network |
Hentral networking device (switch) managing traffic. (Hub was used in the past) |
|
802.11a |
Not compatable with 802.11b and 802.11g |
|
802.11g |
Compatible with 802.11b |
|
802.11n |
compatible with 802.11I standards |
|
What are the 7 layers of the OSI Model. From 1 to 7? |
Physical, Data Link, Network, Transport, Session, Presentation, Application (People Dont Need To Suck Penis Always) |
|
Session Layer |
Defines control structures that manage the communications link between computers |
|
Presentation Layer |
Ensures that data is uniformly structured and formatted for network transmission |
|
Application Layer |
Provides network services requested by a local workstation |