B.Sc. (Computer Science) Sem 2 Database Systems Apr 2024 Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 All questions are
2. Q2 Mixing of sub questions are not allowed
3. Q3 Write in clear and legible writing
4. Q1 any FOUR 20 marks
   • A) Explain the functions of DBA
   • B) Describe the overall architecture of DBMS with diagram
   • C) Describe various constraints of and Generalization
   • D) What is relationship in ER model? What are the types of mapping constraints? Order by clause with suitable example Write a on total participation and partial participation Attempt any FOUR (20)
   • A) Explain various operators available in Relational algebra
   • B) Explain JOIN in detail various String functions available in
   • D) various Math functions in MySQL
   • E) Explain concept of sub query in detail
   • F) Describe various for multiple sub query Attempt any FOUR (20)
   • A) What are the: types of Dependencies explain in brief
   • B) the properties of Decomposition explain in detail
   • C) anornalies with example
   • D) Define the term privilege with respect to database and its types Explain BACKUP and RESTORE in database the primary and secondary index with suitable example Attempt any FIVE (15)
   • A) What are the ciifferent types of database system
   • B) the term with suitable example it) Multivalued attribute
   • C) Explain CREATE and DROP command with suitable example
   • D) Explain domain relation constraints in detail
   • E) Explain concept of equi JOIN operation in Relational algebra
   • F) Write on

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