Unit 7, Systems Analysis and Design
7.7 System Design
This lesson covers the logical design phase of the proposed system within the System Development Life Cycle (SDLC). It details logical data flow modeling, logical data structures, the transition from logical representations to relational databases, and the implementation of a physical database design using tools like pseudo-code and data dictionaries.
ප්රධාන සංකල්ප
- Logical Design (තාර්කික නිර්මාණය)
- The phase of systems design that focuses on the conceptual and logical representation of data flows, data structures, and processes, independent of physical hardware or implementation constraints.
- Logical Data Flow Modeling (තාර්කික දත්ත ගැලීම් ආදර්ශකරණය)
- A modeling technique using Data Flow Diagrams (DFDs) and textual descriptions to illustrate how data is processed and stored in the proposed system, omitting physical constraints and human factors.
- Logical Data Structure (තාර්කික දත්ත ව්යුහය)
- An abstract representation of data entities and their relationships, updated during the logical design stage to support new system functionalities and eliminate temporary data stores.
- Elementary Process Description (මූලික ක්රියාවලි විස්තරය / EPD)
- A detailed explanation of the fundamental, indivisible processes of a system, often written using pseudo-code to define how inputs are transformed into outputs.
- Context Diagram (සන්දර්භ රූප සටහන)
- A top-level data flow diagram that defines the boundary of the proposed system, showing its interactions with external entities.
- Data Dictionary (දත්ත ශබ්දකෝෂය)
- A centralized repository containing metadata (data about data) that describes the database structures, tables, fields, and constraints, used by Database Management Systems (DBMS).
- Logical to Relational Mapping (තාර්කික නිරූපණය සබැඳි නිරූපණයට අනුරූපණය)
- The process of translating logical design components (Entities, Attributes, Instances, and Unique Attributes) into relational database structures (Tables, Fields, Records, and Primary Keys).
MCQ කට්ටල
MCQ 12විභාගයේදී
- Differentiating between Physical DFM and Logical DFM
- Mapping logical entities, attributes, and instances to physical relational database tables, fields, and records
- Explaining the role and importance of the Data Dictionary and Meta Data
- Writing Elementary Process Descriptions (EPD) using pseudo-code
- Explaining 3rd Normal Form (3NF) optimization steps in physical design
