CS SLR 10 databases

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/8

encourage image

There's no tags or description

Looks like no tags are added yet.

9 Terms

1
New cards

Primary key

Unique identifier for each record in a table

2
New cards

Composite primary key

Combination of fields that is unique for each record

3
New cards

Foreign key

Field in a table that refers to a primary key in another table

4
New cards

Secondary key

Indexed for faster searching

5
New cards

Flat file database

Stores all data in a single table

6
New cards

Relational database

Organises data imto multiple tables with links between them

7
New cards

1NF

Unique field labels, same data type, atomic values, no identical records, primary key

8
New cards

2NF

1NF without partial dependencies - where a non-key field only relies on part of a composite key

9
New cards

3NF

2NF without transitive dependencies - where a non-key field relies on another non-key field