Let's Rewind..
Software that interacts with our database in a form of GUI or Terminal
Database Management System
Visual representation of how items in a database relate to each other.
Entity Relationship Diagram
Ensures that each column cell contains only atomic values
1NF / First Normal Form
The year SQL was created
1980s
Definable thing, such as a person, role, event, concept or object, that can have information about it stored in a relational database.
This is a situation where data needs to be joined from multiple tables to answer a specific query
Collection of data organized for creating, reading, updating, and deleting
Database
reference to a primary key in a table. It is used to identify the relationships between entities.
Foreign Key
Three Anomalies in a Database Design
Insert Anomaly
Update Anomaly
Delete Anomaly
Type of database that organizes data into rows and columns, which collectively form a table where the data points are related to each other
Relational Database
used to split an entity in two to provide information concisely and make it more understandable.
1 to 1 Relationship / 1:1 Cardinality
It ensures that every determinant (a set of attributes that uniquely identify a row) in a table is a candidate key (a minimal set of attributes that uniquely identify a row).
Boyce-Codd Normal Form
Oldest form of database
Cuneiform
refers to the relationship between two entities X and Y in which X may be linked to many instances of Y and vice versa
Many to Many Relationship / N:N Cardinality
occurs when a non-key attribute depends on another non-key attribute, which in turn depends on the primary key.
Transitive Key