IS422 Topics

IS422 - Systems Analysis & Design Resources

    ~Download / Install

  • Draw.io

    A free online diagramming software alternative to Microsoft Visio for building UML, E-R, and network diagrams, as well as process and organizational charts.

  • Heidi SQL Database Client: Download

    An alternative (and very portable) database client for runing SQL queries and perform many administrative tasks on MySQL, SQL Server, and SQLite databases. Download and extract the Portable version.

  • Microsoft Project 2021: Download & Install

    Download the Microsoft Project Professional 2021 installer from Azure Dev Tools for Teaching (login required). Don't forget to copy the Product Key!

  • Microsoft Project 2021: Register

    Walks you through registering your copy of Microsoft Project Professional 2021. Be sure to have your Product Key handy!

  • SQLite: Download

    Download page for the SQLite embedded SQL database engine, one of the most popular DBMS in the world. Windows users: download and unzipping the 64-bit DLL is highly recommended, but the 32-bit SQLite Tools bundle is also a good choice.

  • Visio 2019: Download & Install

    Download the Visio Professional 2019 64-bit installer from Azure Dev Tools for Teaching (login required). Don't forget to copy the Product Key!

  • Visio 2019: Register

    Walks you through registering your copy of Visio Professional 2019. Be sure to have your Product Key handy!

    • ~Tutorials

  • Microsoft Project: Create a New Project Plan

    Tutorial from Tutorialspoint that shows you how to set up a basic project plan with Microsoft Project. Covers configuring the work calendar, adding tasks, creating summary tasks, and linking tasks. Note: the tutorial uses Project 2013, but the same instructions apply to Project 2016.

  • Microsoft Project: Resources to Task

    Tutorial from Tutorialspoint that shows you how to add resources to a task in Microsoft Project, assuming you've already set up the resource. Note: the tutorial uses Project 2013, but the same instructions apply to Project 2016.

  • Microsoft Project: Set Up Resources

    Tutorial from Tutorialspoint that shows you how to add resources (people, equipment, etc.) to a project in Microsoft Project. Note: the tutorial uses Project 2013, but the same instructions apply to Project 2016.

    • Analysis & Design

  • Entity-Relationship (ER) Diagram Tutorial

    Tutorial that describes how to create an entity-relationship (ER) diagram to design a database. Describes the components of an ER diagram, as well as the symbols for different notation schemes. Provides a full example in crow's feet notation.

  • Entity-Relationship Diagrams (Visual Paradigm)

    Tutorial on entity-relationship (ER) diagrams using crow's foot notation to design a relational database schema. Walks through the entire design process - from listing entities in the Requirements stage to building the logical and physical models.

  • System Use Cases: an Agile Introduction

    Discusses and presents both informal and formal system uses cases used in agile projects.

  • UML 2 Class Diagrams: an Agile Introduction

    Presents the first few iterations of a class diagram for a university enrollment system. Good example that not only uses simple, standard UML syntax, but also discusses the importance of developing diagrams iteratively.

    • Databases

  • Azure: Controlling and Granting SQL Database Access

    Discusses how to give people and applications access to your Azure SQL database, including the use of administrative accounts, groups and roles, server logins, and database users . Also discusses (with examples) how to grant limited user permissions using built-in stored procedures, as well as security policies and restrictions that govern which users can perform sensitive operations.

  • Creating SQL Logins and SQL Users on your Azure SQL Database

    MSDN blog post tutorial on how to create logins and users for an Azure SQL Server and Database. Also shows you how to assign specific database roles to users. NOTE: the tutorial was written for an Azure database, but the same SQL commands, roles, and stored procedures apply to local SQL Server databases, as well.

  • Securing Your Azure SQL Database

    Tutorial on securing your Azure SQL database at different levels: firewall settings; secure connection strings; user management; encrypting connections; and auditing database activity.