Management Information Systems

These flashcards cover essential vocabulary and concepts from Management Information Systems, specifically focusing on SQL and database management.

Structured Query Language (SQL)

A programming language designed for managing and manipulating relational databases.

RDBMS

Relational Database Management System, a type of database management system that stores data in a structured format, using rows and columns.

Database Schema

A logical structure that defines how data is organized and how the relationships among data are managed.

Data Type

Defines the kind of data that can be stored in a column of a database table.

Primary Key

A unique identifier for records in a table, ensuring that each record can be uniquely identified.

Foreign Key

A field in one table that uniquely identifies a row of another table, establishing a link between the two tables.

NOT NULL Constraint

A constraint that ensures a column cannot contain NULL values.

UNIQUE Constraint

A constraint that ensures all values in a column are distinct.

INSERT Command

A data manipulation command used to insert new rows into a database table.

SELECT Command

A command used to retrieve data from a database.

UPDATE Command

A command used to modify existing rows in a database table.

DELETE Command

A command used to remove rows from a table.

COMMIT Command

A command that permanently saves all changes to the database.

ROLLBACK Command

A command that undoes changes made since the last COMMIT.

INNER JOIN

A SQL join that returns only rows with matching values in both tables.

LEFT OUTER JOIN

A join that returns all rows from the left table and matched rows from the right table.

RIGHT OUTER JOIN

A join that returns all rows from the right table and matched rows from the left table.

WHERE Clause

A clause used to filter records that meet specific criteria.

Logical Operators

Tools like AND, OR, and NOT used to combine conditions in SQL queries.

Arithmetic Operators

Operators that perform mathematical calculations in SQL.

Data Manipulation Commands

Commands that are used to manipulate data in a database, including INSERT, SELECT, UPDATE, DELETE.

JOIN

An operation that combines rows from two or more tables based on related columns.