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

Questions asked in this paper

1. Q1 Attempt any Two
   • a) What is the role of DBA? do by DBMS? What are its applications?
   • C) ain the operation of two-tier client/server architecture for RDBMS
   • d) Write a short note on views of data
2. Q2 Attempt any Two. 10 marks
   • a) Explain evolution process of data model
   • b) What are the Basic building blocks ofa data model?
   • c) Write a short note on Business Rules What are the different degrees of data abstraction? 4 Q.3 Attempt any Two
   • a) 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 What do you mean by Normalization? Explain it with all normal forms
   • c) Explain the types of attributes used in ER model. Illustrate with proper examples What do vou mean by UML? Briefly explain any two diagram of it Explain various set operations used in Relational Algebra
   • b) Write a short note on Relational Algebra
   • c) What is the difference between calculus and algebra?
   • d) Explain Projection and Rename operation with proper example
3. Q5 Attempt any Two. 10 marks
   • a) What do you mean by trigger? Explain it with example
   • b) How views provides security to the data?
   • c) What are the basic data types available for the attributes in SQL? 4 d) Consider following tables:
   • i)Display the authors whose name starts with and ‘M’ as third letter 3 Find the number of copies ordered for each book
   • iii)'Create a view showing maximum of ordered amount and minimum of ordered
4. Q6 Attempt any Two. [0]
   • a) Write a short note on Transaction State
   • b) Briefly explain conflict serializability Write a short note on deadlock. Explain deadlock prevention schemes How concurrency is achieved in the database?
   • a) What are the different types of database end users? Discuss the main activities of each
   • b) Explain different types of data models
   • c) What do you mean by Weak Entity 3 Explain tuple relational calculus How to add foreign key constraint and Uniqueness constraint in the table? 3
   • f) What do mean by transaction? Explain ACID properties of

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