Find your question
and Get expert's answers*
Homework Help
*Click here to submit
Refer a Friend
Discount up to 15%*
Prepared References
Save up to 50%*
Homework Help >> Database Management System
  Architecture of dbms

Question 1: Describe the architecture of DBMS with a neat block diagram:

a) Storage manager 
b) Query processor 
c) Block diagram

Question 2: Describe ER model in detail:

a) Attribute set 
b) Entity set 
c) Mapping cardinalities 
d) Relationship sets 
e) Keys

Question 3: Describe the design issues of ER-model:

a) Use of entity sets versus Attribute sets 
b) Use of Entity sets versus Relationship sets 
c) Binary versus Nary relationship sets 
d) Placement of relationship sets

Question 4: Describe the different relational algebra operations

a) Select operations 
b) Project operations 
c) Union operation
d) Set difference operations 
e) Cartesian product operations 
f) Rename operations

Question 5: Draw an ER diagram for the banking enterprise.

a) Data requirements 
b) Entity sets 
c) Relationship sets 
d) ER diagram 




Answer

Architecture of dbms


Request for solution file

Course: Database Management System

Ref. No:- TGS07172

Like US:-
Assignment Help

Ask an Expert & Get Answer

  • Quality work delivery
  • 100% Plagiarism free
  • Time on delivery
  • Privacy of work
Order Now
More Database Management System Questions


Write down the difference between the Database system and the File system.
Write down the actions taken by recovery manager during check pointing. Describe the architecture of distributed databases.
Describe briefly the three components of a Client/Server Architecture, and use a fully labelled diagram to show the interaction between the componen
Database backup is of prime importance for any organization, in general terms one can easily say the bread and butter of an organization is the databa
Is the table definition in 1NF? Why or why not? If not, convert the table to 1NF table.
Write down a program in DBASE III plus to find the biggest among 3 numbers using IF Statement.
Now write down the queries in relational algebra to: a) List out the title of books reserved by the Professors older than 45 years.
What variables are you going to need and what will be their data type.
Describe at least four advantages of granularity of data in the warehouse design.
Your database has been a hit. You have been called back to the customer's headquarters and they want a detailed report and plan how to convert the mas