Entity relationship model, Database Management System

Let us first look into some of the important features of ER model.

  • Entity relationship model is a high-level conceptual data model.
  • It permits us to define the data involved in a real-world enterprise in terms of objects and their relationships.
  • It is widely used to develop a first design of a database.
  • It gives a set of useful concepts that make it convenient for a developer to move from a basic set of information to a detailed and defined description of information that can be easily executed in a database system.
  • It defines data as a collection of relationships, entities and attributes.


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

Related Discussions:- Entity relationship model, Assignment Help, Ask Question on Entity relationship model, Get Answer, Expert's Help, Entity relationship model Discussions

Write discussion on Entity relationship model
Your posts are moderated
Related Questions
Define Physical and Logical independence  Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic

Using your cache simulator and using smalltex.din as your memory trace determine the total miss rate, compulsory miss rate, capacity miss rate, and conflict miss rate for the follo

What are the three types of data sources used with ODBC? An ODBC file data source is a file that can be shared between database users. An ODBC system data source is one that is

does tables are called relations

What is a super key? A super key is a set of one or more attributes that collectively permits us to recognize uniquely an entity in the entity set.

What do you mean by Correlated subquery? Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is writ

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

Define the five basic operators of relational algebra? Five basic operators of relational algebra are: 1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both

Differentiate between Key and superkey? Key and superkey - A key a single attribute or a combination of two or more attributes of an entity set in which is used to identify o