Databases

First Term Exam (1.5 hours)

- Database A1: Chapter 1 - 7+ schema (48/60)

- Unit C: Internet and its application (Chapter 16 - 20) - mainly networking IP address (12/60)

CDC & HKEAA

SQL commands and Spreadsheet Functions

Reserved Word List

Textbook: New Senior Secondary Information and Communication Technology Elective A1, Pearson Longman.

Unit A

Chapter 1: Applications of databases in Our Daily Life

Chapter 2: Data Organization in Databases

Unit B

Chapter 3: Relational Database Concept (I)

Chapter 4: Relational Database Concept (II)

Chapter 5: Structure Query Language (I)

Chapter 6: Structure Query Language (II)

Chapter 7: Structure Query Language (III)

Paper 1

Section A (Book 1): Excel + Database (Q1-10)

Section C (Book 2) (Q11-20)

Section D, E (except chp 28) - Book 3 (Q21-40)

Structure Q:

Q1. Excel + DB

Q2. Section C

Q3. Section D

Q4: Section E

Paper 2 (Database):

Q1-2. Section D

Q3-4. Database

Paper 3 (SBA - Design)

Page updated

Report abuse