2
Page 1
,► Structure of Relational Databases - Integrity Constraints, Synthesizin
ER diagram to relational schema
► Introduction to Relational Algebra - select, project, cartesian produ
operations, join - Equi-join, natural join. query example
introduction to Structured Query Language (SQL), Data Definitio
Language (DDL), Table definitions and operations – CREATE, DRO
ALTER, INSERT, DELETE, UPDATE.
Page 3
, 4
Page 3
, ► RelationalModel(RM) represents the database as a collection
of relations.
► A relation is nothing but a table of values.
► Every row in the table represents a collection of related
data values. These rows in the table denote a real-world entity or
relationship.
► It is used for data storage and processing
Page 4
Page 1
,► Structure of Relational Databases - Integrity Constraints, Synthesizin
ER diagram to relational schema
► Introduction to Relational Algebra - select, project, cartesian produ
operations, join - Equi-join, natural join. query example
introduction to Structured Query Language (SQL), Data Definitio
Language (DDL), Table definitions and operations – CREATE, DRO
ALTER, INSERT, DELETE, UPDATE.
Page 3
, 4
Page 3
, ► RelationalModel(RM) represents the database as a collection
of relations.
► A relation is nothing but a table of values.
► Every row in the table represents a collection of related
data values. These rows in the table denote a real-world entity or
relationship.
► It is used for data storage and processing
Page 4
