Please enable JavaScript.
Coggle requires JavaScript to display documents.
Relational model - Coggle Diagram
Relational model
-
INTEGRITY CONSTRAINTS: IT IS A CONDITION SPECIFIED ON A DATABASE SCHEMA AND RESTRICTS THE DATA STORED IN DATABASE
-
-
-
RELATIONAL ALGEBRA : A PROCEDURAL QUERY LANGUAGE .IT DESCRIBES THE PROCESS TO RETRIEVE DATA AND THE METHODS TO DO.
FUNDAMENTAL OPERATIONS ;SELECT,PROJECT,UNION,SET DIFFERNCE,CARTESIAN PRODUCT,RENAME
UNARY OPERATIONS : SELECT,RENAME,PROJECT
BINARY OPERATIONS:SET DIFFERNCE,JOIN,CARTESIAN PRODUCT,DIVIDE
TRC(TUPLE RELATIONAL CALCULUS) : A NON PROCEDURAL QUERY LANGUAGE.IT DEFINES HOW TO DO DATA RETRIEVAL RATHER THAN THE METHODS.
-
DRC(DOMAIN RELATIONAL CALCULUS) : IT IS ALSO NON PROCEDURAL LANGUAGE . IT IS
EQUIVALENT IN POWER TO TRC.
QUERY EXPRESSED AS { <X1,X2,X3....Xn
|P(X1,X2,X3..Xn) }
OPERATIONS : SELECT,UPDATE,ALTER,INSERT