Unit 2

Topics

• Relational Data Model →
• Keys and types of keys →
• Integrity Constraints →
• Relational Algebra →
• Relational Calculus →
• Tuple calculus →
• Query Language SQL →
• Basic SQL queries →
• SQL functions and constraints →
• Joins and nested queries →
• QBE (Query By Example) →
• Indexing →
• PL/SQL →
• Domains →
• Tuples →
• Attributes →
• Relations →
• Queries using Select →
• project →
• renaming →
• joins →
• union →
• intersection →
• difference →
• division →
• and product →