The document discusses rich pictures, which are diagrams used to explore and define complex problems. They help create a shared understanding of a situation by including structures, processes, people, issues, and conflicts. The document provides an example rich picture and guidelines for creating them. It also discusses using six element analysis and entity relationship diagrams to model processes and data for a database system. Preliminary data and process models are created, including entities, attributes, and relationships. Finally, an example SQL query is shown.
The document discusses rich pictures, which are diagrams used to explore and define complex problems. They help create a shared understanding of a situation by including structures, processes, people, issues, and conflicts. The document provides an example rich picture and guidelines for creating them. It also discusses using six element analysis and entity relationship diagrams to model processes and data for a database system. Preliminary data and process models are created, including entities, attributes, and relationships. Finally, an example SQL query is shown.
The document discusses rich pictures, which are diagrams used to explore and define complex problems. They help create a shared understanding of a situation by including structures, processes, people, issues, and conflicts. The document provides an example rich picture and guidelines for creating them. It also discusses using six element analysis and entity relationship diagrams to model processes and data for a database system. Preliminary data and process models are created, including entities, attributes, and relationships. Finally, an example SQL query is shown.
The document discusses rich pictures, which are diagrams used to explore and define complex problems. They help create a shared understanding of a situation by including structures, processes, people, issues, and conflicts. The document provides an example rich picture and guidelines for creating them. It also discusses using six element analysis and entity relationship diagrams to model processes and data for a database system. Preliminary data and process models are created, including entities, attributes, and relationships. Finally, an example SQL query is shown.
Download as PPTX, PDF, TXT or read online from Scribd
Download as pptx, pdf, or txt
You are on page 1/ 19
CSE
Department Computer Science of &Engineering
System Analysis Tools and Techniques
Lecture 03 CSC 401: Database Management System Part 1: Rich Picture Rich pictures provide a mechanism for learning about complex or ill-defined problems by drawing detailed ("rich") representations of them. A Rich Picture is a way to explore, acknowledge and define a situation and express it through diagrams to create a preliminary mental model. A rich picture helps to open discussion and come to a broad, shared understanding of a situation. Rich picture covers Identify the issue you wish to address Develop an unstructured description of the situation
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Rich Pictures The following should be included in the description so that a rich understanding of the situation is developed: Structures Processes Climate People Issues expressed by people Conflict
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Rich picture Example
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Rich Picture Example
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Rich Picture Example
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Rich picture Example
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Rich Pictures guideline Guijt & Woodhill offer the following suggestions for creating a rich picture: 1. Using a large sheet of paper and symbols, pictures and words, draw a "rich picture" (or "mind map") of the situation (project/group) that you wish to evaluate. This is best done with about four to eight people and takes a half to two hours. 2. Start by asking people to note all the physical entities involved, for example, the critical people, organisations or aspects of the landscape. 3. Ask people to present their rich picture by describing the key elements and key linkages between them. 4. If there is more than one group, compare their pictures and cluster the ideas that are similar and those that diverge. In this way you can identify the most important issues to discuss, such as critical topics to focus on in an evaluation, possible indicators or key stakeholders to include in M&E.
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Part 3: Six Element Analysis Processes System Roles Human Non-Comp Computin Software Database Comm. & Hardware g Network Hardware Name of the Manual Non- Computing Any software Any Any process activities computing hardware that are used databases communicati Example: carried out hardware, that are in the used to store on or 1. Registration by each tools that are used in the process. data for this network used for courses stakeholder used to process. Example: process. to complete for the complete this Example: IRAS, ….. Example: the process. process of process. PC ….. IRAS might Example: the system Example: use Oracle to Internet, …. Example: 1. store the Student: Registration data, …. 1. Select form Course …… ……
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Problem Analysis Template
Process Concerns Analysis Proposed
Name Stakeholders (Problems) (Reason of the Solution Problem)
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Entity Relationship Diagram
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Preliminary data model
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Data Attributes for Entities in the Preliminary Data Model
Product Prior Year Sales Goal
Product Current Year Sales Goal
Product Line Prior Year Sales Goal
Product Line Current Year Sales Goal
Order Number of Shipments
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Data model
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group SQL query SELECT Product.ProductID, Product.ProductDescription, Product.PRCurrentYearSalesGoal, (OrderQuantity * ProductPrice) AS SalesToDate FROM Order.OrderLine, Product.ProductLine WHERE Order.OrderNumber = OrderLine.OrderNumber AND Product.ProductID = OrderedProduct.ProductID AND Product.ProductID = ProductLine.ProductID AND Product.ProductLineName = “Home Office”;
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group Thank You
CSE Department Computer Science of &Engineering CSC 401: database Management System Database Group
