lecture 03 entity-relationship diagram. chapter outline
TRANSCRIPT
![Page 1: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/1.jpg)
Lecture 03
Entity-Relationship Diagram
![Page 2: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/2.jpg)
Chapter Outline
![Page 3: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/3.jpg)
Overview of Database Design Process
![Page 4: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/4.jpg)
Overview of Database Design Process
![Page 5: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/5.jpg)
Example COMPANY Database
![Page 6: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/6.jpg)
Example COMPANY Database(Contd.)
![Page 7: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/7.jpg)
ER Model Concepts
![Page 8: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/8.jpg)
Types of Attributes (1)
![Page 9: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/9.jpg)
Types of Attributes (2)
![Page 10: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/10.jpg)
Example of a composite attribute
![Page 11: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/11.jpg)
Entity Types and Key Attributes (1)
![Page 12: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/12.jpg)
Entity Types and Key Attributes (2)
![Page 13: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/13.jpg)
Displaying an Entity type
![Page 14: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/14.jpg)
Entity Type CAR with two keys and acorresponding Entity Set
![Page 15: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/15.jpg)
Entity Set
![Page 16: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/16.jpg)
Initial Design of Entity Types for theCOMPANY Database Schema
![Page 17: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/17.jpg)
Initial Design of Entity Types:EMPLOYEE, DEPARTMENT, PROJECT,
DEPENDENT
![Page 18: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/18.jpg)
Refining the initial design by introducing
relationships
![Page 19: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/19.jpg)
Relationships and Relationship Types (1)
![Page 20: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/20.jpg)
Relationship type vs. relationship set (1)
![Page 21: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/21.jpg)
Relationship type vs. relationship set (2)
![Page 22: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/22.jpg)
Refining the COMPANY databaseschema by introducing relationships
![Page 23: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/23.jpg)
Discussion on Relationship Types
![Page 24: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/24.jpg)
Recursive Relationship Type
![Page 25: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/25.jpg)
Weak Entity Types
![Page 26: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/26.jpg)
Constraints on Relationships
![Page 27: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/27.jpg)
Recursive Relationship Type is: SUPERVISION
(participation role names are shown)
![Page 28: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/28.jpg)
Attributes of Relationship types
![Page 29: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/29.jpg)
Notation for Constraints onRelationships
![Page 30: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/30.jpg)
Alternative (min, max) notation forrelationship structural constraints:
![Page 31: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/31.jpg)
Alternative diagrammatic notation
![Page 32: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/32.jpg)
Summary of notation for ER diagrams
![Page 33: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/33.jpg)
Extended Entity-Relationship (EER)Model (in next chapter)
![Page 34: Lecture 03 Entity-Relationship Diagram. Chapter Outline](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfd91a28abf838caf966/html5/thumbnails/34.jpg)
Chapter Summary