Index

Symbols

2NF

3NF 4NF

A

aggregate function aggregate statistic aliasing ALL ALTER TABLE ambiguity

analysis AND ANY AS ASC auto increment AVG

B

BCNF BIGINT

BOOLEAN Boyce-Codd normal form

C

candidate key cardinality ratio alternate notation CHAR CHARACTER CHARACTER VARYING CHECK Chen notation clause closure column defined identity column expression comments common table expression conditional expressions consistency constraint check domain foreign key - SQL not null primary key referential integrity uniqueness violation

correlated subquery COUNT CREATE TABLE CREATE TABLE ... AS SELECT CREATE VIEW CROSS JOIN cross product - relational algebra cross product - SQL cross-reference table crow's foot notation CTE CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP

D

data adding modeling modifying removing retrieving types data model data type Boolean character string date exact decimal number floating point number integer time timestamp database consistency defined design relational model of

database management system database system DBMS DECIMAL decomposition DEFAULT default DELETE delete anomaly DESC DISTINCT division domain DOUBLE DOUBLE PRECISION double quotes DROP TABLE DROP VIEW

E

entity regular weak entity attribute composite derived key multivalued

entity-relationship diagram equijoin ERD conversion to SQL EXCEPT EXISTS expression

F

False FLOAT FOREIGN KEY foreign key foreign key - relational model fourth normal form FROM

FULL [OUTER] JOIN function character string date and time mathematics functional dependency inference rules

G

GENERATED ... AS IDENTITY

GROUP BY grouping

H

HAVING

I

id column identifying relationship IN inconsistent INNER JOIN INSERT

insert anomaly INSERT INTO INSERT INTO ... SELECT INT INTEGER INTERSECT

J

JOIN join compared to subquery join - relational algebra join - SQL implicit outer

join - sql inner join condition

K

key - normalization superkey key - relational model candidate foreign primary unique

key - SQL foreign primary

L

LEFT [OUTER] JOIN LIKE literal Boolean character string number

logical model

M

many-to-many relationship - ERD many-to-many relationship - tables many-to-one relationship - ERD many-to-one relationship - tables MAX

MERGE MIN modification anomaly multiset multivalued dependency

N

name collision qualified natural join nested query normal form normalization decomposition

NOT NOT EXISTS NOT IN NOT NULL NULL - relational model NULL - SQL NUMERIC

O

ON [UPDATE|DELETE] CASCADE ON [UPDATE|DELETE] RESTRICT ON [UPDATE|DELETE] SET NULL one-to-many relationship - ERD one-to-many relationship - tables one-to-one relationship - ERD one-to-one relationship - tables operator Boolean character string comparison date and time mathematics

OR ORDER BY outer join

P

partial key partial participation participation partial total PARTITION BY

pattern matching physical model precision PRIMARY KEY primary key - relational model primary key - SQL projection

Q

query

query language query trees

R

REAL recursive relationship redundancy REFERENCES referential integrity constraint relation relation schema relational algebra relational calculus relational algebra operations cross product division intersection join natural join projection renaming selection set difference union

relational model of databases relationship - ERD attribute cardinality ratio higher-arity many-to-many many-to-one one-to-many one-to-one participation recursive relationship - tables many-to-many many-to-one one-to-many one-to-one renaming RIGHT [OUTER] JOIN row row value row value constructor

S

scalar value scale schema second normal form SELECT selection sequence SET set defined set operation - relational algebra difference intersection union set operation - SQL difference intersection union

SMALLINT SOME SQL statement string concatenation Structured Query Language subquery compared to join correlated used in Boolean expression used in FROM clause used in SELECT clause used in statement used in update subquery expression SUM

T

table creation cross-reference defined referenced referencing removal table value TEXT

theta join third normal form three value logic - SQL three-value logic - relational model total participation True TRUNCATE tuple attribute

U

UML unified modeling language UNION UNION ALL UNIQUE

unique key uniqueness universally unique identifier UPDATE update anomaly UUID

V

VARCHAR

view

W

weak entity weak key

WHERE window function WITH

You have attempted of activities on this page