Thursday, January 15, 2015

Entity Relationship Diagram for System Analysis and Design

'Sup. This is to explain further about some technical topics that students might find overwhelming in SAD. The topics in question are: Context Diagram, Data Flow Diagram, Entity-Relationship Diagram (ERD), and Normalization (Unnormalized table -> 1NF -> 2NF -> 3NF).

In order to clarify those topics, some external resources are listed and included in this post.



Entity Relationship Diagram:

1. Tameemyousaf's ER-D in simple words and  easy to understand notations:



2. How to Draw an Effective ER diagram by Tech_MX


3. PDF: Weak Entity?


It appears you don't have a PDF plugin for this browser. No biggie... you can click here to download the PDF file.


4. More on ER-D entity types.


http://web.cse.ohio-state.edu/~gurari/course/cse670/cse670Ch2.xht

5. We have a different way of showing cardinality, either using crow's foot or using numbers (1:N)

It appears you don't have a PDF plugin for this browser. No biggie... you can click here to download the PDF file.



I hope students and lecturers alike will find the information above useful.

No comments:

Post a Comment