E-r diagram, Database Management System

Let us now make the E-R diagram for the student database as per the explanation given in the previous section.

We can also states the overall logical structure of a database using ER model graphically with the help of an E-R diagram.

ER diagrams are composed of:

  • Rectangles showing entity sets.
  • Ellipses showing attribute.
  • Diamonds showing relationship sets.

823_E-R DIAGRAM.png

Figure: ER diagram of COLLEGE database

Posted Date: 3/6/2013 6:23:11 AM | Location : United States







Related Discussions:- E-r diagram, Assignment Help, Ask Question on E-r diagram, Get Answer, Expert's Help, E-r diagram Discussions

Write discussion on E-r diagram
Your posts are moderated
Related Questions
Explain the rules for creating a labelled precedence graph for testing view serializability.            Ans: A schedule S is view serializable if it is view equivalent to a ser

List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti

Question : Mr. Smith Harry has a car manufacturing company which has recently integrated management information system. He wishes to obtain more information on ethics and socia

What are the Constituents of File? Also elaborates all the possible file operations? A file is organised logically as sequence of record. These records are mapped onto disk blo

Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs

(a) Explain briefly the three parts of a relational Model. (b) Contrast the following terms with an appropriate example: (i) stored attribute v/s derived attribute (ii) en

State the meaning of Object Representation  The term object representation means "to represent object with the help of objects model symbols". Implementing objects is too simp

Question 1 Suppose the employee employee id, name, designation, salary, attendance and address of any employee has to be stored in a database. You can store these data in a sequen

create an e-r diagram usuing graphical dipicted software that could theoritically be used in resturant application

Define in which normalisation form if an attribute of a composite key is dependent on an attribute of other composite key. Ans: 3NF A relation is in 3 NF if an attribute of