Database Design

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

1/9

encourage image

There's no tags or description

Looks like no tags are added yet.

Last updated 10:23 AM on 7/21/26
Name
Mastery
Learn
Test
Matching
Spaced
Call with Kai
Chat

No analytics yet

Send a link to your students to track their progress

10 Terms

1
New cards
Table or Entity
A collection of records pertaining to one specific topic
2
New cards
Record
A row of data containing all the information about one particular item in the table
3
New cards
Field
A column of data describing one characteristic of information in a table
4
New cards
Primary key
A field that uniquely identifies a record in a table
5
New cards

What is a database?

A database is an organised collection of data regarding a specific topic.

It is an electronic system that allows data to be easily stored, organised, processed and changed.

6
New cards
Data
Raw material
7
New cards
Information
Processed, organised data presented by someone
8
New cards
Knowledge
Information that has been read, heard, or seen, and understood
9
New cards

Characteristics of Quality Data

  • Accurate

    • Error-free and precise

  • Correct

    • Incorrect data will lead to incorrect decisions

  • Current

    • Up-to-date

  • Complete

    • There should be no gaps

  • Relevant

    • Relevant to the people who are using it

  • Consistent

    • Data in one part of your database should not contradict or differ from data in another part of your database

10
New cards

Atomic data

It only contains one piece of information and cannot be broken down into smaller parts.

Separated logically