Database Design and Management

| Lecture Notes | Tutorials | Quizzes / Tests | Projects / Assignments | Others |

Lecture Notes

01. Lecture Notes from MultiMedia Learning System
Lecture 01: Database Life Cycle (DBLC)
Lecture 02: Introduction to Structured Query Language (SQL)
Lecture 03: Advanced Structured Query Language (SQL I)
Lecture 04: Advanced Structured Query Language (SQL II)
Lecture 05: The Data Warehouse – part 1
Lecture 06: The Data Warehouse – part 2.1
Lecture 07: The Data Warehouse – part 2.2
Lecture 08: Distributed Database Management Systems – part 1
Lecture 09: Distributed Database Management Systems – part 2
Lecture 10: Object-Oriented Databases
Lecture 11: Interacting with Databases Through the Web
Lecture 12: Database Administration and Security
Full Version (Lecture Note 01 - Lecture Note 12)

02. Revision Notes Exclusively from Kirby510's Website Blog
Mid-Term Examination Revision Note (Lecture 01 - Lecture 05)
Final Examination Revision Note

Tutorials

01. Tutorials from MultiMedia Learning System
Tutorial 01: Advanced SQL – Data Definition and Manipulation
Tutorial 02a: Advanced SQL – Queries
Tutorial 02b: Advanced SQL – Queries
Tutorial 03: Advanced SQL – View & Trigger
Tutorial 04a: Data Warehousing & Data Mining
Tutorial 04b
Tutorial 05: Distributed Database Part 1
Tutorial 06: Distributed Database Part 2
Tutorial 07: Object-Oriented Database Model
Tutorial 08: Web database & Connectivity
Tutorial 09: Database Administration and Security
Full Version (Tutorial 01 - Tutorial 09)

03. Tutorial Solutions from MultiMedia Learning System
Tutorial 01: Advanced SQL – Data Definition and Manipulation
Tutorial 02a: Advanced SQL – Queries
Tutorial 02b: Advanced SQL – Queries
Tutorial 03: Advanced SQL – View & Trigger
Tutorial 04a: Data Warehousing & Data Mining
Tutorial 04b
Tutorial 05: Distributed Database Part 1
Tutorial 06: Distributed Database Part 2
Tutorial 07: Object-Oriented Database Model
Tutorial 08: Web database & Connectivity
Tutorial 09: Database Administration and Security
Full Version (Tutorial 01 - Tutorial 04a, Tutorial 05 - Tutorial 09)

Quizzes / Tests

01. Past Year Exam Papers from MultiMedia University Library
Trimester 1, 2008/2009
Trimester 3, 2008/2009
Trimester 2, 2009-2010
Trimester 1, 2011/2012
Trimester 1 Supplementary, 2011/2012
Trimester 1, 2012/2013
Trimester 1 Supplementary, 2012/2013
Full Version

Projects / Assignments

01. Assignments from MultiMedia Learning System

Others

01. Lecture Plan from MultiMedia Learning System

02. IBM DB2 Express-C V9.7.4

03. IBM DB2 Database for Linux, UNIX, and Windows Information Center

04a. SQL Exercise
04b. PL/SQL Exercise in Oracle
04c. PL/SQL Extra Notes

05. Midterm Marks

06. Coursework Marks

* Coming Soon

Return to Bachelor of Computer Science (Hons)