Details of Assessment
Term and Year Time allowed N/A
Assessment No 1 of 2 Assessment Weighting 50%
Assessment Type Written
Due Date Week 8 Room George St
Details of Subject
Qualification ICT40115 - Certificate IV in Information Technology
Subject Name Systems Analysis
Details of Unit(s) of competency
Unit Code ICTSAD501 Model data objects
ICTSAD502 Model data processes
Details of Student
Student Name
College Student ID
Student Declaration: I declare that the work submitted is my own, and has not been copied or plagiarised from any person or source. Signature: ___________________________
Date: _______/________/_______________
Details of Assessor
Assessor’s Name
Assessment Outcome
Results
0 Competent 0 Not Yet Competent
Marks /50
FEEDBACK TO STUDENT
Progressive feedback to students, identifying gaps in competency and comments on positive improvements:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Student Declaration: I declare that I have been assessed in this unit, and I have been advised of my result. I am also aware of my right to appeal and the reassessment procedure.
Signature: ____________________________
Date: ____/_____/_____ Assessor Declaration: I declare that I have conducted a fair, valid, reliable and flexible assessment with this student, and I have provided appropriate feedback
0 Student did not attend the feedback session.
Feedback provided on assessment.
Signature: ____________________________
Date: ____/_____/_____
Purpose of the Assessment
The purpose of this assessment is to assess the student in the following outcomes: Competent
(C) Not yet Competent
(NYC)
Performance Criteria: ICTSAD501 Model data objects
Element 1. Identify entities and relationships
1.1 Analyse business data to understand operations
1.2 Identify boundaries of the system
1.3 Identify entities, attributes, data types and relationships of data
1.4 Review business rules to determine impact
1.5 Document relationships in an entity relationship diagram
Element 2. Develop normalisation
2.1 Identify suitable business data
2.2 Undertake normalisation of business data and document results
2.3 Compare normalisation results with entity relationship diagram
2.4 Reconcile differences between data
Performance Criteria: ICTSAD502 Model data processes
Element 1. Develop scope of model
1.1 Identify relevant data processes and sources of information
1.2 Identify information gathering method and modelling methodology to be used
1.3 Document modelling information gathered
1.4 Validate modelling information with client
Element 2. Gather process data
2.1 Identify business functions and collect process data using chosen method
2.2 Identify external events, procedures and results
2.3 Identify processes and required decomposition
Assessment/evidence gathering conditions
Each assessment component is recorded as either Competent (C) or Not Yet Competent (NYC). A student can only achieve competence when all assessment components listed under “Purpose of the assessment” section are recorded as competent. Your trainer will give you feedback after the completion of each assessment. A student who is assessed as NYC (Not Yet Competent) is eligible for re-assessment.
Resources required for this assessment
• Computer with relevant software applications and access to internet
• Weekly eLearning notes relevant to the tasks/questions
Instructions for Students
Please read the following instructions carefully
• This assessment has to be completed 1 In class 0 At home
• The assessment is to be completed according to the instructions given by your assessor.
• Feedback on each task will be provided to enable you to determine how your work could be improved. You will be provided with feedback on your work within two weeks of the assessment due date. All other feedback will be provided by the end of the term.
• Should you not answer the questions correctly, you will be given feedback on the results and your gaps in knowledge. You will be given another opportunity to demonstrate your knowledge and skills to be deemed competent for this unit of competency.
• If you are not sure about any aspect of this assessment, please ask for clarification from your assessor.
• Please refer to the College re-assessment for more information (Student handbook).

Assessment – Marking Sheet

TASK DESCRIPTION MARKS
PART A – MODEL DATA OBJECTS
TASK 1: What is a System /4
TASK 2: Important Systems Concept /4
TASK 3; Approaches in Systems Analysis /4
TASK 4: Systems Development Life Cycle /4
TASK 5: Entity Relationship Diagram Concepts /4
TASK 6: ER Diagram and Normalization (1NF) /5
SUB-TOTAL PART A /25

