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
Name the three major set of files on disk that compose a database in Oracle. There are three main sets of files on disk that compose a database. All the files are binary. These

Secondary Indexes Let consider the student database and its clustering index and primary (only one will be applicable at a time). Now consider the state when the database is to

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

There are many simple and complex approaches to implement. These reports are based on some views or certain query. The following number of reports can be built. 1. The averag

Database design Database tables will be created for you on the Technology web server. The schema will be as follows. Please note that this is a simplified database structure, d

What are domain constraints? A domain is a set of values that might be assigned to an attribute .all values that appear in a column of a relation must be taken from the similar

Update or Modify operation alters the existing values. If these operations alter the value that is the foreign key also, the only check need is the similar as that of the Insert op

what should be included in this???

Draw and explain the three level architecture of the database system? A DBMS gives three levels of data is said to follow three-level architecture. The trget of the three-schem

Consider employee (e_no, e_name, e_salary, d_code), dept (d_code, d_name) and dependent (depndt_name, e_no, relation). Show the names of employees in purchase and accounts departm