Databases and Information Systems: Revision and References
Shared revision, practice questions, answer explanations and references from the original module.
By Akhilesh Saini
Module CA-08 — Consolidated quick revision
Use this table after understanding the full lessons. Each line is a recognition clue, not a substitute for all exceptions discussed above.
| Exam clue | Correct concept | Caution |
|---|---|---|
| Raw or recorded values | Data | Data is not limited to numbers |
| Useful interpreted/organized data | Information | Quality and context still matter |
| Organized data collection | Database | Not the same as the software managing it |
| Software for managing databases | DBMS | Does not guarantee perfect security by default |
| Relational database manager | RDBMS | Relational is one database model |
| Rows and columns | Table | A relational table is not just a spreadsheet |
| One horizontal entry | Row/record/tuple | Identifies an entry, not a field definition |
| One vertical property | Column/field/attribute | Holds a property across rows |
| Unique chosen identifier | Primary key | Not NULL and not duplicated |
| Reference between related tables | Foreign key | Child-side values can repeat |
| Key using multiple fields | Composite key | Must be defined for the intended rows |
| Combining matching data in queries | JOIN | Not an automatic permanent file merge |
| Adding/removing schema objects | DDL | CREATE, ALTER, DROP are examples |
| Modifying stored rows | DML | INSERT, UPDATE, DELETE |
| Reading records | SELECT | WHERE filters; ORDER BY sorts |
| Typical query count | COUNT(*) | Counts rows rather than non-NULL values of one named column |
| Interactive cell formulas | Spreadsheet | May connect to a database |
| Plain tabular text exchange | CSV | Does not retain workbook charts or DB constraints |
| Integrated analytical data | Data warehouse | Not a synonym for backup |
| Operational transaction workload | OLTP | Online Transaction Processing |
| Analytical workload | OLAP | Online Analytical Processing |
| Extract → Transform → Load | ETL | ELT performs transform after load |
| Finding patterns in data | Data mining | Patterns require responsible interpretation |
| Amount/speed/type of data | Volume/Velocity/Variety | Core Big Data Vs |
| Transaction capture | TPS | Often feeds reporting systems |
| Regular management reports | MIS | Information needs to be fit for purpose |
| What-if analytical support | DSS | Supports, does not replace decision-makers |
| Broad senior-executive view | ESS/EIS | Boundaries may overlap with MIS and BI |
| Integrated enterprise processes | ERP | Not a synonym for database |
| Customer interactions and relationships | CRM | Not an SQL command |
| Indicator for a defined objective | KPI | Poorly defined metrics can mislead |
| Bad input, bad output | GIGO | Controls and verification remain necessary |
Ten high-priority distinctions
- Data vs information: recorded values versus their useful organization and interpretation.
- Database vs DBMS: stored collection versus managing software.
- Row vs column: one record versus one attribute.
- Primary vs foreign key: unique identifier versus reference to an eligible key.
- Relational link vs join: a designed relationship versus a query operation using it.
SELECTvsUPDATE: read versus modify records.- Spreadsheet vs DBMS: worksheet calculations versus controlled data-management structures and operations.
- OLTP vs OLAP: transactional operations versus analytical exploration.
- Data warehouse vs mining: prepare/integrate analytical data versus discover patterns.
- TPS vs MIS vs DSS: record daily events, summarize for management, and support less-routine decisions.
Module practice strategy
For each lesson, answer all 12 questions before reading the explanations. If a response is wrong, locate the nearby definition or worked example and write a one-sentence correction in your own words. Revisit the high-priority distinctions before a mixed-topic mock test. These questions are original and are not represented as verified previous-year exam items.
Sources and further reading
These authoritative and technical resources support key definitions and are optional reading. The explanations and questions above have been written independently for introductory Computer Awareness.
- IBM — What is a database? — database, database models and DBMS.
- SQLite — Foreign key support — examples of referenced keys and relational integrity.
- SQLite — SELECT statement — SQL retrieval, filtering and result ordering.
- SQLite — SQL language — official summary of language syntax.
- IBM — What is a data warehouse? — integrated analytical stores and ETL/ELT, with OLTP/OLAP distinctions.
- IBM — What is data mining? — pattern discovery and data-analysis use cases.
- IBM — What is big data? — core and extended Vs of big data.
- IBM — What is a data platform? — integration between storage and BI/analytics tools.