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 2002

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

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