munotes®

Engineering BE Electronics and Telecommunication Sem 6 May 2023 2023 EXTC6 Database Management Systm Question Paper - Mumbai University | munotes

May 2023 Question Paper.pdf
EXTC · 1 May 2025

Loading PDF...

Questions asked in this paper

  1. Q2 Attempt any THREE questions out of remaining FIVE questions
  2. Q3 Figures to the right indicates full marks
  3. Q4 Assume suitable data if necessary Explain in brief the database system architecture with block diagram B Explain three levels of data abstraction. Distinguish between Physical Independence and logical data independence. Which is more difficult to achieve? C are the advantages of DBMS over file System? State the difference between Relational Algebra and Relational Calculus Explain DDL, DML and DCL Commands in SQL with its example F conflict and view serializability A Construct ER diagram and convert into relational model for Airline reservation 10 B Explain two phase locking protocol in detail. 10 A Consider the Following relation: 10
  4. Q1 Write a query to display names of person containing letters ‘S’
  5. Q2 Write a query to list number of persons with age > 28 marks
  6. Q3 Write a query to list person drawing Maximum salary
  7. Q4 Find the avg of salary
  8. Q5 Write a query to insert new values in the given relation B Define Normalization. Explain with example 10 Write the following queries in SQL
    • (a) Find all customers of the bank who have an account but not a loan
    • (b) Find the names of all branches with customers who have an account in the bank and who live in
    • (c) Delete the record of all accounts with balances below the average at the
    • (d) Find out the total sums of all loan amounts in the bank
    • (e) Find the names of all branches where the average account balance is more B Analyze the concept of specialization and generalization? What are the different 10 types of constraints involved in specialization? Distinguish between Total and partial participation and between Disjoint and Overlapping specialization A Explain and solve the following relational algebra operation with example 10
    • E. Rename Operator B Illustrate problems of concurrency control with example. 10
  9. Q6 Attempt any two of following Explain Codd’s Rule in Detail Explain Database Recovery Management c Data Models with example 20 marks

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

Report or request

Something wrong on this page? Report it and we will check it against the scan.

Quick Help

No. The full paper opens straight away, with no login and nothing to pay.

Something wrong with this paper? Report it.

