2nd Year Computer Science Notes

Every chapter of the computer science syllabus for 2nd Year under the Punjab Board, in the order the book takes them. 14 chapters have a finished lesson — notes, worked examples, a graph you can move, flashcards and a quiz. The rest are mapped and being written.

Also called 12th Class, FSc Part 2, ICS Part 2, HSSC Part 2.

01

Data Basics

▸Data BasicsWhat data is, how it is stored, and why files stopped being enough · 18 min · 8 questions→

02

Basic Concepts and Terminologies of Databases

▸Basic Concepts and Terminologies of DatabasesKeys, relationships and the software that holds it all together · 20 min · 8 questions→

03

Database Design Process

▸Database Design ProcessFrom a description in words to a set of tables that will not fight you later · 20 min · 8 questions→

04

Data Integrity and Normalization

▸Data Integrity and NormalizationRemoving the duplication that lets a database contradict itself · 22 min · 8 questions→

05

Introduction to Microsoft Access

▸Introduction to Microsoft AccessThe objects a database file contains, and what each is for · 18 min · 8 questions→

06

Table and Query

▸Table and QueryAsking the database a question, and getting only the rows you wanted · 20 min · 8 questions→

07

Microsoft Access Forms and Reports

▸Microsoft Access Forms and ReportsA screen for putting data in, and a page for getting it out · 18 min · 8 questions→

08

Getting Started with C

▸Getting Started with CThe shape of a C program, and what happens between typing it and running it · 18 min · 8 questions→

09

Elements of C

▸Elements of CData types, variables, operators — and the traps each one sets · 20 min · 8 questions→

10

Input and Output

▸Input and Outputprintf and scanf, and the ampersand everybody forgets · 18 min · 8 questions→

11

Decision Constructs

▸Decision Constructsif, else and switch — and the semicolon that silently breaks everything · 18 min · 8 questions→

12

Loop Constructs

▸Loop Constructswhile, do-while and for — and the off-by-one that costs a mark every year · 20 min · 8 questions→

13

Functions in C

▸Functions in CBreaking a program into pieces, and what a function can and cannot change · 20 min · 8 questions→

14

File Handling in C

▸File Handling in CMaking data outlive the program that created it · 18 min · 8 questions→