Chapter 26

Compare and Contrast Various Database Structures

There are many types of database structures, and in this chapter you learn how they are similar and different. This chapter covers CompTIA IT Fundamentals+ Objective 5.2: Compare and contrast various database structures. Topics covered include the following:

  • Structured vs. semi-structured vs. nonstructured

  • Relational databases (schema, tables, rows/records, fields/columns, primary key, foreign key, constraints)

  • Nonrelational databases (key/value databases, document databases)

Foundation Topics

Structured vs. Semi-Structured vs. Nonstructured

Most people believe that the only type of data structure used in a database is structured (rows and columns), and if data can’t be structured, ...

Get CompTIA IT Fundamentals+ FC0-U61 Cert Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.