Relational 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

flashcard set

Earn XP

Description and Tags

Computer Science

GCSE Computer Science

HIGH_SCHOOL

9 Terms

1
New cards
Data
Raw, unorganized facts and figures without context.
2
New cards
Information
Data that has been processed, structured, or given context to make it meaningful.
3
New cards
Database
An organized collection of logically related data stored electronically for easy access.
4
New cards
Field
A single piece of data or attribute about an entity, represented as a column.
5
New cards
Record
A complete set of fields related to a single entity, represented as a row.
6
New cards
Primary Key
A unique identifier for each record in a database table.
7
New cards
Foreign Key
An attribute in a table that links to the primary key of another table to create a relationship.
8
New cards
Relational Database
A database that stores data in multiple connected tables using primary and foreign keys.
9
New cards
Why Databases Are Used
To reduce data redundancy, improve consistency, enhance security, and allow efficient querying.