Student 

Notes v3.2

Database

Systems: Contents

Page

Lecture

Chapter 1 Introduction 5 Intro
Chapter 2 Database Analysis 13
ER Modelling 1 14 ER1
ER Modelling 2 26 ER2
Mapping ER Models to Relations 31 ER3
Advanced ER Mapping 38 ER4
Chapter 3 SQL 42
SQL1 43 SQL1
SQL2 Logic Opers and Aggreg 54 SQL2
SQL3 Joins and Views 64 SQL3
SQL4 Subqueries ... 71 SQL4
Chapter 4 Normalisation 80
0NF-3NF 81 Normal 1
BCNF + 91 Normal 2
Chapter 5 Relational Algebra 98
Rel Algebra 1 99 Relalg 1
Rel Algebra 2 105 Relalg 2
Chapter 6 Implementations 109
Concurrency using transactions
Transactions 110 Transactions
Concurrency 114 Concurrency
Recovery 117 Recovery
DBMS Implementation 121 Imp
Chapter 7 Database Connectivity 130
Application Links 131 Applink
Chapter 8 Metadata, Security and the Database Administrator 142 Meta
Chapter 9 Offline Tutorials 150
SQL Tutorials 1-4 151
ER Diagrams for tutorials 169
ER Exercises 1-2, 3-5 173 Answers 1-2 3-5
Normalization Exercises 176 Answers PDF

ActiveSQL