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

33. Define identifying or owner entity set.
34. What is meant by existence dependency?
35. Define identifying relationship.
36. Define discriminator or partial key.
37. describe specialization & generalization.
38. What is meant by “ISA”?
39. Give a few of the symbols used in E-R notation.
40. What is meant by tabular representation?





Part-B

1. A)Explain the distinctions among the terms Primary key, Candidate key & Super key.
B) discuss the distinction ranging from condition described & user described constraints. Which of these constraints can the system check automatically? discuss your ans.
2. A)Explain the difference ranging from a weak & a strong entity set. provide an example.
B)We can convert any weak entity set by simply adding improper attributes. Why then do we have weak entity sets?
3. (a)Explain the distinction ranging from disjoint & overlapping constraints.
(b)Explain the distinction ranging from total & partial constraints.
4. Define Constraints. discuss in detail the kinds of constraints with example.
5. Explain the basic problems in the design of an E-R database schema.
6. Explain how to convert a binary relationship set to a n-ary relationship set.
7. Discuss in detail the weak entity set.
8. Draw an ER diagram for a banking enterprise with the subsequent specifications..
(a) Branch including branch name ,branch city,and assets.
(b) Customer including customer id,customer name and address.
(c) Employee including employee id,employee name,telephone number,dependent name and date of joining.
(d) Loan including loan number and amount.
(e) Payment including payment number,date and amount.
(f) Account including account number and balance.
Indicate the strong entity set,weak entity set and relationship among them in the diagram.
9. Describe how an E-R schema can be represented by tables.
10. A university registrar’s office maintains data about the subsequent entities:
(a) courses, including number,title,credits,syllabus,and prerequisites;
(b) course offerings,including course number,year,semester,section number,instructors,timings and classroom;
(c) students,including student-id,name and program
(d) instructors, including identification number,name,department and title.
Further, the enrolment of students in courses and grades awarded to students in every course they are enrolled for must be appropriately modeled.
Construct an E-R diagram for the registrar’s office. Document all assumptions that you make about the mapping constraints.

Earning:   Approval pending.