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


system level permissions with the use of data dictionary you can view them let us take the table name as usersysprivs used in
edinburgh airport officials are concerned about complaints received by the service department and are about to do an overhaul of the service
Suppose a queue contained the entries A, B, C, D (from head to tail) and suppose that the entries were removed and pushed on a stack one at a time unt
explain candidate keycandidate key - a candidate key is a minimal superkey that can be used to uniquely identify a tuple in the
illustrate different types of locks in sql serverthere are three kinds of locks in sql serveri shared locks - these are used for operations which
it is mandatory that for every table in the ldb hierarchy there should exist one get statement in the report false it is not
1identify and discuss the serious data redundancy problems exhibited by the file structure shown in figure2looking at the empname and empphone
automated system for appointment with sms and call confirmation with service providers and user has to be initiate automaticallyafter selecting time
list the steps for converting state diagram to the codea finding major control pathb finding the conditional statements c finding the loops d
how to create a table from existing tablecreate table lttable-namegt as ltselect-statementgteg to create a new table lsquonemp with employee names