Week 8#
Lecturer: Uma Maheswari, Faculty for BITS Pilani WILP
Date: 11/Sep/2021
Topics Covered#
Tutorial RA#
Relational Algebra Introduction
Tuple Relational Calculus#
Example 1#
Example 2#
Example 3#
Question 1#
Question 2#
Question 3#
Question 1#
Question 2#
Question 3#
SQL Programming#
Introduction#
Different commercial SQL versions#
SQL statements#
Primary Key Constraint#
Foreign Key Constraint#
Example 1 - Employee DB#
Example 2 - Order DB#
VIEWS#
Example 3 Sailor DB#
