Information & Communication Technology, Programming Architecture, and Databases

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/23

flashcard set

Earn XP

Description and Tags

Comprehensive flashcards covering Introduction to ICT, Programming Constructs, Modular Code Architecture in Python, and Database Systems from PNEC lecture series.

24 Terms

1
New cards

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.

2
New cards

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).

3
New cards

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).

4
New cards

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.

5
New cards

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).

6
New cards

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).

7
New cards

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.

8
New cards

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).

9
New cards

What are the five steps of problem-solving in programming?

  1. Understand the Problem, 2. Plan the Solution, 3. Write the Code, 4. Test the Code, and 5. Refine the Solution.
10
New cards

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.

11
New cards

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.

12
New cards

What quantitative benefits does modular programming provide in terms of reusability, bug localization, and execution speedup?

It delivers 65%65\% code reusability by cutting enterprise duplication, 3.5×3.5\times faster bug localization through isolated unit boundaries, and up to 50×50\times execution speedup by leveraging C-compiled native binaries.

13
New cards

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.

14
New cards

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.

15
New cards

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.

16
New cards

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.

17
New cards

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.

18
New cards

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).

19
New cards

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.

20
New cards

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).

21
New cards

What are the specific requirements to satisfy First Normal Form (1NF1\text{NF}) and Second Normal Form (2NF2\text{NF})?

1NF1\text{NF} requires eliminating repeating groups and ensuring all attributes have atomic values; 2NF2\text{NF} requires eliminating partial functional dependency so that every non-prime attribute is fully dependent on prime attributes.

22
New cards

What are the specific requirements to satisfy Third Normal Form (3NF3\text{NF}) and Boyce-Codd Normal Form (BCNF)?

3NF3\text{NF} requires eliminating transitive dependencies; BCNF requires eliminating functional dependencies such that every determinant must be a super key or candidate key.

23
New cards
<p>What mechanism does a database index use to enhance query performance as shown in this diagram?</p>

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.

24
New cards

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).