Join
Give this one a try later!
Lets you combine data from two or more tables into a single result set.
What are Relationships?
Give this one a try later!
An ER modeling construct depicting how entities are related.
Relational Schema
,Give this one a try later!
A visual depiction of the relational database model.
What does "DROP DATABASE" do?
Give this one a try later!
Deletes an existing database.
What does the "UPDATE" do?
Give this one a try later!
Changes one or more existing rows in the table.
Aggregate Functions
Give this one a try later!
SQL functions used for calculating and summarizing values in queries;
includes COUNT, SUM, AVG, MIN, and MAX functions.
Operational Databases
Give this one a try later!
, Collect and present operational information in support of daily operational
procedure and processes.
Database Designers (Database Modelers or Architects)
Give this one a try later!
Involved in the database modeling stage.
Inner Join
Give this one a try later!
Returns rows from both tables only if their related columns match.
Index
Give this one a try later!
Provide an efficient way of accessing the rows in a table based on the
values in one or more columns. An index is automatically created for a
table's primary and non-primary keys.
Outer Join
Give this one a try later!
, Returns rows from one table in the join even if the other table doesn't
contain a matching row.
Cardinality Constraints
Give this one a try later!
The lines connecting the relationship to the entities include symbols
depicting how many instances of one entity can be associated with
instances of another entity.
SQL
Give this one a try later!
Structured Query Language, the standard language for working with a
relational database. (Allows any application to communicate with any
DBMS.)
ER Diagram Shapes- Associative Entity
Give this one a try later!
A rectangle with a diamond inside of it.
Relationship Instances
Give this one a try later!
Lets you combine data from two or more tables into a single result set.
What are Relationships?
Give this one a try later!
An ER modeling construct depicting how entities are related.
Relational Schema
,Give this one a try later!
A visual depiction of the relational database model.
What does "DROP DATABASE" do?
Give this one a try later!
Deletes an existing database.
What does the "UPDATE" do?
Give this one a try later!
Changes one or more existing rows in the table.
Aggregate Functions
Give this one a try later!
SQL functions used for calculating and summarizing values in queries;
includes COUNT, SUM, AVG, MIN, and MAX functions.
Operational Databases
Give this one a try later!
, Collect and present operational information in support of daily operational
procedure and processes.
Database Designers (Database Modelers or Architects)
Give this one a try later!
Involved in the database modeling stage.
Inner Join
Give this one a try later!
Returns rows from both tables only if their related columns match.
Index
Give this one a try later!
Provide an efficient way of accessing the rows in a table based on the
values in one or more columns. An index is automatically created for a
table's primary and non-primary keys.
Outer Join
Give this one a try later!
, Returns rows from one table in the join even if the other table doesn't
contain a matching row.
Cardinality Constraints
Give this one a try later!
The lines connecting the relationship to the entities include symbols
depicting how many instances of one entity can be associated with
instances of another entity.
SQL
Give this one a try later!
Structured Query Language, the standard language for working with a
relational database. (Allows any application to communicate with any
DBMS.)
ER Diagram Shapes- Associative Entity
Give this one a try later!
A rectangle with a diamond inside of it.
Relationship Instances
