ITEC 630: System Analysis, Modeling, and Design-Individual Project Assignment Solution

System analysis

The purpose of the individual system analysis and design project is to demonstrate students’ ability to apply the knowledge learned in this course to a real-world project.

Topics Suggestions

1. The system analysis and design project must be realistic and it will be done using techniques covered in this course. The list of topics suggested for this project is as follows:
2. Ticket purchase system (airline, train, cruise, concert, or others)
3. Internet shopping sites (clothing, shoes, books, music, or others)
4. Local real estate agency system
5. Rental system (car, video, or others)
6. Warehouse management system
7. Student record system
8. Banking system
9. Insurance purchase system (life, medical, homeowner, or others)
10. Credit card management system
11. Library circulation system
12. The above list is meant to be suggestive and if you have an idea about a specific topic, please consult with me early to determine if it is suitable for the course.
13. You are to submit your proposed Individual Project Topic for approval via the Individual Project Topic Proposal assignment link for instructor’s approval by the end of Week 2.

 

Project Deliverables

The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in phase 3, students are required to use the MS Project software for their project schedule.

The deadline for the Individual Project can be found in the schedule section of the class syllabus.

 

You are to submit one file (Microsoft Word) for this assignment.  All diagrams and charts are to be embedded (copied and pasted) into your Microsoft Word file submission for this assignment.  Please make sure they are large enough and legible.  I need to be able to read them. 

The following layout/format including the title page and all three phases are recommended for the project.

Title page (project name, author, and date)

Each item below is to be labeled as below and addressed individually.  No topics are to be combined.

The following layout format covering a title page and all three phases are recommended for the project.

Title page (project name, author, and date)

 

Phase 1: Requirement analysis

1. Problem definition
2. Issues
3. Objectives
4. Requirements
5. Constraints
6. Description of the proposed system
7. Logical model design
   1. Data flow diagrams

• Context diagram (with an accompanying written description).
• Diagram 0 (with an accompanying written description).
  • Diagram 1 (Diagram 1 is optional) (with an accompanying written description).
• Descriptions of processes in each diagram
  2. Descriptions of outputs/inputs/performance/security or controls
  3. Specific requirements, if any (interface, operational, resource, performance, etc.) (You should not ignore any special interface, operational, resource, performance, etc. issues – All are to be addressed here).

 

Phase 2: System and database design

1. User interface

Design an overall user interface consisting of screens, commands, controls, and features to enable users to use the system.  (You are to design the screens that will be used in your project- they are not to be copied and pasted from other sources).

 

Be sure to include a written description for each of the items that corresponds with each screen and the input/output procedures.

1. How data will be input to the system?

• The physical layout for each input
• The input design and procedures
  2. How data will be output from the system?
• The physical layout for each output
• The output design and procedures

1. Data design

Develop a plan for data organization, storage, updating, and retrieval.

1. Database design

• Database tables with their attributes should be presented
• Primary key(s) should be identified in each table, if any
• Three steps of normalization should be included. (You are to show each step of normalization to 3NF – Be sure to identify each step in your normalization process)

2. Entity-relationship diagrams You are to draw an Entity Relationship Diagram (ERD) complete with Crows Foot notation.  Remember that when reading ERDs the Entities and Relationships are read in both directions. Be sure to show the minimum and maximum cardinality for each direction.
3. Data file storage and access
4. System architecture

Determine the architecture of the system as Web-based interface, client/server architecture, Internet/Intranet interface, network configuration, etc.

Phase 3: Project plan

A list of tasks or activities needed for implementing the proposed system

Estimating completion time and costs (cost includes a breakdown of labor, hardware, software, etc.)

A project schedule for performing those activities (Gantt charts or PERT charts)

References are expected and are to be in complete APA format.

Note that there is no other required software package except the MS Project software in this ITEC-630 course. As a result, you are only required to use the MS Project software to handle the scheduling part of the project and for other parts, you can use any word editing software or any drawing tools software.