Systems Analysis & Design

Every lesson in the Systems Analysis & Design slide course, in full text: 2 decks, 132 slides.

• Session 2 - Normalisation, Process Specification and the Design HalfThe follow-up to the orientation session, going down into three things that survey introduced and could not finish, all on the same campus course-registration case study. It derives normalisation from the insert, update and delete anomalies and takes a flat registration table to third normal form step by step, showing that the entity relationship diagram from session 1 follows by rule rather than by taste. It then fills in what a data flow diagram deliberately leaves out - process specifications in structured English, decision tables with their two to the n completeness check, and when to use a decision tree instead. It closes with the design half of the life cycle: logical against physical design, five named interface principles, the four testing levels, and the four conversion strategies plotted against risk and cost with a template for justifying a choice.
• Session 1 - Course Orientation & the SDLCThe kickoff session for a Systems Analysis and Design course, built to run without the student's textbook or syllabus. It teaches the subject against one running case study - a campus course-registration system - covering what an analyst actually produces, the system boundary, the five SDLC phases and their deliverables, waterfall versus agile, functional versus non-functional requirements and how to make a vague wish testable, use cases with alternate flows, data flow diagrams from context through level 0 with the black-hole and flowchart traps, and an entity relationship diagram including the associative entity that resolves a many-to-many. It closes with an eight-step recipe for attacking any assignment in the course. Three open diagnostic slides double as a course intake - textbook, methodology, notation, final project - so the session also plans the ones after it.