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 2000

Category	Information
Syllabus	Syllabus for CIS54
Resources	Notes and handouts for CIS54 Chat Room Board Room Sample projects for CIS54
Work	Reading for CIS54 Assignments 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
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 PERT Chart Information 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

Sample projects etc.	Link to retrieve

Back to the Top

Assigned reading	Link to retrieve
Text	Chapters: #1, #2, #3, #4, #5, #6, #7, #8, #9, #10, #11, #12, Tools Check the author's Web site - some interesting links
Handouts and articles on Web	Read information on relational databases and third normal form. Start reviewing information about Access that was covered in CIS11.

Back to the Top

Assignments	Link to retrieve
Relational	Assignment to develop a relational database in third normal form for a used car lot
Access	First access assignment - review basics Second access assignment - relations & queries Access assignment on forms, data, and reports Do something with VB in Access - minimum of IF, calc and several events. Can use an existing database!
Analysis and Design	PowerPoint assignment on Chapters #1-#5
Business packages	MYOB Assignment Pick a second business package from the list that I gave you and analyze its use in a small business environment. Can do payroll, inventory, another complete business package - your choice!
Misc. Assignments	Project scheduling assignment (PERT/CPM) Note: I will be in on Saturday from 10:00 until 4:00 for help on assignments.

Back to the Top

Projects	Link to retrieve
Research on e-commerce	Reseach paper on e-commerce
Bristol Dairy	Initial specifications on Bristol Dairy Routing software etc for beverage industry including dairy Managing the Dairy farm more than selling, but interesting Site containing information about costing in the dairy industry Dairy management

Back to the Top

Quiz and Exam Information	Link to retrieve
Final Exam	Your final exam will consist of 10 questions taken from this list. Review Questions for the Final Exam Status sheet - must be passed in at final! Status Sheet for CIS54 It has been fun - you are a great group to work with!

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