Implementation(databases) Flashcards
How are two tables linked
The foreign key of one table is linked to primary key of the other
What is referential integrity
all of the foreign keys in a table must link to a primary key in a related table
What does the select statement do
Selects data from the database
What does the order by statement do
sorts the results of an SQL query in ascending or descending order
How can we select more than one option in the where statement
Using the AND operation
How can we select on or the other option in the where statement
Using the or operation
What is the INSERT INTO statement used for
to insert a record into a table
What is the UPDATE statement used for
to update a record in a table
What is the DELETE statement used for
To delete a record from a table
What is an equi join
Used to join matching columns of related tables in the output