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
How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct

FDs in Relationships:  Enrols Relationship: None as it is many to many Teaches Relationship : Course code → Instructor Instructor → Course code The next question is:

What are the physical characteristics of magnetic disks?   Ans: A magnetic disk is a circular plate or platter of plastic or metal that is coated with magnetizable material lik

Attributes having a one value for a particular entity. For instance, Age is a single valued attribute of a student entity. Attributes  that  have  more  than  single  values

Need for Multiple Access Paths In practice, most of the online information systems need the support of multi-key files. For example, consider a banking database application hav

Cyber Transit Ltd keeps up-to-date information on the processing and current position of each dispatched item. Dispatched items are the main concern of the Cyber Transit product tr

Define Physical and Logical independence  Ans: Physical data independence: The ability to modify physical level without causing application program to be rewritten. Logic

System level permissions : With the use of data dictionary you can view them.       Let us take the table name as user_sys_privs (used in oracle).       DESCRIBE USER_SYS_PRI

Define an abstraction by which relationships are treated as higher level entities Ans: Aggregation.  It is an abstraction by which relationships are treated as higher level

E-R model uses this symbol to represent weak entity set ? A Doubly outlined rectangle symbol is used to represent weak entity set.