Week 6
Database Design Continued
,RECAP
The questions to ask:
What are the entities (= objects, individuals) in the organization?
Which relationships exist among the entities?
What information (= attributes) do we want to store about these
entities and relationships?
What are the business rules of the organization?
Which integrity constraints do arise from them?
The answers are represented in an Entity Relationship Diagram (ER
diagram)
,CHEN’S NOTATION
Entity
Student
Attribute StudentNumb
GivenNam
er
e
Relationship
enrol
Cardinality Student
s
Course
, EXAMPLE OF CHEN’S
NOTATION ERD