Database Schema Design Using Entity-Relationship Approach
1Database Schema DesignUsingEntity-Relationship Approach (ER Approach or ER Model)Tok Wang LingNational University of Singapore2TopicsER Model2 Concepts/Constructs in ER Approach and diagramoCardinality vs. Participation ConstraintoWeak Entity Type, EX/ID Relationship Types, generalization and specializationoSome extensions: Aggregation, Multiple FDs Representation English Sentence Structure and ER Diagramoself study ER Construct Notation comparison Database Schema Design Using ER Approach Translation of a (Normal Form) ER Diagram to a RDB A Normal Form for ER Diagram333 ER Approach was proposed by Prof. Peter Chen in TODS 1, 1976. Main Concepts:- entity ( object ) - relationship- attributeBrief ideas:English correspondencenoun entity verb relationship Ref: Peter Chen paper TODS 1976 Elmasri&Navathe s book Korth s book Hawryzkiewycz s bookPersonPerson(entity)John(entity)Mary Married tohusband(role)wife(role)(relationship)E R Model444Entity: An entity is an object which exists in our mind and can be distinctly identified.
ER Construct Notation Comparison ... An entity is an object which exists in our mind . and can be distinctly identified. Q: How to identify entities? E.g. - Ng Hong Kim with NRIC S0578936I - Account# 563978 of DBS Bank ... relational model the same? If not, what are the main differences between them? ...
Download Database Schema Design Using Entity-Relationship Approach
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: