SRM University 2007 B.Tech Information Technology IT202-Data Base Management Systems - Question Paper

11. Construct an E-R diagram for a car-insurance cpmpany whose customers own 1 or more cars every.Each car has associated with zero to any number of recorded acccidents.
12. Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors.Associate with every patient a log of the different tests and exams conducted.
13. Design an E-R diagram for keeping track of the exploits of your sports team.You should store the matches played the scores in every match, the place in every match and individual players statistics for every match. Summary statistics should be modelled as derived attributes.


UNIT III

Part-A

1. Define relation, tuple & tuple variable, relationship data model, atomic domain.
2. Define foreign key, referring relation & referenced relation.
3. What is meant by schema diagram?
4. Give the differences ranging from schema &E-R diagrams.
5. What is meant by Query language? List the kinds of query language
6. Define procedural &nonprocedural language with example.
7. Define relational algebra.
8. List a few of the fundamental operations of relational algebra.
9. What is meant by unary &binary operations?
10. Give the use of additional operations of relational algebra.
11. List few of additional operations.
12. Extended operations.
13. Define aggregate fns with an example.
14. What is meant by outer join? provide its kinds
15. Define left, right & full outer join.
16. Define view.
17. What is meant by materialized views & view of maintenance?
18. Define view expansion. provide the procedure for view expansion.
19. Define updateable & reasonly views.
20. What is meant by tuple relational calculus?
21. What is meant by free & bound variable?
22. Give the rules to be followed while forming a formula.
23. Define Safe & Unsafe expression.
24. Define domain relational calculus.
25. Define multisets & grouping?
26. Give the several parts of SQL language.
27. Give the basic structure of SQL expression.
28. Briefly discuss set operations.
29. Define Nested sub queries.
30. Define complex sub queries.
31. What does Embedded SQL mean?
32. What does Dynamic SQL mean?
33. Give the two forms of integrity constraints.
34. What is meant by object-oriented data model?
35. What are the components of an object?


36. Define subclass & super class.
37. Define specialization, generalization.
38. What is meant by substitutability?
39. Define multiple inheritance, object identity.

Earning:   Approval pending.