Preparing your PDF
Loading PDF viewer...
Database Concepts and Architecture
Semester
Subject
💡 Jump to Important Questions ↓
Important Questions
Important Questions
Database Concepts and Architecture
Asked in 2080Short Question5 Marks
1.
What is data independence? How three schema architecture ensures logical and physical data independence? [5]
Asked in 2080Short Question5 Marks
2.
What are the Advantages of using DBMS? Explain in brief. [5]
Asked in 2079Short Question5 Marks
3.
What are the three layers of the Three-Schema Architecture? Explain. [5]
Asked in 2079Short Question5 Marks
4.
What is Database? Explain the characteristics of Database Approach. [5]
Asked in 2078Short Question5 Marks
5.
Explain Data Models, Schemas, and Instances. [5]
Asked in 2078Short Question5 Marks
6.
What are different types of Database Users? Explain in Brief. [5]
ModelShort Question5 Marks
7.
What is data independence? How three schema architecture ensures logical and physical data independence? [5]
ModelLong Question10 Marks
8.
Consider a database system with following schemas; Hospital(hname, haddress, hspecilaity) Doctor(did, dname, dspecilization, ) Worksat(did, hname, workinghrs) Pharmacy(phname, hname, no_of_sales, total_revenue) Now write SQL statements and relational algebra statements for following queries: a. Select name of all doctors having specialization 'gyno', b. Select the name and address of hospital where working hours is 'day', c. Using natural join select the name of doctors whose working hours are 'night', d. Find the average salary of the doctors, e. Find names of hospital and their pharmacy which generate revenue more than 10000. Sort the result in descending order on the basis of pharmacy name. [10]