Flashcards
Untitled
Cards in this deck (11)
- 1flat file databaseall data is contained in one table/file
- 2linked table(aka relational database)- two or more files are linked together. reduces unnecessary duplication of data
- 3primary keyfield which is a unique identifier for each record. a file may have only one primary key
- 4foreign keythe primary key from another file, used to link files
- 5relational databaseavoids data duplication (by using linked tables where appropriate) and reduces error in data entry (by using suitable validation techniques).
- 6basic field typesinclude, text, numeric, date, time, and graphic.
- 7object(aka container) can contain graphic, audio, video, etc
- 8linkcontains a hyperlink
- 9calculationcontains a formula to calculate its contents from another other data in the record.
- 10Booleanstores yes/no or true/false
- 11—
Information
- Description
- Flashcards on Untitled, created by kevin baker on 13/09/2017.
- Created by
- kevin baker
- Views
- 0
- Rating