Connected Papers
Engineering / EXTC · 240 papers
Browse all →
2023 - EXTC3 Engineering Mathematics III 2023 - EXTC3Digital System Design 2023 - EXTC3Electronics Instrumentation And Control System 2023 - EXTCDSE3 Digital System Design 2023 - EXTC3 Elctronic Device And Circuits 2023 - DSE EXTC3 Eletronic Device And Circuits 2023 - EXTC3Network Theory 2023 - EXTC DSE3 Engineering Mathematics III 2023 - EXTCDSE3Network Theory 2023 - DSE EXTC3Electronics Instrumentation And Control System 2022 - Network Theory 2022 - Digital System Design 2022 - Engineering Mathematics III 2022 - Electronics Instrumentation And Control System 2022 - Electronics Devices And Circuits 2022 - Digital System Design 2022 - Network TheoryDSE 2022 - EXTC Engineering Mathematics IIIDSC 2022 - Digital Electronics 2022 - Electronics Devices And CircuitsDSE 2022 - Electronics Instrumentation And Control SystemDSE 2019 - Analog Electronics I 2019 - Analog Electronics I 2019 - Applied Mathematics III 2019 - Applied Mathematics III EXTCCBSGS 2019 - Applied Mathematics 2019 - Circuit Theory And Networks 2019 - Circuit Theory And Networks 2019 - Circuits And Transmission Lines 2019 - Digital Electronics 2019 - Electronic Devices And Circuits I 2019 - Electronic Instruments And Mesurements 2019 - Electronic Instruments And Mesurements 2019 - Electronics Devices And Corcuits I 2019 - Electronics Instrumentation And Control 2018 - Applied Mathematics III 1CBSGS 2018 - Applied Mathematics III 2018 - Circuit Theory And Networks 2018 - Circuits And Tranmission Lines 2018 - Digital Electronics 2018 - Electronic Instruments And Mesurements 2018 - Electronics Devices And Circuits I 2018 - Electronics Instrumentation And Control
2023 - EXTC4Signals And Systems 2023 - EXTC4 Principles Of Communication Engineering 2023 - EXTC4 Linear Integrated Circuits 2023 - EXTC4Microcontrollers 2023 - EXTC4 Engineering Mathematicd IV 2023 - EXTC4Image Processing And Machine Vision 2022 - EXTC Signals And System 2022 - Microcontrollers 2022 - Linear Integrated Circuits 2022 - EXTC Principles Of Communication Engineering 2022 - Signals And Systems 2022 - Principles Of Communication Engineering 2022 - Microcontrollers 2022 - Engineering Mathematics IV 2022 - Linear Integrated Circuits 2022 - Engineering Mathematics IV EXTC 2019 - Analog Electronics II 2019 - Analog Electronics II 2019 - Applied Mathematics IV 2019 - Applied Mathematics IV extccbsgs 2019 - Applied Mathematics IV EXTCCBSGS 2019 - Applied Mathematics IV 2019 - Control Systems 2019 - Control Systems 2019 - Electronics Devices And Circuits II 2019 - Electronics Devices And Circuits II 2019 - Linear Integrated Circuits 2019 - Linear Integrated Circuits 2019 - Microprocessores And Peripherals 2019 - Microprocessores And Perpherals 2019 - Principles Of Communication Engineering 2019 - Principles Of Communication Engineering 2019 - Signals And Systems 2019 - Signals And Systems 2019 - Signals And Systems 2019 - Signals And Systems 2019 - Wave Theory And Propagation 2018 - Analog Electronics II 2018 - Applied Mathematics 2018 - Applied Mathematics 1CBSGS 2018 - Control Systems 2018 - El Ectronics Devices And Circuits II 2018 - Linear Integrated Circuits 2018 - Microprocessores And Peripherals 2018 - Principles Of Communication Engineering 2018 - Signals And Systems 2018 - Signals Ans Systems 2018 - Wave Theory And Propagation
2023 - EXTC6Computer Communication Networks 2023 - EXTC6 Digital ForensicDLOC 2023 - EXTC6 Artificial Neural Network And Fuzzy Logic 2023 - EXTC6 Database Management Systm Open 2023 - EXTC GAME THEORY USING AIML HONOUR 2022 - TE EXTC Electromagnetics And Antenna 2022 - TE EXTC Microcontroller Ans Applications 2022 - EXTC Artificial Neural Networks And Fuzzy Logic 2022 - EXTC Database Management System 2022 - Computer Communication Network 2022 - EXTC IPMV Image Processing Machine 2022 - EXTC Digital Forensic 2022 - Artificial Neural Network And Fizzy Logic 2022 - Image Processing And Machine Vision 2022 - Electromagnetics And Antenna 2022 - Database Management System 2022 - Mathematics For AI And ML 2019 - Antenna And Radio Wave Propagation 2019 - Antenna And Radio Wave Propagation 2019 - Computer Communication And Telecom Networks 2019 - Computer Communication And Telecom Networks 2019 - Computer Communication Network 2019 - Computer Communication Networks 2019 - Database Management System 2019 - Database Management System Elective IIChoice Base 2019 - Digital Communication 2019 - District Time Signal Processing 2019 - Electrical Machines III 2019 - Image Processing And Machine Vision Lab 2019 - Image Processing And Machine Vision Lab 2019 - Microcontroller And Applications 2019 - Microcontroller And Applications 2019 - Operating Systems 2019 - Operating Systems 2019 - Rader Engineering Elective IIChoice Base 2019 - Television Engineering 2019 - VLSI Design 2018 - Computer Communication And Telecom Networks 2018 - District Time Signal Processing 2018 - Oprating Systems 2018 - Television Engineering 2018 - VLSI Design
Questions? Email contact@munotes.in
Done!
Done!