PART B – MODEL DATA PROCESSES
TASK 1: Data Flow Diagram Definitions /5
TASK 2: DFD Rules GUIDELINES /5
TASK 3: Developing DFD - Context Diagram /5
TASK 4: Developing LEVEL-0 DFD /10
SUB-TOTAL PART B /25

TOTAL /50

Assessment - Written Report
Systems Analysis
Assessment 1
Case Study: Norman South lift security company and FASHIONWAVE e-Commerce Retail Company

Table of Contents
PART A: MODEL DATA OBJECTS 6
SYSTEM DEFINATIONS 6
TASK 1: What is a System 6
TASK 2: Important System Concept 7
TASK 3: Approaches in System Analysis 7
TASK 4: Systems Development Life Cycle (SDLC) 8
TASK 5: Entity Relationship (ER) Diagram Concepts 9
Case Study: Norman South lift security company 10
TASK 6: ER Diagram and Normalization (1NF) 11
PART B: MODEL DATA PROCESSES 12
Data Flow Diagram 12
TASK 1: Data Flow Diagram Definitions 12
TASK 2: DFD Rules GUIDELINES 13
Case Study: FASHIONWAVE e-Commerce retail Company 15
TASK 3: Developing DFD - Context Diagram 16
TASK 4: Developing LEVEL-0 DFD 17
Appendix 1: Guidelines for Drawing DFDs 18

PART A: MODEL DATA OBJECTS
SYSTEM DEFINATIONS
In part A, Task 1 to 5 are knowledge written tasks. Task 6 is practical.
TASK 1: What is a System
A system is an interrelated set of components, with an identifiable boundary, working together for some purpose. In IT, systems analysis can include looking at end-user implementation of a software package or product; looking in-depth at source code to define the methodologies used in building software; or taking feasibility studies and other types of research to support the use and production of a software product, among other things.
Systems analysis professionals are often called upon to look critically at systems, and redesign or recommend changes as necessary. Inside and outside of the business world, systems analysts help to evaluate whether a system is viable or efficient within the context of its overall architecture, and help to uncover the options available to the employing business or other party.
In this task, please demonstrate your understand of the definition of SYSTEM in system analysis by describing in brief topics of a SYSTEM in system analysis.
Please note, please do not directly copy and paste from the existing slide and studying resource. Try to understand the concept and knowledge and write or re-write in summary by yourself. Or alternatively you can study, find, describe and referencing to a different version (different in terms of writing to those provided in the existing slide and studying resource).
1. Components
2. Inter-related components
3. Purpose
4. Environment
5. Interfaces
6. Constraints
7. Input
8. Output

TASK 2: Important System Concept
System analysis in software development is important to the successful project development and can be time consuming. Under the circumstances, one goes from an idea to requirements, design, coding, testing, deployment, and then a maintenance phase, through different level of measurement and abstraction.
In this task, please demonstrate your understand of system analysis important concepts by describing in brief the following four levels concepts in system analysis.
Please note, please do not directly copy and paste from the existing slide and studying resource. Try to understand the concept and knowledge and write or re-write in summary by yourself. Or alternatively you can study, find, describe and referencing to a different version (different in terms of writing to those provided in the existing slide and studying resource).
1. Decomposition
2. Modularity
3. Coupling
4. Cohesion
TASK 3: Approaches in System Analysis
The development of a computer-based information system includes a system analysis phase. This helps produce the data model, a precursor to creating or enhancing a database. There are a number of different approaches to system analysis. When a computer-based information system is developed, system analysis might be suitable to adopt certain specific approach.
In this task, please demonstrate your understand of system analysis approaches by describing in brief the following two approaches.
Please note, please do not directly copy and paste from the existing slide and studying resource. Try to understand the concept and knowledge and write or re-write in summary by yourself. Or alternatively you can study, find, describe and referencing to a different version (different in terms of writing to those provided in the existing slide and studying resource).
1 Data Modelling, aka Information Engineering Approach
2 Process Modelling, aka Structured Approach
TASK 4: Systems Development Life Cycle (SDLC)
The systems development life cycle (SDLC), also referred to as the application development life-cycle, is a term used in systems engineering, information systems and software engineering to describe a process for planning, creating, testing, and deploying an information system. The systems development lifecycle concept applies to a range of hardware and software configurations, as a system can be composed of hardware only, software only, or a combination of both
In this task, please demonstrate your understand of system analysis system development life cycle by describing in brief the following two concepts in system analysis.
Please note, please do not directly copy and paste from the existing slide and studying resource. Try to understand the concept and knowledge and write or re-write in summary by yourself. Or alternatively you can study, find, describe and referencing to a different version (different in terms of writing to those provided in the existing slide and studying resource).
1. SDLC
2. System type hierarchies, including sub-types, super-types and root-types
Please provide a SDLC diagram flow chart

TASK 5: Entity Relationship (ER) Diagram Concepts
An entity relationship diagram (also called ER diagram or ERD) shows the relationships of entity sets stored in a database. An entity in this context is a component of data. In other words, ER diagrams illustrate the logical structure of databases.
At first glance an entity relationship diagram looks very much like a flowchart. It is the specialized symbols, and the meanings of those symbols, that make it unique.
In this task, please demonstrate your understand of system analysis ER diagram by describing in brief the following nine aspects.
Please note, please do not directly copy and paste from the existing slide and studying resource. Try to understand the concept and knowledge and write or re-write in summary by yourself. Or alternatively you can study, find, describe and referencing to a different version (different in terms of writing to those provided in the existing slide and studying resource).
1. Entity
2. Attribute
3. Primary Key
4. Foreign Keys
5. Composite keys
6. Relationship
7. Cardinality (Multiplicity)
8. Composite Entity
9. Degree
(a) Binary
i. 1:M
ii. M:N
(b) Unary
i. 1:M
ii. M:N

Case Study: Norman South lift security company
This case study is for Task 6.
Norman South is a specialized server room security company. They are not really a very big company. However due to the fact that they have a key technology patented under their company name, they can outsource and contract many staff members over different cities in different countries for their services there.
At this moment, they are receiving their solutions as product packages. However, they are taking order and selling them by email and post. Your company's task is to help them setting up an eCommerce system in their website, so that the selling can be streamlined and done from online via Internet.
You studied their current traditional way selling recording system in hardcopy and desktop applications in their computer system. You have been able to find and summarize the following as their selling activities.
Part I analysis
• customer (customer_id, name, email_address, postcode, postal_address, phone_number)
• order (order_id, date_of_order, postage, gst, costumer_id, shipping_method_id, payment_method_id, destination, postcode, postal_address, phone_number)
• product (product_id, product_name, description. price, on_hand)
• transaction (transaction_id, costumer_id, product_id, packing_date, shipped_date, arrival_date)
However, according to the staff they will need help with their HR system as well. As this part of the system contains the record of the selling staff over different cities. This part is having a lot of the problems. You studied and found the following record from this part that is having problems.
Part II analysis
sales_staff
staff_id sales_person sales_office office_number customer1 customer2 customerr3
1003 David Smith Chicago 312-555-1212 Ford GM
1004 Jennifer Hugh New York 212-555-1212 Dell Apple HP
1005 Frank Chu Chicago 312-555-1212 Boeing
TASK 6: ER Diagram and Normalization (1NF)
For the Norman South lift security company case study, based on the Part I analysis, please draw a ER diagram of table customer, order, product and transaction. Please note, the ER diagram must be drawn by hand, and scan or take a photo and attached in here as the answer.
For the Norman South lift security company case study, based on the Part II analysis, please do a normalization on at least 1NF level. For assessment 1, you don’t need to do a normalization more than 1NF level. This is because you will do another normalization task which requires you to do a normalization on 2NF/3NF level. For the answer, please list the new tables’ structure, and their ER diagram. For this part, the ER diagram can be drawn both by hand or by a software application.
PART B: MODEL DATA PROCESSES
Data Flow Diagram
In part B, Task 1 and 2 are knowledge written tasks. Task 3 and 4 are practical.
A complete Systems Analysis phrase has these deliverables:
1. Context Data Flow Diagram (DFD)
2. DFDs of current logical system
3. DFDs of new logical system
4. Thorough descriptions of each DFD components
In these process, A data flow diagram (DFD) illustrates how data is processed by a system in terms of inputs and outputs. As its name indicates its focus is on the flow of information, where data comes from, where it goes and how it gets stored.
TASK 1: Data Flow Diagram Definitions
Data flowcharts can range from simple, even hand-drawn process overviews, to in-depth, multi-level DFDs that dig progressively deeper into how the data is handled. They can be used to analyse an existing system or model a new one. Please provide brief definitions of below DFD components.
Please note, please do not directly copy and paste from the existing slide and studying resource. Try to understand the concept and knowledge and write or re-write in summary by yourself. Or alternatively you can study, find, describe and referencing to a different version (different in terms of writing to those provided in the existing slide and studying resource).
1. Data flow
2. Data store
3. Process
4. External Entity
5. Source/sink
TASK 2: DFD Rules GUIDELINES
When creating data flow diagrams (DFD’s), there are certain rules which must be followed. These rules allow for the DFD to be make sense and also to be easily understood. With your class activates and tutorials provided, please complete you DFD rules and guidelines below.
Please note, please do not directly copy and paste from the existing slide and studying resource. Try to understand the concept and knowledge and write or re-write in summary by yourself. Or alternatively you can study, find, describe and referencing to a different version (different in terms of writing to those provided in the existing slide and studying resource).
1. Process
(a)
(b) ..
2. Data Store
(a)
(b) ..
3. Source/ Sink
(a)
(b) ..
4. Data Flow
(a)
(b) ..
5. Other Rules
(a)
(b) ..

