Er schema can be represented by relation schemas , Database Management System

Assignment Help:

Q. Describe how an ER schema can be represented by relation schemas and constraints arising from ER design can be mapped to constraints on a relation schema.   

The entity relationship data model is based on a perception of a real world that consists of basic objects called entities and of relationships among these objects. An entity is thing or object in the real world that is distinguishable from other objects. For eg., each person is an entity and band accounts can be considered as entities. Entities are described in a database by set of attributes. For eg., the attributes account number and balance may describe one particular acconunt in a bank and they form attributes of the account entity set. An extra attribute customer id is used to uniquely identify customers. A relationship is an association among several entities. For eg., a depositor relationship associates a customer with each account that he has. The set of all entities of the same type and the set of all relationship of the same type are called entity set and relationship set respectively. The overall logical structure of a database can be expressed graphically by and ER diagram, which is buily up using : R ectangles -  which represent entity sets    Ellipses -  which represent attributes     Diamonds -  which represent relationships   Lines -  which represent link attributes to entity sets.   Each component is labelled with the entity or relationship that it represents.  Constraints to which the contents of database must confirm. For eg.,  mapping cardinalities, which express the number of entities to which another entity can be asociated via a relationship set.                                                                                                                  


Related Discussions:- Er schema can be represented by relation schemas

What is known as sequential file organization, What is known as sequential ...

What is known as sequential file organization? In the sequential file organization, the records are kept in sequential order, according to the value of a "search key" of every

Determine the types of methods for retrieving rows in python, Describe the ...

Describe the two types of methods for retrieving rows in Python? Fetchone()- Returns the next row as a sequence Fetch all()- Returns the entire result set like a strin

Database design in third normal form, The following data are required to be...

The following data are required to be stored by a family physician. Family#, FamilyAddress, Patient#, PatientName, ServiceCode, ServiceFee, ServiceDate A family can have seve

What is meant by buffer blocks and disk buffer, What is meant by buffer blo...

What is meant by buffer blocks and disk buffer   The blocks residing temporarily in main memory are referred to as buffer blocks. The area of memory where blocks reside t

Explain the three data anomalies, What are the three data anomalies that ar...

What are the three data anomalies that are similarly to take place as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why n

What is the use of with clause in sql, What is the use of with clause in SQ...

What is the use of with clause in SQL? The with clause gives a way of defining a temporary view whose explanation is available only to the query in which the with clause occurs

Which components of the schema architecture proposed by ansi, What are thre...

What are three components of the schema architecture proposed by ANSI/SPARC? The three component schema architecture proposed by ANSI/SPARC is as given below: External sche

Write expressions in relational algebra, Given the subsequent relations: ...

Given the subsequent relations:    vehicle (reg_no, make, colour)    Person (eno, name, address)    Owner (eno, reg_no)   Write expressions

Entity identifier key attributes, An entity type usually has an attribute w...

An entity type usually has an attribute whose values are distinct for every individual entity in the collection. Such an attribute is known as a key attribute and its values can be

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd