Help shape GoConqr. What should we add next?

Flashcards

Untitled

kevin baker English 11 cards

Cards in this deck (11)

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

Information

Description
Flashcards on Untitled, created by kevin baker on 13/09/2017.
Created by
kevin baker
Views
9
Rating

More on Relational Databases and Relationships

Feedback

What is it about?

What should we add next?