SQL Flashcards
Record
A single set of related data（row, data item, item）
Attribute
A property of a record. A record can have one or more properties.（column, data field, field）
Reading
Getting the value of something（getting, querying, selecting）
Database
An organized collection of stored and persisted data(db)
SQL
A query and declarative language specifically designed to talk to relational databases(sequel)
Database entity
A single concept that needs to be stored in a table and database, such as a kind of person, product, thing, or object
Primary key
An attribute dedicated to being a unique identifier for each row in a table(PK)
Result Set
A set of rows from a database, as well as metadata about the query such as the column names, and the types and sizes of each column.
Query
A request to access data from a database
Compound Condition
A condition formed from multiple simple comparisons combined with one of the SQL logical operators: AND, OR, or NOT.
One to Many Relationship
A relationship between two tables in a database where one record in a table can be associated with one or more records in another table
Many to Many Relationship
A relationship between two tables in a database where one record in either table can relate to many records in the other table.
One to One Relationship
A relationship between two tables in a database where one record in either table can relate to at most one record in the other table.
Join Table
A table used to connect two other tables in order to establish a many to many relationship.
Entity Relationship Diagram
A graphical representation of a data model using entities, their attributes, and relationships between those entities. -> Database Diagram
