BSc IT Sem II 2017 2018 2018 DBMS Question Paper - Mumbai University | munotes

Questions asked in this paper

• ii) Figures to the right indicates full marks, >

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 marks
   • a) Explain the importance of data model
   • b) Explain different types of data models
   • c) 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 Foreign Key
   • c) 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 tuple relational calculus
   • b) How to perform a join and renaming using relational algebra?
   • d) Write a short note on Relational Algebra
5. Q5 Attempt any two
   • a) What do you mean by a subquery ? Give query example of it
   • b) What are views? How views provide security of data?
   • c) Explain all aggregate functions used in SQL
   • d) Consider following tables: Solve following queries:
   • i)Display student details having marks is in the range of to 80
   • ii) Create a view showing the details of student in ea n cl
   • iii) Display student details along wit h their class details in hic!
   • a) Write a short note on Transaction s
   • b) Explain Timestamp Ordering Protocol What do you mean by lity? Explain view
   • d) Explain Two Phase Locking protocol
6. Q7 Attempt any Three. 15 marks
   • a) How a database approach differs from the traditional file system?
   • b) Write a short note on Business Rules
   • c) Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors Associate with each patient a log of the various tests and examinations conducted
   • d) Write a short note on domain relational calculus
   • e) What do you mean by Join? Explain Right Outer Join and Full Outer Join with
   • f) Write a short note on deadlock. Explain deadlock prevention schemes

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