1) What are the various types of integrity constraints? Describe referential integrity constraints.
2) Write down the difference between :
i) Entity integrity and referential integrity
ii) Primary key and foreign key
iii) Views and tables
3) Describe various types RDBMS architecture.
4) Where do you use the following relational algebra operators:
Select, project, join, assignment, subtraction, divide, join, divide, intersection
5) Explain following terms:
Relational algebra, join, union, divide, intersection, assignment, difference, relational calculus, Cartesian product, tuple variable, select, domain calculus,
6) Describe RDBMS in detail with examples.
7) What do you understand by SQL? Describe the different components of SQL in detail with appropriate examples.
8) Describe different types of operators in SQL.
9) Write brief notes on:
DDL, DML, DCL, embedded SQL, dynamic SQL, database objects, reserve words, variables, data types