Memorization Quiz #1

Database (DB)

Structured data which serves a related purpose and is easy to use.

Database Management System (DBMS)

A systematic interface to define, update, retrieve, and administer information in a database.

Database Administrator (DBA)

A person responsible for managing and maintaining an organization’s DBMS and databases.

Structured Query Language (SQL)

A standard language for interaction with SQL databases, storing information in a structured relational format.

NoSQL databases

Databases that lack a standard language for interaction and store information in a variety of non-relational formats.

Legacy System

An old, typically critical system that is difficult to maintain, adapt, or integrate with modern systems.

Systems Development Life Cycle (SDLC)

A multiple phase development process used to accomplish a database design project.

Entity Type

A generic type of thing (e.g., people).

Entity

A specific instance of an entity type (e.g., the person John Doe).

Attribute

A characteristic that describes a thing (e.g., People have Names).

Key

A unique identifier for an Entity (e.g., Social Security Numbers for people).

Relationship Type

A generic association between two Entity Types.

Relationship

A specific association between two Entities (e.g., John Doe owns the Ford F150).

Database Object Type

A named data structure within a database (e.g., A Table).

Database Object

A named instance of a database object type (e.g., The People Table).

Database Model

Defines a set of database object types, constraints, and operators.

Data Model

The blueprint of a specific database supporting a purpose, which can be conceptual, logical, or physical.

Schema

A concrete instance of a data model implemented in a DBMS, adhering to the conventions of the DBMS.

Entity-Relationship Diagram (ERD)

A visual representation of a Data Model (e.g., The NJ DMV ERD).

Conceptual Data Model

States what information is included at a high level, independent of a specific Database Model or DBMS.

Logical Data Model

States what information is included and how it is structured using a specific Database Model.

Physical Data Model

States what information is included, how it is structured, and the implementation details using a specific DBMS.