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 

Ask an Expert for Solution

Ask an Expert for Answer Architecture of dbms

Request for Solution Files

Expected delivery within 24 Hours

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

Objective of this project is to develop complete data centric application. Representing the requirements into logical design using Entity Relationship
the need for three level architecturethe aim of the three level architecture is to divide each users view of the database from the way the database
What do you mean by cache coherence? How can the problem are solved with a snoopy cache controller?
explain cnt in the respects of qbe cnt it is one of the aggregation commands given in qbe it is used to identify number of
Write down a program in DBASE III plus to find the biggest among 3 numbers using IF Statement.
How can you store the XML data in relational databases using tree representation? Describe. How the various geometric constructs can be represented in
how is concurrency identifiedconcurrency in objects can be identified by the way they alter their state current objects can change their state
what is meant by heuristic optimisation discuss the main heuristics that are applied during query optimisation ans in heuristic
what are the properties in a relation in a relation ordering of rows is immaterial and no two rows are
this constraint shows that the key attribute value in each tuple must be unique ie no two tuples have the similar value for the key attribute this is