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;
11 Cards in this Set
- Front
- Back
DATABASE |
A COLLECTION OF RELATED DATA THAT IS STORED IN A CENTRAL LOCATION OR IN MULTIPLE LOCATIONS |
|
DATA HIERARCHY |
IS THE STRUCTURE AND ORGANIZATION OF DATA WHICH INVOLVES FIELDS RECORDS AND FILES. |
|
DATABASE MANAGEMENT SYSTEM (DBMS) |
IS SOFTWARE FOR CREATING STORING MAINTAINING AND ACCESSING DATABASE FILES, A DBMS MAKES USING DATABASES MORE EFFICIENT |
|
SEQUENTIAL ACCESS FILE STRUCTURE |
RECORDS IN THE FILES ARE ORGANIZED AND PROCESSED IN NUMERICAL OR SEQUENTIAL ORDER, TYPICALLY THE ORDER IN WHICH THEY WERE ENTERED |
|
RANDOM ACCESS FILE STRUCTURE |
RECORDS CAN BE ACCESSED IN ANY ORDER REGARDLESS OF THEIR PHYSICAL LOCATIONS IN STORAGE MEDIA. THIS METHOD OF ACCESS IS FAST AND VERY EFFECTIVE WHEN A SMALL NUMBER OF RECORDS NEED TO BE PROCESSED DAILY OR WEEKLY. |
|
INDEXED SEQUENTIAL ACCESS METHOD (ISAM) |
RECORDS CAN BE ACCESSED SEQUENTIALLY OR RANDOMLY DEPENDING ON THE NUMBER BEING ACCESSED . FOR A SMALL NUMBER RANDOM ACCESS IS USED AND FOR A LARGE NUMBER SEQUENTIAL ACCESS IS USED. |
|
PHYSICAL VIEW |
INVOLVES HOW DATA IS STORED ON AND RETRIEVED FROM STORAGE MEDIA, SUCH AS HARD DISKS, MAGNETIC TAPES OR CDs |
|
LOGICAL VIEW |
INVOLVES HOW INFORMATION APPEARS TO USERS AND HOW IT CAN BE ORGANIZED AND RETRIEVED |
|
DATA MODEL |
DETERMINES HOW DATA IS CREATED REPRESENTED ORGANIZED AND MAINTAINED. IT USUALLY CONTAINS DATA STRUCTURE, OPERATIONS AND INTEGRITY RULES |
|
HIERARCHICAL MODEL |
THE RELATIONSHIP BETWEEN RECORDS FORM A TREE LIKE STRUCTURE . RECORDS ARE CALLED NODES AND RELATIONSHIPS BETWEEN RECORDS ARE CALLED BRANCHES. THE NODE IS AT THE TOP IS CALLED ROOT AND EVERY OTHER NODE (CALLED CHILD ) HAS A PARENT . NODES WITH THE SAME PARENT ARE CALLED TWINS OR SIBLINGS |
|
NETWORK MODEL |
IS SIMILAR TO THE HIERARCHY MODEL BUT RECORDS ARE ORGANIZED DIFFERENTLY. UNLIKE THE HIERARCHICAL MODEL . EACH RECORD IN THE NETWORK MODEL CAN HAVE MULTIPLE PARENT AND CHILD RECORDS |