Case Study: FASHIONWAVE e-Commerce retail Company
This case study is for Task 3 and 4.
FASHIONWAVE is an e-Commerce retail company. It sells products through the internet. The company needs to record customers, orders, and products. A customer put orders and each order belongs to only one customer. An order may have several transaction items and each transaction item matches a product, though one transaction may contain more than one item of that product. Product information includes description, price, and inventory level. FASHIONWAVE’s web site allows customers to put products into their ’shopping bag.’ When a customer finishes shopping, he will proceed to check out. A customer can update the shopping bag before checking out - changing the quantity or deleting an item. If the customer changes the quantity, the product is still in the shopping bag but if the customer deletes a product, it will be gone from the bag. Please draw DFD for this case. (hint: assume the shopping bag is open and there is no need to retrieve for customer.)
EXAMPLE OF DFD DIAGRAM


TASK 3: Developing DFD - Context Diagram
An overview of an organizational system that shows the system boundaries, external entities that interact with the system, and the major information flows between the external entities and the system. Example DFD in concept is below.
Guidelines are in appendices of this document as well.
Based on FASHIONWAVE e-Commerce retail company case study, please draw your DFD concept diagram for the case study

TASK 4: Developing LEVEL-0 DFD
The first level DFD shows the main processes within the system. Each of these processes can be broken into further processes until you reach pseudo code. Context Diagram. A context diagram is a top level (also known as -Level 0-) data flow diagram. It only contains one process node (-Process 0-) that generalizes the function of the entire system in relationship to external entities.
A DFD that represents a system’s major processes, data flows, and data stores at a higher level of detail. Please refers to the guidelines attached in appendices of this documentation.
Based on FASHIONWAVE e-Commerce retail company case study, please draw Level-0 diagram.

Appendix 1: Guidelines for Drawing DFDs
Example of right and wrong method of DFD