Ch 1 Flashcards
RDBMS. Aka, acronym and definition
Relational database management system
Aka DBMS
Software that contains databases and provides an interface to those databases, in which the information is stored in a relational manner
What is SQL
Mechanism by which users communicate with an RDBMS
Database
Container for related tables
Ex: filr cabinet containing many folders such as customer and order information
Table
Table stores pieces of related information like a folder
Ex: customer table, which holds name, address, and phone number
Column
Piece of information in a table such as the customer’s address.
Row
A single entry within a table
Ex: customer table could have the customer names bill and tom as 2 rows
Many to many relationship
Each entity has many of another entities
Ex: each patient sees multiple doctors, while each doctor has multiple patients
One to many relationship
Each entity belongs to a single entity, which has multiple entities
Ex: Each employee belongs to one department, however there are multiple departments
One to one relationship
One entity belongs to exactly one entity, which are often stored together in the database
Ex: monogamous relationships- one partner to one partner relationships
Recursive relationship
The relationship is from an entity back to itself
Ex: A manager is an employee, but at the same time each employee has a manager
Primary key
A column or set of columns that uniquely identify each row
Static value
A unique value assigned to a row that should never change
Pointer
A row that can be referenced from another table by referring to its primary key
Foreign Key
A primary key from one table used as a pointer by another table
Data model
Visual representations of the tables in a database and the relationship in those tables
