5. Compare and contrast various data structures

Question 1

Structured Data

Answer 1

Structured data organizes information into categories like title, author, and publication date for easy storage and retrieval in databases.

Question 2

Non-structured Data

Answer 2

Non-structured data lacks order/pattern.

Question 3

Semi-structured Data

Answer 3

Semi-structured data is a mix between organized and unorganized data, does not fit neatly into tables, but contains common features.

Question 4

Schema

Answer 4

The architecture of how a database is structured and organized

Question 5

Rows/Records

Answer 5

They collect information about only one entity

Question 6

Field

Answer 6

Vertical columns and horizontal rows-
can be a type of vehicle, a specific piece of art, a single park in a national parks system, or an individual person.

Question 7

Primary Key

Answer 7

A unique identifier for each record

Question 8

Foreign Key

Answer 8

A primary key from another table

Question 9

Constraints

Answer 9

Constraints, like the NOT NULL constraint, ensure data integrity by setting rules for data entry.

Question 10

Key/value databases