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
1 NF Normal Form The domain of attribute must add only atomic (simple, indivisible) values First normal form (Minimal Form or 1NF) is a normal form need in database normalizat


The C_Artist  application will be developed using the C language (C99 standards) and will be able to compile without warnings and link and run in the Swinburne computer laboratorie

Question: (a) Discuss the difference between a composite key and a composite attribute. How would each be indicated in an E-R diagram? Support your answer with appropriate exam

Write a short note on built in function in QBE? Built in function in QBE: QBE involves various built in functions like AVG, MAX,MIN,SUM and CNT. We must prefix these operator


Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t

With the help of a suitable diagram gives module wise explanation of system architecture of DBMS.on..

How does a query tree represent a relational algebra expression?  Discuss any three rules for query optimisation, giving example as to when should each rule be applied.     Ans

Define the terms i) DDL ii) DML DDL: Data base schema is particular by a set of definitions expressed by a special language known as a data definition language. DML: A data