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 the term Domain. For each n every attribute there is a set of permitted values known as the domain of that attribute.

Authorisation Authorisation is the culmination of the administrative policies of the organisation.  As the name shows, authorisation is a set of rules that can be used to verif

Explain the Weak Entity Set An Entity set which does not have sufficient attribute to make a primay key is known as weak entity set. For instance, dependents of an employee in

File Organisation In Dbms Introduction Databases are used to store information. Usually, the principal operations we have to perform on database are those relating to:

Rearrange Classes and Operations Sometimes, the similar operation is defined across different classes and can easily be inherited from a familiar ancestor, but more often oper

3NF Normal Form A relation schema R is in 3NF if it is in 2NF and for each FD X A either of the following is true X is a Super-key of R. A is a prime attribute of R

Describe the statement in SQL which allows to change the definition of a table? In SQL Alter statement is used to allow the changes the definition of a table.

Problem: (a) Given the following relation: Stats(Name,Sex,Children, Occupation, Salary, Tax, Audits) Write SQL code to define the following security constraints: (i) User

Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.

(a) Design a query plan for the following distributed query: An application at site B wants to compute a join of STUDENT ? Id=StudId TRANSCRIPT where STUDENT (Id,Major) is at site