1) What are the various types of integrity constraints? Describe referential integrity constraints.
2) prepare 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) describe 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 exs.
7) What do you understand by SQL? Describe the different components of SQL in detail with appropriate exs.
8) Describe different types of operators in SQL.
9) prepare brief notes on:
DDL, DML, DCL, embedded SQL, dynamic SQL, database objects, reserve words, variables, data types