Introduction to Relational Database and SQL Commands

Flashcards covering key concepts of relational databases and SQL commands based on lecture notes.

Data refers to __ facts about a topic or item.

collected

Information is the result of combining, comparing, and __ calculations on data.

performing

A __ is a centralized and structured set of data stored on a computer system.

database

The primary software that controls the storage, organization, and retrieval of data is called a __.

DBMS (Database Management System)

In the context of computing, a __ refers to the primary device used to perform calculations and execute commands.

hardware

The __ model was proposed by E.F. Codd, decoupling the logical organization from physical storage.

relational

Normalization helps in handling insertion, update, and deletion __.

anomalies

Each table in a relational database must have a distinct __.

name

A foreign key in a relational database is simply the __ key in a different table.

primary

Data integrity ensures that data is __.

accurate