Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL, image, image, image, image - Coggle Diagram
SQL
Sql data types and schemas
It is allowed to define a default value
Creation of an index for better identification of tuples
Binary data types clob and blob
Matrixes
Nested records
schemes
Catalogs
Transactions
Consult
Update
Implicit work
Commit work
Rollback work
concurrency control
Views
materialized views
keep up to date
view maintenance
no part of logical model
Use in queries
Updatable
calculate jobs
Other funtions
Authorizations
Read data
insert new data
delete data
grant rulings
Join
Outer Joins
Left outer join
right outer join
full outer join
Join sentences
unites information
Inner Join
normal join
Integrity restriction
Data consistency
protection against possible damage
Restrictions
Unique
There must be no tuples with a repeated value.
Are allowed to be null
Not null
Prohibition of a null value
Error message if you run
Primary keys are always not null
Check
Predicate
Condition restricting an attribute
An enumerated system can be simulated
Referential integrity
Foreign keys
Declare with create table
Also called subset dependence
When the restriction is violated the action is dismissed and reversed
Transaction integrity restriction violation
There is an initial deferral
Avoid confusion in restrictions
Many databases do not allow deferral
Check restriction clauses immediately
