Databases with MySQL

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