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
Explain the functions of data manager? Functions of Data Manager : - Convert operations in user's queries coming directly through query processor or indirectly in an applicatio

Describe Object Relational model ? Object Relational Model - This model combines the characteristics of both relational model and object oriented model. It extends the tradit

The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product

Compare wait-die deadlock prevention scheme with wait-wound scheme   Ans:  Wait-Die Scheme  a) Based upon a nonpreemptive technique.  b) If Pi requests a resource present

Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or   among various values of the sam

Describe Database state in details? Database state: The actual data within the database at a particular moment in time is known as a database state.

What are the costs to be considered when a transaction has to be rolled back when recovering from deadlock?         Ans: A few transaction will must rolled back (made a victim)

Why DML is used for? DML is used to Manipulation and processing of database. DML is provided for manipulation & processing of database. (Data stored in the database is processed

Use inheritance as an implementation technique when you are going to use inheritance as an implementation technique, you can achieve same goal in a safer way by making one cla

Partial Key : It is a group of attributes that can uniquely identify small entities and that are related to same base entity. It is sometime named as Discriminator.  Altern