CS360 Analysis, Modeling & Design

Instructor: Dr. Donald R. Chand (pronounced Chund) Phone: (781)891-2925

Office: 119 Morison Bldg. Fax : (781) 891-2949

Office Hours: M-TH 1:00 - 4:00 PM email:dChand@lnmta.bentley.edu

Class Time: Wed. 6:00-9:00 PM Location: J 310

Course Prerequisites: CS 230

Course Objectives:

  1. Develop competence in modeling tools / techniques used in systems analysis and design
  1. Experience the process of discovering and documenting information systems requirements
Texts:

David Harris, Systems Analysis and Design, The Dryden Press, 1995

Donald Chand, Esential Data Modeling Hand-out

Course Requirements:

  1. Homework Assignments
  1. In-class exams
Course Structure:
 
Data Modeling Process Modeling Sys. Anal. & Desgn. Process
E-R Modeling Current System Modeling Sys. Dev. Life cycles
Relational Modeling Proposed System Modeling Requirements Modeling
     
Schedule:
 
Task
Due Date
Grade Value
Systems Analyst Paper
June 3
5%
Skeletal ER- Model
June 10
5%
Relational Model
June 17
10%
Full ER- Model
June 24
10%
Mid -term Exam
July 1
20 %
Current System Model
July 8
10%
Proposed System Model
July 15
10%
Full Process Model
July 22
10%
Final Exam
July 29
20%
 
 
 
Class Plan
 
 
Date
Class Plan
To do for Class
May 27
30 mts: Course Requirements
70 mts: What is systems analysis?
20 mts: Break
40 mts: What is data modeling?
 Read Harris Chap. 2 & 3; 

Read Chand Modules 1 & 3;
June 03
40 mts: Homework Review
60 mts: Entities, Cardinality & Participation
20 mts: Break
60 mts: Building a Skeletal ER model
 Read Harris Chap. 5 pp.103-111; 

Read Chand Modules 4 - 8. 

Submit Assignement #1
June 10
40 mts: Homework Review
60 mts: Attributes and ERA model
20 mts: Break
60 mts: Relational model, 1NF, 2NF, 3NF
 Read Harris Chap. 5 pp.111-125; 

Read Chand Modules 9 -14. 

Submit Assignement #2
June 17
40 mts: Homework Review
60 mts: Boyce-Codd, 4NF, 5NF
20 mts: Break
60 mts: A method for modeling relations
 Read Chand Modules 15-18. 

Submit Assignement #3
June 24
40 mts: Homework Review
60 mts: Normalizing an ER model 
20 mts: Break
60 mts: Synchronizing Keys
 Read Chand Modules 15-18. 

Submit Assignement #4
July 01
90 mts: Mid-term Exam
20 mts: Break
60 mts: Current systems modeling
 Read Harris Chap. 4 pp.70-75; 

Read Chand's Hand-out
July 08
40 mts: Homework Review
60 mts: Proposed System Modeling 
20 mts: Break
60 mts: Event Modeling
 Read Harris Chap. 4 pp.76-93; 

Read Chand's Hand-out 

Submit Assignement #5
July 15
40 mts: Homework Review
60 mts: Full Process Model
20 mts: Break
60 mts: Model Balancing
 Read Chand's Hand-out 

Submit Assignement #6
July 22
40 mts: Homework Review
60 mts: Describing Logic -- Structured English 
20 mts: Break
60 mts: : Describing Logic -- Decision Tables
 Read Chand's Hand-out 

Submit Assignement #7
July 29
40 mts: Course Review & SET
20 mts: Break
90 mts: Final Exam