Chapter 18 - Databases

0.0(0)
studied byStudied by 1 person
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/9

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

10 Terms

1
New cards

Database

An organized collection of data that stores and retrieves data.

2
New cards

Flat-file databases

Databases where data is stored in one table, organized by rows and columns.

3
New cards

Relational databases

Databases where data is stored in more than one linked table, stored in a file, with tables linked through relationships.

4
New cards

Field

A single item of data within a database, each field has a field name and contains one type of data.

5
New cards

Record

A collection of fields within a database.

6
New cards

File

An organized collection of records within a database, can have one or more tables within.

7
New cards

Key fields

The fields that establish relationships between tables within a database.

8
New cards

Primary key field

A field that holds unique data and is used to identify a specific record within a table.

9
New cards

Foreign key field

Fields that store values from a primary key field in another table.

10
New cards

Data types and sub-types

Different categories of data that can be stored in a database, including alphanumeric (text), numeric (integer, decimal, currency), and boolean (Yes/No, True/False).