unit 6

Q 1. Jesse wants to see a context diagram and a diagram 0 DFD for TIMS. She said to include notes to identify any assumptions or other issues.

Diagram 1: Data Flow Diagram for TIMS System

Sample diagram 0 DFD

Schedule Data

Training Data

Student Data

Q2 Need to review the JAD session summary again! Try to identify four main TIMS functions and draw a lower-level DFD for each process.

Diagram 2: A lower-level DFD process for four main TIMS

Diagram 2 DFD:

Accounting Data

Course Rosters

Diagram 3 DFD:

Training Data

Diagram 4 DFD:

Report Data File

Q 3. Replying to Jesse's message about CASE tools. Search the Internet to find three more alternatives.

Dear Jesse,

Following you the directive to search the internet for two other alternative CASE tools for likely examination, I found DB-MAIN and MS SQL Maestro. DB-MAIN is dedicated to Database Application Engineering with the newest version being 8.2. The case tool is able to correct group and entity type erasure in an extended textual view, correct stable property selection in an attribute dialogue box, and improve extractors (SQL, IDS, IMS, and COBOL). MS SQL Maestro has the important functionalities of enabling the extraction, creation, copying and dropping database objects. The tool would probably be of use in creating databases as ER diagram, visually constructing queries, importing and exporting data from popular file formats, and managing SQL server.

I also came across a version of Popkin System Architect 9.2 that concentrates on visualization and publishing part of enterprise architectures. The system has functional options for automating business-case reporting equalling to the Federal Enterprise Architecture reference model. Also, Visible Analyst 2008 has new features of strategic planning, data modelling, business process modelling, UML modelling and structured analysis and design modelling offered as a single tool.

Demonstrations of the latest versions and features are available through sales departments of the product companies. Thanks in advance.

Best Regards,

Phillip Wilson

Q 4. Prepare a decision table and a decision tree that show the logical rules described in Jesse's message about fees and discounts. Include an explanation of how you created the decision table and decision tree.

RULES	1	2	3	4	5	6
Multiple Courses?	Y	Y	Y	Y	N	N
Employed by SCR client?	Y	Y	N	N	Y	Y
Client service rep waiver?	Y	N	Y	N	Y	N
Eligible for discount A	X	X	X	X
Eligible for discount B	X	X	X		X	X
Not eligible for discounts
RULES	1	2	3	4	5	6
Multiple Courses?	Y	Y	Y	N	N	N
Employed by SCR client?	Y	N	N	Y	N	N
Client service rep waiver?	-	Y	N	-	Y	N
Eligible for discount A	X	X	X
Eligible for discount B	X	X.		X	X
Not eligible for discounts						X

Course Data

Course

Instructor

Courses

Accounting System

Accounting Data

Training Administrator

Corporate Client

Training Reports

Training Summary

Course Request & Payment

TIMS System

Training Report

Training Administrator

Student

Course

Produce Reports

Accounting Data

Register Students

Payment

Invoice

Course Request

Confirmation

Schedule Data

Roster

Registration Data

Training Data

Training Summary

Corporate Client

Register Students

Student Data

Training Data

Training Data

Completion Data

Maintain Training Records

Instructor

Course Assignments

Current Schedule

Manage Course Scheduling

Course Data

Schedule Decisions

Course History

Instructor Data

Analyze Instructor Availability

Course History

Instructor Needs

Course Assignment

Analyze Schedule Demand

Schedule Decisions

Course Data

Course Data

Training Data

Create Schedule

Schedule Data

Current Schedule

Instructor Data

Process Course Request

Course Request

Confirmation

Invoice

Invoice and Payments

Schedule Data

Payment

Registration Data

Registration Data

Invoice and Payment

Student status

Registration Data

Update Registration Data

Invoice and Payment Data

Prepare Accounting Data

Registration Data

Create Course Rosters

Accounting Data

Roster

Course Roster Data

Update Training Data

Completion Data

Training Data

Training Data

Training Data

Update Student Data

Training Data

Student Data

Student Data

Training Summary Data

Produce Training Summary

Training Summary

Report Data

Report Data

Training Report Data

Training Reports

Produce Training Report

Eligible for discount A and B

Yes

Employed by SCR client?

Eligible for discount A and B

Yes

Yes

Client Service rep override?

N0

No

Eligible for discount A

Multiple Courses

Client Service rep override?

Employed by SCR client?

Eligible for discount B

Eligible for discount B

Not eligible for discounts

No

Yes

No

Yes

No