3 - Entity-Relationship Diagram (ERD)

Contents

After this week, the learner will be able to conduct a Requirements Analysis of a system to design a Relational Database using the Development Methodologies of the Entitity-Relationship Model. The learner should be able to conduct the following activities:

  •  Identifying Entities
  •  Identifying Attributes
  •  Identifying Keys
    • Primary Key
    • Foreign Key
  • Identifying Subsets of Entities
  • Occurrence Diagram 
  • Cardinality Analysis
    • 1:1 Relationship
    • 1:N Relationship
    • M:N Relationship
  • Identifying Participation

 

Tasks:

  • Lesson 3 - Entity Relationship (pdf)
  • (2) Entity Relationship Exercises
  • Define the theme and group members of the Database Group Project in the link provided


Last modified: Wednesday, 19 April 2023, 2:36 PM