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 


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

why generally does an object-oriented system use the relational dbmsthe reasons for using relational dbms for oo systems could be any combination of
data warehousing amp mining1what is the concept of knowledge discovery in database2describe the following types of multidimensional data
what is relational model featurea relational model feature is much more data independence than some other database
Your current database uses dictionary managed tablespaces. In running various performance tuning scripts, you have discovered that one of these tables
Describe the significance of ER Model for the Database design?
How to creat a Data Dictionary, Hierarchy Chart for the chocolate delights candy company manufactures several types.
questiona differentiate between the following termsi distributed database vs distributed database management system ii homogeneous distributed
fds in relationships enrols relationship none as it is many to manyteaches relationship course code rarr instructorinstructor rarr course codethe
what is difference between truncate and delete- truncate cant be rolled back whereas delete can be- truncate keeps the lock on table whereas delete
explain algorithm of er to relational mapping er-to-relational mapping algorithm1 step 1 mapping of regular entity types for each strong entity type