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

What is foreign key? A relation schema r1 derived from an ER schema may contain among its attributes the primary key of another relation schema r2.this attribute is known as a

Define Network DBMS The NDBMS is built primarily on a one-to-many relationship, but where a parent-child representation between the data items cannot be ensured. This may occur

How many levels can be viewed in Architecture of the database ? Architecture of the database can be viewed as three levels.

What is a Built-in A notation of identity is built-into the data model or programming language and no user-supplied identifier is needed. This form of identity is used in objec

Cardinality shows the number of instances of an entity associated with another entity participating in a relationship. Depend on the cardinality binary relationship can be further

What is Candidate Key Super Key or Candidate Key: It is such an attribute of a table that can uniquely recognize a row in a table. Generally they have unique values and can n

Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai


What is relational model feature? A relational model feature is much more data independence than some other database models.