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

Consider the table student and list names of students in the departments other than maths and computer. SELECT std_name FRM student WHERE dept_name NOT IN (‘Maths','Computer);

Safe Banking is a Canberra based credit union, which has several branches around Canberra and Queanbeyan. YOU have taken over Safe Banking. YOU need to create a database that organ

Can a filed occur in several field groups. Yes.  But it leads to redundant data redundancy.

A collection of a same kind of entities is known as an Entity Set or entity type. Example: For the COLLEGE database defines earlier objects of concern are Students, Faculty,

Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following

gyan gurukul is a software company that provides software related solution.

Class Diagram A class diagram is required to support functional necessity of system. In a static design view, class diagram is used to model vocabulary of the system, simple c

A relation has: Relational Schema Relation instance Relational Schema: A relational schema shows the relation's name, its attributes and the domain of every a

What is D command work in the respect of QBE? D: It is the command inside QBE to delete tuple(s) from the relation.