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
Write a short note on QBE? Stands for "Query By Example." QBE is a feature involved along with various database applications which gives user-friendly techniques of running da

Data slice explanation

What are the basic objects of the data dictionary? Tables Domains Data elements Structures Foreign Keys

Difference between SQL and SQL*Plus SQL SQL*Plus SQL is a language SQL *Plus is an environment It   is   bas

QUESTION (a)(i) Define the term database. (ii) How is it different from a database management system? (b) What is the difference between an entity and an attribute? (c

What is data definition language? Explain it in detail? The SQL DDL allows specification of not only a set of relations, but also information after each relation, containing

What is Explicit update In explicit update, each derived attribute is defined with respect to one, or more fundamental base object(s). The object designer determines that de

Properties of a Transaction        A transaction has four main properties. These are: Atomicity Consistency Isolation or Independence Durability or Permanen

What is primary Key Explain? Primary Key - Primary key is one of the candidate keys. It should be selected such in which its attribute values are never, or very rarely, chang

Define data model? A data model is a collection of conceptual tools for explaining data, data relationships, data semantics and consistency constraints.