Entity-Relationship (ER) Model

Entity-Relationship (ER) Model

1. Using high level conceptual data models for DB design

   • Using high level conceptual data models for DB design

2. A DB application: Company DB

3. Entity, attributes and keys

4. Types of attributes

5. Entity types, entity sets, keys and value sets

6. Key attributes of an entity type

7. Value sets (domains of attributes)

8. Initial design of the company DB

9. Relationship

10. Cardinality ratios

11. Participation constraints and existence dependencies

12. Attributes of relationship types

13. Weak entity

14. Refining the ER design for the COMPANY database

15. Naming conventions and design issues

16. Naming conventions and design issues

17. Design choices for ER conceptual design

18. UML class diagrams

19. Higher degree relationship

20. Higher degree relationship