Tools for describing Design Part 1
Duration: 13 min
This video lesson is available to enrolled students.
Inside: a video lesson and guided study material.
Module outline
- About Course: About the Course
- CS | 01 | Digital Logic and Circuits and Discrete Mathematical Structures: Digital Systems & Boolean Basics, Number System, Number Representation, Logic Gates & Hardware, Boolean Expression, Boolean Minimization, Combinational Circuit, Sequential Circuits, Set Theory, Relations, Functions, Graph Theory, Group Theory, Propositional and Predicate Logic, Permutation and Combination / क्रमचय और संचय
- CS | 02 | Computer Organization and Architecture: Basics of COA, Cache Memory Organization, Input Output Organisation, Pipelining, Instr Formats & Modes, Control Unit Design, Multiprocessors
- CS | 03 | Data Structures and Algorithm: Introduction to DS, Array, Stack, Queue, Linked List, Tree, Graphs, Hashing, Algorithm Analysis, Time Complexity Analysis, Sorting Algorithms, Greedy Algorithms, Dynamic Programming, Minimum Spanning Trees, Shortest Path Algos, Complexity Theory, Advanced Algorithms
- CS | 04 | Problem Solving through C Programming: C Fundamentals, Control Flow, Functions, Arrays & Pointers, Storage Classes, Structures & Enums, DMA, Macros, Scoping & File Handling
- CS | 05 | Object Oriented Techniques: Object Oriented Technology, Java
- CS | 06 | Operating System: Introduction to OS, Process Management, CPU Scheduling, Process Synchronization, Threads & Process Creation, Deadlock, Memory Management, Virtual Memory, Disc Scheduling, File Management, Windows OS, Unix OS
- CS | 07 | Database Management Systems: Basics of DBMS, ER Diagram, Relational Model & Functional Dependencies, Keys & Integrity Constraints, Normalization (1NF - BCNF), Decomposition Properties & 4NF, Relational Algebra, SQL, Relational Calculus, Transaction Management, Concurrency Control, Database Recovery, Database Security & Authorization, Query Processing & Optimization, File Organization & Indexing
- CS | 08 | Computer Networks: Introduction to CN, Data Communication, DLL: Access Control, DLL: Flow Control, DLL: Error Control, DLL: Framing, Data Link Layer - Ethernet, Net Layer: IPv4 & Proto, Net Layer: IP Addressing, Net Layer:Routing Protocol, Transport Layer Services, TL: Congestion & UDP, Application Layer, Hardware basics
- CS | 09 | Software Engineering: Fundamentals of Software Engineering, Software Requirements and Quality Assurance, Software Design, Estimation and Metrics, Software Testing, Software Maintenance and Configuration Management
- CS | 10 | Internet Technology, Web Design and Web Technology: Internet Fundamentals, Web Design & Development, Protocols & Services, Web Publishing & Hosting, Server Side & Security, Emerging Technologies, JavaScript-Basics, HTML Basics
- CS | 11 | System Analysis And Design: Fundamentals of Systems and Information Systems, SDLC and Development Approaches, Software Documentation and Software Requirements Specification (SRS), SDD and Quality Assurance, Security, Risk Management & Maintenance
- CS | 12 | Information Security and Cyber Laws: Cyber Threats and Malware Attacks, Role of Internet and Web Services, Security in Mobile and Wireless Computing, Electronic Data Interchange and E-Commerce, Physical Security and Cryptography Basics, Intrusion Detection Systems (IDS), Cyber Safety and Security
- CS | 13 | Computer Graphics: Basics of Computer Graphics, 2-D Geometrical Transforms and Viewing, 3-D Object Representation, Geometric Transformations and Viewing
- GS Paper | 01 | Indian and World Geography / भारत एवं विश्व का भूगोल: Geography / भूगोल
- GS Paper | 02 | History / इतिहास: History / इतिहास
- GS Paper | 03 | Indian Economy & Social Development / भारतीय अर्थव्यवस्था एवं सामाजिक विकास: Indian Economy / भारतीय अर्थव्यवस्था
- GS Paper | 04 | General Science / सामान्य विज्ञान: Biology / जीव विज्ञान, Chemistry / रसायन विज्ञान, Scientific Achievements and Research / वैज्ञानिक उपलब्धियाँ और अनुसंधान
- GS Paper | 05 | Elementary Maths / प्रारंभिक गणित: Number System / संख्या पद्धति, Divisibility Rules / विभाज्यता के नियम, HCF and LCM / महत्तम समापवर्तक और लघुत्तम समापवर्त्य, Percentage / प्रतिशत, Profit, Loss and Discount / लाभ, हानि और बट्टा, Simple and Compound Interest / साधारण और चक्रवृद्धि ब्याज, Ratio and Proportion / अनुपात और समानुपात, Average / औसत, Time and Work / समय और कार्य, Time, Speed and Distance / समय, चाल और दूरी, Algebra / बीजगणित, Solid Mensuration / घन क्षेत्रमिति, Data Interpretation / आँकड़ा निर्वचन, Arithmetic / अंकगणित, Statistics / सांख्यिकी, Probability / प्रायिकता, Sequences, Series and Combinatorics / अनुक्रम, श्रेणी और संयोजन, Mixture and Alligation / मिश्रण और एलिगेशन, Calculus / कलन, Trigonometry / त्रिकोणमिति, Vectors / सदिश, Number Systems and Number Theory / संख्या पद्धति और संख्या सिद्धांत, Euclidean Geometry and Mensuration / यूक्लिडीय ज्यामिति और क्षेत्रमिति, Statistics and Probability / सांख्यिकी और प्रायिकता, Coordinate Geometry, Vectors and 3D Geometry / निर्देशांक ज्यामिति, सदिश और त्रिविमीय ज्यामिति, Polynomials, Equations and Complex Numbers / बहुपद, समीकरण और सम्मिश्र संख्याएँ, Plane Mensuration / समतल क्षेत्रमिति, Simplification, Indices and Surds / सरलीकरण, घातांक और करणी, Sets, Relations, Functions and Discrete Mathematics / समुच्चय, संबंध, फलन और विविक्त गणित
- GS Paper | 06 | Indian Polity and Governance / भारतीय राजव्यवस्था एवं शासन: Polity / राजव्यवस्था
- GS Paper | 07 | Current Events / समसामयिक घटनाएँ: Current Affairs / समसामयिकी
- UPLT Live Classes Notes: UPLT Live Classes
- UPLT Full Mock Tests Tier 1:
- UPLT Full Mock Tests Tier 2:
AI summary & chapters
AI Summary
An AI-generated summary of this video lecture.
This video lecture, titled 'SAD final notes.pdf', focuses on 'Tools for describing design' within the context of System Analysis and Design. The instructor systematically introduces various artifacts used to document system specifications, moving from data-centric tools like data dictionaries to structural representations like database schemas and decision-making aids. The session covers the definition and components of data dictionaries, the graphical nature of database schemas and E-R models, security models involving the CIA triad, and the use of trade-off matrices and decision tables for logical design. The instructor actively annotates the PDF with red handwriting to emphasize key concepts, contrasting complex tools with easier diagrams and providing concrete examples like 'stu-id' and entity relationships.
Chapters
0:00 – 2:00 00:00-02:00
The video begins with the section 'Tools for describing design', stating that 'Various tools are used to describe the higher level and lower level aspects of system design'. The instructor writes 'Tools -> Complex' and 'Diagram/Story -> Easy' to contrast representation methods. She highlights that these tools are used in the 'System Design Specification to describe various aspects of the design'. The first tool introduced is the 'Data dictionary', which is underlined on the screen. Above the text, red handwriting notes 'Overall structure', 'codes', and 'Exactly what code will do?', indicating a transition from high-level design to coding specifics.
2:00 – 5:00 02:00-05:00
The lecture defines the 'Data dictionary' as the 'Definition of all of the data and control elements used in the software product or subsystem'. The instructor annotates the screen with specific components: 'Name - Alias', 'stu-id -> 901', 'Format', 'Additional info -> default, init', and 'Constraint'. She explains that a complete definition of each data item and its synonyms are included. The text notes that a data dictionary may consist of 'description of data elements and definitions of tables'. The instructor writes 'Data Dictionary -> Data ambiguity' and 'program', emphasizing its role in clarifying data usage.
5:00 – 10:00 05:00-10:00
The content moves to 'Table definitions' and 'Database schema'. The schema is defined as a 'graphical presentation of the whole database' where 'Data retrieval is made possible by connecting various tables through keys'. The instructor draws a table with columns 'Std', 'Name', 'Degree' and writes 'DBMS'. She then introduces the 'E-R model' (Entity-relationship model), drawing a diagram with entities 'Student', 'Enroll', and 'Course' to show relationships. The text states the E-R model 'forms basis for database design'. The instructor writes 'primary key & foreign key' and 'Entity' to highlight key concepts in the schema.
10:00 – 12:56 10:00-12:56
The final segment covers the 'Security model', which 'associates users, groups of users, applications with database access rights'. The instructor writes 'CIA' (Confidentiality, Integrity, Availability) and draws a box labeled 'Data'. The lecture concludes with 'Trade-off matrix' and 'Decision table'. A decision table is described as showing 'the way the system handles input conditions and subsequent actions on the event'. The instructor draws a table with four quadrants: 'Input Conditions', 'Condition Alternatives', 'Actions', and 'Subsequent action Entries', filling it with values like 'High', 'Low', 'Med'. The text notes a trade-off matrix is used to 'describe decision criteria and relative importance of each decision criterion'.
This lecture provides a structured overview of documentation tools for System Analysis and Design. It begins by categorizing tools based on complexity, then details the Data Dictionary as a repository for data definitions including aliases and constraints. The lesson transitions to structural design with Database Schemas and E-R models, emphasizing graphical representation and key relationships. Finally, it addresses logical design and security through Security Models (CIA triad) and Decision Tables, which map input conditions to actions. This progression covers the full spectrum from data definition to logical decision-making in system specification, ensuring students understand the hierarchy of design artifacts.