Queries and relational databases

JAMB Computer Studies Revision Notes

  • Databases and Data Analysis
  • 2 min read
  • Checked by imtiaz ahmed

Linking tables with keys, the three kinds of relationship, normalisation, and writing SQL queries to select, filter, sort and summarise data.

In these notes
  1. Relational databases
  2. Normalisation
  3. Queries and SQL

Revision notes come with the Complete plan

Complete gives you:

  • All 11 JAMB subjects currently available on GRO Academy
  • 26,964 practice questions, each with an explanation
  • Performance tracking: your results saved, with your weakest topics first
  • Full CBT mock exams, scored out of 400 like the UTME
  • Revision notes for every topic
  • Curriculum checklists for every subject
  • Past papers

Complete: ₦24,000 for 3 months, ₦10,000 a month or ₦108,000 a year.

See the plans Sign in

Practise this topic

All Computer Studies notes
  1. Computer Fundamentals
    1. History and evolution of computing
    2. Classification and uses of computers
    3. Data, information and data processing
    4. The computer system: input, processing and output
    5. Memory and storage
    6. Maintenance, safety and troubleshooting
  2. Software and Operating Systems
    1. System and application software
    2. Operating systems and file management
  3. Data Representation and Logic
    1. Number systems and base conversion
    2. Binary arithmetic and data representation
    3. Logic gates and truth tables
  4. Algorithms and Programming
    1. Algorithms, pseudocode and flowcharts
    2. Programming languages and translators
    3. Variables, data types and operators
    4. Selection and iteration
    5. Functions, arrays and modular programming
    6. Debugging, testing and dry runs
    7. Software development life cycle
  5. Application Packages
    1. Word processing
    2. Spreadsheet fundamentals
    3. Spreadsheet functions and charts
    4. Presentation, graphics and multimedia
  6. Databases and Data Analysis
    1. Database concepts
    2. Queries and relational databases
    3. Data collection and analysis
  7. Networks and the Internet
    1. Computer networks
    2. Internet protocols and addressing
    3. The internet, the web and online services
    4. Web design and publishing
  8. Security, Ethics and Society
    1. Digital citizenship and safe communication
    2. Cybersecurity threats and protection
    3. Authentication and privacy
    4. Computer ethics, law and health
    5. ICT careers and entrepreneurship