W5D2 Flashcards
(23 cards)
1
Q
When implementing a database schema, you must decide on three things:
A
2
Q
Normalization
A
3
Q
A
4
Q
Three-Valued (Ternary) Logic
A
5
Q
Query
A
6
Q
RDBMS
A
7
Q
SQL
A
8
Q
There are 4 main data manipulation operations that SQL provides:
A
9
Q
SELECT
A
10
Q
UPDATE
A
11
Q
INSERT
A
12
Q
DELETE
A
13
Q
Schema Definitions
A
14
Q
Querying across multiple tables (JOIN)
A
15
Q
many-to-many relationship
A
16
Q
Self Joins
A
17
Q
What is a self join?
A
18
Q
aliases
A
19
Q
SQL Conventions
A
20
Q
well formatted SQL code:
A
21
Q
Subqueries
A
22
Q
NULL and Ternary Logic in SQL
A
23
Q
standard comparison and equality operators
A
