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

Questions asked in this paper

1. Q2 Attempt any two
   • a) What Is Process of evolution of data model’? ) at are the different degrees of data abstraction? Attempt any two
   • a) What is Unified Modelling Language? guag plain Activity Diagram and
   • b) Write a short note on Primary Key Constraint and Check Explain different types of participation constraint used in ER model
   • d) What are the features of good relational database design
2. Q4 Attempt any two
   • a) Explain various set operations used in Relational Algebra
   • b) How to perform a join and renaming using relational algebra?
   • c) Write a short note on domain relational calculus
   • d) Write a short note on Relational Algebra
3. Q5 Attempt any two
   • a) What do you mean by Join? Explain Equi-Join and Full Outer Join with
   • b) What are views? How views of
   • d) Consider following tables: Solve following queries: > of 70 to 80 student details having marks is in the range
   • i) howing the details of student enrolled in each class long with their class details in which they enrolled
4. Q6 Attempt any two
   • a) Write a short note on Transaction state. q Explain Timestamp Ordering What do you mean by serializability? Explain view serializabity Explain Two Phase Locking protocol Attempt any Three! ‘ews of data by data abstraction? Also explain different view 4 short on Business Rules. ‘ssion in the college for the + an E-R diagram college. Student takes admissi What do you mean by a subquery tion schemes

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