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;
16 Cards in this Set
- Front
- Back
|
Database |
– is a collection of related data or facts - contains a collection of related items or facts arranged in a specific structure |
|
|
• Fields • Records • Table |
Three of the most common terms to know about database are: |
|
|
Fields |
– each piece of information |
|
|
Records |
– one full set of fields, that is, all the related information about one person or object is called a? |
|
|
Tables |
– a complete collection of records makes a? |
|
|
Flat file (or sequential file) |
– consist of a single data table - are useful for single-use or small group situations, especially for maintaining lists such as an address lists or inventories |
|
|
Relational Database |
– a database made up of set of tables -a common field existing in any two tables creates a relationship between tables |
|
|
Relational database Structure |
– is easily the most prevalent in today’s business organization |
|
|
• Customer information • Employee information • Vendor information • Other Information • Inventory Information |
A typical relational database likely would contain data, such as: |
|
|
Database Management System (DBMS) |
– is a software tool that allows people to store, access, and process data or facts into useful information - also provides tools that enable users to construct special requests (called queries) to find a specific record in the database |
|
|
• Creating table • Sorting records • Generating reports • Viewing records • Creating queries |
Data management functions: |
|
|
• Name the field • Specify the field type • Specify the field size |
Creating Database Tables: |
|
|
Text fields |
(also called character fields or alphanumeric field) – accepts any string of alphanumeric characters that are not used in calculations |
|
|
Numeric fields |
– store purely numeric data. The numbers in a numeric fields might represent currency, percentages, statistics, quantities, or any other values that can be used in calculations |
|
|
Date field or time field |
– stores data dates or time entries. This field type converts a date or time into a numeric value, just as dates and time as stored internally as serial number in spreadsheet cells. |
|
|
Logical field |
(also called Boolean field) stores one of two possible values |
