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

explain the two types of participation constraint1 total the participation of an entity set e in a relationship set r is said to be total if each
in a relational model how relations are termedin a relational model relations are termed as tables the term lsquorelationrsquo is the technical name
differance between open addressing and chaining for collision resolution in open addressing proceeding from the occupied position specified by hash
defining internal classes and operations when we enlarge algorithms new classes can be added to the store intermediate results a complex operation
define multivalued dependency what do understand by trivial multivalued dependency ans a multivalued dependency is a full constraint among two
what is the use of group by clause group by clause is used to apply aggregate functions to a set of tuples
example-find the employee name salary department number and average salary of hisher department for those employees whose salary is more than the
there are three main sources of utilities and applications for a dbmsa vendor applications and utilities are given for working with or maintaining
give an example of operations from the functions of a bankfor creation of a saving account you can writebank create -savings-account
list the string operations supported by sql1 pattern matching operation2 concatenation3 extracting character strings4 converting among uppercase and