M7 - SQL and BPMN Activity Models Quiz

Data Extraction, Integration, and Process Documentation

• Structured Query Language (SQL): Computer language for interacting with relational databases (tables, records, attributes).
• SQL Commands:
  • SELECT: Specifies attributes to view (e.g., SELECT * for all attributes).
  • FROM: Specifies table containing attributes.
  • JOIN: Combines data from multiple tables.
    • INNER JOIN: Retrieves matching data.
    • LEFT JOIN: Retrieves data from the left table, even if no match exists in the right table.
  • WHERE: Filters results based on conditions (e.g., WHERE Sales_Price > 10).
  • HAVING: Filters aggregated data (e.g., HAVING SUM(Quantity_Sold) > 200).
  • GROUP BY: Aggregates data into subtotals based on categories (e.g., GROUP BY Customer_ID).
• Database Elements: References to table names, attribute names, or criteria.

BPMN Activity Models

• Standardized tool: For depicting business processes using symbols and rules.
• Flow Activities: Processes within an organization.
• Pools: Represent organizations involved in a process.
• Swim Lanes: Subdivide pools to indicate segregation of duties.
• Events: Points of change in the process.
  • Start Events: Indicate the start of a process (thin circle).
  • Intermediate Events: Indicate changes within a process (double-lined circle).
  • End Events: Represent the completion of a process (thickened circle).
• Tasks: Actions in a process (rectangle with rounded corners).
• Flows:
  • Sequence Flows: Connect objects within a pool (smooth-lined arrows).
  • Message Flows: Represent communication between different pools (dotted lines).
• Gateways: Represent decisions within a process (diamond shape).

Data Flow Diagrams

• Standardized: For representing business processes at a granular level.
• Logical Flow: Represents the process without specific details.
• Components:
  • Processes: Actions that result in data transformation (circle or rectangle).
  • Data Flows: Arrows representing data movement.
  • Data Stores/Warehouses: Open-ended rectangles representing data storage.
  • External Entities: Squares representing external parties interacting with the system.

Flowcharts

• Representation: Logical and physical flow of documents & information through a process.

System Interface Diagram

• Interaction: Shows how internal and external users interact with systems.
• Display: Logical and physical flow interface for both systems internally and externally.

Test your knowledge of SQL commands and BPMN activity models. This quiz covers key concepts, including data extraction and integration processes. Prepare to assess your understanding of how to manipulate and visualize business processes effectively.