1/23
Comprehensive flashcards covering Introduction to ICT, Programming Constructs, Modular Code Architecture in Python, and Database Systems from PNEC lecture series.
What is the definition of Information and Communication Technologies (ICT)?
ICT encompasses technologies used for managing, processing, and communicating information, or all technologies used for communication, data processing, and information management.
What are the three distinct categories of ICT defined in the lecture?
Information Technology (hardware, software, and systems for computing), Communication Technology (tools and systems for transmitting data), and Broadcasting Technology (systems for transmitting audio and visual content to the public).
What are the four primary components of ICT?
Hardware (physical devices for computing and communication), Software (enables tasks and data management), Networks (connects devices and allows data exchange), and Data (stores and manages accessible information).
What is the Digital Divide as an ICT challenge?
The disparity between those who have access to ICT and those who do not, which exacerbates social and economic inequalities and limits opportunities for disadvantaged groups.
What are three key applications of ICT in healthcare?
Telemedicine (remote consultations, diagnosis, and monitoring), Electronic Health Records (EHR, digitalization of patient data), and Wearable Devices (health monitoring via smartwatches such as Fitbit and Apple Watch).
What are two sustainable solutions associated with Green ICT?
E-waste Management (recycling and responsibly disposing of electronics) and Energy-Efficient Hardware (using low-power consumption devices).
How is programming defined in the lecture?
The process of creating a set of instructions to instruct a computer to perform a task, involving code, logic, and algorithms.
What is the difference between high-level and low-level programming languages?
High-level languages are closer to human languages (such as Python, Java, C++, and C#), whereas low-level languages are closer to machine code (such as Assembly and Fortran).
What are the five steps of problem-solving in programming?
What is a variable in programming and where is it stored?
A variable is a container that holds data that can be modified, and it is stored in Random Access Memory (RAM) with a variable name and an assigned value.
How are Python Modules, Packages, and Libraries differentiated by scope and structure?
A Module is a single source file (filename.py) with Single Namespace scope; a Package is a directory of sub-modules with an init.py marker with Hierarchical Namespace scope; and a Library is a high-level collection of related packages (pyproject.toml) with Multi-Package Ecosystem scope.
What quantitative benefits does modular programming provide in terms of reusability, bug localization, and execution speedup?
It delivers 65% code reusability by cutting enterprise duplication, 3.5× faster bug localization through isolated unit boundaries, and up to 50× execution speedup by leveraging C-compiled native binaries.
What are the three Python import syntax patterns and their specific mechanisms?
Full Module Import (import math) for explicit namespace access to prevent identifier collisions; Selective Import (from math import sqrt, pi) for direct binding into local scope; and Alias Binding (import numpy as np) for shortened prefix identifiers.
What is the exact resolution order of the Python module search path (sys.path)?
STEP 01: Current Script Directory; STEP 02: PYTHONPATH Directories; STEP 03: Standard Library Directory; STEP 04: site-packages Directory.
What CLI commands are used in the three-step virtual environment (venv) workflow?
STEP 01 (Create Isolated Env): python3 -m venv .venv; STEP 02 (Activate Context): source .venv/bin/activate; STEP 03 (Lock Dependencies): pip freeze > requirements.txt.
What is the purpose of the Python main execution guard pattern: if name == 'main':?
It ensures that top-level entry point logic runs only when executed directly from the CLI and prevents script auto-execution upon module import.
How does a database differ from a standard file system?
A file system stores files in directories, has limited ability to handle large data volumes, and is prone to redundancy; a database is structured, optimized for large datasets, minimizes redundancy, and supports complex queries.
What are the four primary types of databases described in the lecture?
Relational Databases (RDBMS such as MySQL, PostgreSQL, SQL Server), NoSQL Databases (such as MongoDB, Cassandra, Redis), Cloud Databases (such as AWS RDS, Google Cloud Firestore), and Graph Databases (such as Neo4j).
What are the definitions of a Primary Key and a Foreign Key?
A Primary Key uniquely identifies a record within a table, while a Foreign Key links a record in one table to a record in another table.
What do the CRUD acronym letters represent in database operations?
Create (insert data into the database), Read (retrieve data from the database), Update (modify existing data), and Delete (remove data from the database).
What are the specific requirements to satisfy First Normal Form (1NF) and Second Normal Form (2NF)?
1NF requires eliminating repeating groups and ensuring all attributes have atomic values; 2NF requires eliminating partial functional dependency so that every non-prime attribute is fully dependent on prime attributes.
What are the specific requirements to satisfy Third Normal Form (3NF) and Boyce-Codd Normal Form (BCNF)?
3NF requires eliminating transitive dependencies; BCNF requires eliminating functional dependencies such that every determinant must be a super key or candidate key.

What mechanism does a database index use to enhance query performance as shown in this diagram?
A database index maintains a collection of pointers where each pointer references a full table record in the database, allowing records to be located efficiently from known look-up values without scanning the entire table.
What do the ACID properties of database transactions guarantee?
Atomicity (all operations succeed or none do), Consistency (data remains valid according to rules), Isolation (concurrent transactions do not interfere with one another), and Durability (committed changes are permanent).