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:

Entity relationship diagram (erd) from tameemyousaf

2. How to Draw an Effective ER diagram by Tech_MX

How to Draw an Effective ER diagram from Tech_MX

3. PDF: Weak Entity?

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)

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

Add Chen Notation for Visio (ERD for System Analysis and Design)

When drawing ERD on MS Visio, you might find that the default ERD shapes provided in Visio is not enough to draw an ERD that shows the relationship, cardinality, and entity attributes.

To solve this, we just have to download and install external 3rd party shapes.

Visio® Stencil Installation Instructions 

To properly install and use a Visio® stencil:

1. Download the stencil, saving with a .vss extension.
   
   Download Chen's ER-D Stencil from the following site:
   http://data.bangtech.com/datamodel/visio_chen_erd.htm

 or from visio cafe:

http://www.visiocafe.com/various.htm


2. Open Microsoft Office® Visio® 2007 document (may be a blank document, or template file).
    
3. Click the File menu.
   
4. Click Shapes.
   
5. Click Open Stencil…
   
6. Find and select the .vss file on your computer and click Open.
   
7. The stencil shapes should now appear on the left side of the workspace.

Enjoy! :)

Systems Analysis and Design for Higher National Diploma

COURSE DESCRIPTION 

This unit introduces students to the different stage of the systems development life cycle and aims to lay the foundation to be successful practitioners in this field. The emphasis of this unit is the systems analysis and systems design phase of the systems development life cycle. This unit provides students with the basic knowledge of systems analysis used for the requirement analysis specification in the development of an information system. The students will learn the skills and techniques needed in the systems analysis with emphasis on the use of a structured approach. This unit also provides students with basic knowledge of the goals and major activities in the systems design phase, systems development phase, and systems implementation phase. Besides structured approach, this unit will introduce students to the basic fundamental knowledge of Object-oriented analysis and design.

AIMS

1. To give an introduction of the different stages involved in the creation of computer-based information systems. 
2. To provide the students with an introduction to the skills and techniques needed in systems analysis. 
3. To develop an awareness of the need for the development of computer information systems. 
4. To provide the student with an introduction of the skills and techniques needed in systems design and implementation with particular emphasis on the use of a structured approach. 
5. To participate in the development of a computer-based information system. 
6. To introduce students to the basic fundamental knowledge of object-oriented analysis and design. 

Download Slides: http://ge.tt/6odEiV62?c



Further Reading:

http://nptel.iitk.ac.in/courses/Webcourse-contents/IISc-BANG/System%20Analysis%20and%20Design/pdf/


Exercises:

http://www.indiabix.com/computer-science/system-analysis-and-design/

http://mcqquestion.blogspot.com/2012/08/system-analysis-and-design.html

http://www.proprofs.com/quiz-school/story.php?title=systems-analysis-design-final-exam-practice