BSc IT Sem II 2014 2015 2015 DBMS Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt any two
   • a) Explain the three-tier client/server architecture. Where it is used?
   • b) What do you mean by data abstraction? Also explain different views of data
   • c) What is the role of DBA?
   • d) Explain all types of database users
2. Q2 Attempt any two. {10}
   • a) Explain the importance of data
   • b) Exolain different types of data models What is the process of evolution of data model?
   • d) What are the different degrees of data abstraction’
3. Q3 Attempt any two
   • a) What is Unified Modelling Language? Explain Class Diagram and
   • b) Write a short note on Primary Key Constraint and Key Explain different types of mapping cardinalities used in ER model
   • d) What are the features of good relational database design?
4. Q4 Attempt any two
   • a) Explain relational
   • b) How to perform a join and renaming using relational algebra?
   • d) Write a short note on Relational Algebra
5. Q5 Attempt any two. 10 marks
   • a) What do you mean by a subquery ? Give query example of it
   • b) What are views? How views provide security of data? Explain all aggregate functions used in SQL Solve following queries:
   • i)Display student details having marks is in the range of 70 to 80
   • ii) Create a view showing the details of student enrolled in each class
   • iii) Display student details along with their class details in which they enrolled Attempt any two Explain Timestamp Ordering Protocol What do vou mean by serializability? Explain view ith a set of patients and a set of medical doctors, th various tests and examinations conducted eplain Right Outer Join and Full Outer Join with

Read from the scan above, so a character or two may differ. The scan is the original.