Systems Analysis and Design - CIS54

The information at this site is in draft form and is the property of Priscilla Grocer. The information may not be duplicated or distributed without her permission. ©Copyright 2001

Category Information
Introduction
Syllabus
Introduction to CIS54 - methods, expectations etc.
Syllabus for CIS54
Resources Notes and handouts for CIS54
PowerPoint presentations
Chat Room
Board Room
Samples for CIS54
Work Weekly schedule for CIS54
Projects for CIS54
Test information for CIS54
System Links Links to the Internet

Back to the Top

Notes and handouts Link to retrieve
BCC lab handout BCC Lab instructions to log in and use software
Notes on analysis and design Notes on systems
Design notes
File types
Notes on data dictionaries
Software demos/shareware Information on software demos for this course
Normalization - Relational Database Introduction to third normal form
Contribution system notes
Student data system notes
Notes on basic order entry
Payroll data notes
Medical clinic notes
Text book notes
SQL SQL from Access
Generic notes on SQL
Notes on Access Intro to Access
Intro to Relationships
More on relations and queries
Information on filters
Report writing
Introduction to forms
More information on forms
Data properties
Update queries
Introduction to VB Access
Continuation of VB Access Introduction
If statements in VB Access
More on IF with nesting
Loops in VBAccess
Call and pass in VBAccess
Tools Decision Table notes
Decision Table examples
CPM Notes
Business systems - notes for discussion Notes on payroll
Notes on accounts receivable
Overview notes - order
Notes on accounts payable
Notes on inventory
General ledger notes
Sample General Ledger set up using MYOB

Back to the Top


Powerpoint presentations of material. These presentations can be opened or downloaded for future viewing. Free viewer for PowerPoint
NOTE: Students are reporting more success using Netscape for these presentations.
Apparently the speaker notes are a problem with the downloaded viewer. I will make copies of the speaker notes and store them in word documents.
Presentations Link to retrieve
Relational Database Normalization - information on third normal form
      Separate speaker notes to accompany normalization presentation
Relational database using donor
      Separate speaker notes to accompany relational databse using donors presentation
Relational Database Student System
      Separate speaker notes to accompany relational database student system presentation
Relational database order system example
      Separate speaker notes to accompany relational database order system example
DFD and Systems Flowchart DFD for parts of order system
Examples of systems flowcharts
    Separate speaker notes to accompany examples of systems flowcharts

Back to the Top

Sample projects etc. Link to retrieve

Back to the Top

Projects Link to retrieve

Back to the Top

Final Information Link to retrieve
Final exam and status sheet The final exam is due on Thursday, May10th at 4:00. It must be passed in with a status sheet.
Final Exam
Required status sheet

Links to the web Link to retrieve
Relational databases Relational database info link
Relational database info link
Relational example with explanation
Explanation of normalization - looks fairly straight forward
Article on Codd and relational databases, normalization etc.
Part II of the article above
Slide show on normalization etc.
Explanation of normalization etc.
Relational model - Codd
Second part
Third part
Lots of information on normalization and related concepts
One more...
Developing a relational database
Access Tutorials and References A Tutorial on Databases Using Access 97
Access tutorial
Access tutorial
MS-Access 97 Tutorial Part I
MS-Access 97 Tutorial Part II
MS-Access 97 Tutorial Part III
Tutorial on Access
Database Tutorial
MOUS Access Expert Level specifications
SQL Tutorials and References SQL tutorial
SQL tutorial
List of SQL Tutorials
Powerpoint Tutorials and References PowerPoint tutorial
PowerPoint tutorial
CPM/PERT Charts PERT Information
Decision Tables Decision Table explanation
Very basic explanation of decision tables
Program that converts decision tables to COBOL
Data Flow Diagrams etc. Interesting real example
Library project
Information on Documentation
Notes on DFD
Misc. systems info
Example - registration
Short example of DFD
Another example
Notes/suggestion
Tools for Systems Analysis Visible Analyst Demo
If you took the Oracle course, you have the demo version of Designer. A tutorial to use with this product is:
Designer Tutorial
Another Oracle Designer tutorial can be found at:
Another Designer Tutorial
Drawing package - DFD, flowcharts etc.
Nassi-ShneidermanDiagrams
Another Nassi-Shneiderman Diagram site
Information on Warnier-Orr Diagrams
e-commerce Information on e-commerce

Send e-mail to Mrs. Grocer:

pgrocer@bristol.mass.edu

Back to the Top
Return to home page
Return to previous page