Database Management Flashcards
Collection of data organizes so you can access, retrieve, and use it
Database
Database software also called
Database Management System ( DBMS )
Database software allows you to:
- Create database
- Add, change and delete data
- Sort and retrieve data
- Create forms and reports
Raw facts
Data
Data that is ORGANIZED & Meaningful
Information
Degree to which data is correct
Data Integrity
Computer phrase that means you cannot create correct information from incorrect data
Garbage in, Garbage out ( GIGO )
Qualities of Valuable Information
- Accurate
- Verifiable
- Timely
- Organized
- Accessible
- Useful
Hierarchy of Data
Database contains files, file contains records, record contain fields, field contains characters
Combination of onr or more characters
Field
Defines the MAXIMUM number of characters a field can contain
Field Size
Uniquely IDENTIFIES each field
Field Name
SPECIFIES kind of Data field contains
Data Type
Common Data Types:
- Text
- Numeric
- AutoNumber
- Currency
- Date
- Memo
7.Yes/No - Hyperlink
- Object
Also called “Alphanumeric” Letters, numbers, or special characters
TEXT
Numbers ONLY
Numeric
Uniquely number AUTOMATICALLY assigned to each new record
AUTONUMBER
Dollar and Cent amounts or number containing decimal values
Currency
Month, day, year, and sometimes time
Datr
“Lenthly” text entries
Memo
Also called “Boolean” only the values Yes or No ( True or False )
Yes/No
Web address that “links” to document or Web page
Hyperlink
Also called “BLOB” for binary large object ) - Photograph, Audio, Video, or Document created in other application such as word processing or spreadsheet
OBJECT
Group of related fields
Record
“Collection” of related records stored on disk
DATA FILE
