Please enable JavaScript.
Coggle requires JavaScript to display documents.
Relational model(Relational Model (RM) represents the database as a…
Relational model(Relational Model (RM) represents the database as a collection of relations)
Keys
Primary key
Candid key
Foreign key
Super key
Database Schema
Schema(overall structure)
Instance(snapshot of data a particular time)
Relational query languages
Relational algebra
unary operations
union
set difference
project
cartesian product
select
rename
Binary operations
join
inner join
Equi join
Full outer join
Theta join
outer join
Right outer join
Full outer join
Left outer join
divide
Tuple relational calculus
Domain relational calculus
Structure of relational database
