Transcription of Database Schema Design Using Entity-Relationship Approach
{{id}} {{{paragraph}}}
1 Database Schema DesignUsingEntity-Relationship Approach (ER Approach or ER Model)Tok Wang LingNational University of Singapore2 TopicsER 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 Model444 Entity: An entity is an object which exists in our mind and can be distinctly identified.
1 Database Schema Design Using. E. ntity-R. elationship Approach (ER Approach or ER Model) Tok Wang Ling. National University of Singapore
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}