Database Fundamentals

1. Database Fundamentals (Lecture Plan)

2. Database Fundamentals (Lecture Notes from MMLS Cyberjaya)
Lecture 01: Database Concepts
Lecture 02: Relational Data Model
Lecture 03: ER Modeling Part I
Lecture 04: ER Modeling Part II
Lecture 05: Structured Query Language (SQL)
Lecture 06: Advanced Structured Query Language (SQL)
Lecture 07: Advanced Structured Query Language (SQL)
Lecture 08: Normalization of Database Tables
Lecture 09: Database Design
Lecture 10: Transaction & Concurrency Control
Lecture 11: Distributed Database Management Systems
Lecture 12: Client / Server, Object-Based System
Lecture 13: Trends: Data Warehouse & Data Mining Web Database
Full Version

3. Database Fundamentals (Labs from MMLS Cyberjaya)
Lab 01: Database Concepts
Lab 02: Relational Data Model
Lab 03: ER Modeling Part I
Lab 04: ER Modeling Part II
Lab 05: Structured Query Language (SQL)
Lab 06: Advanced Structured Query Language (SQL)
Lab 07: Advanced Structured Query Language (SQL)
Lab 08: Normalization of Database Tables
Lab 09: Database Design
Lab 10: Transaction & Concurrency Control
Lab 11: Distributed Database Management Systems
Lab 12: Client / Server, Object-Based System
Lab 13: Trends: Data Warehouse & Data Mining Web Database
Full Version

4a. Database Fundamentals (Project)
4b. Database Fundamentals (Assignment Sample)
[NOTE: Thanks for Mohamed Abadi Juma for sharing this with us.]

5. Database Fundamentals (Lab Solutions from MMLS Cyberjaya)
Lab 01: Database Concepts
Lab 02: Relational Data Model
Lab 03: ER Modeling Part I
Lab 04: ER Modeling Part II
Lab 05: Structured Query Language (SQL)
Lab 06: Advanced Structured Query Language (SQL)
Lab 07: Advanced Structured Query Language (SQL)
Lab 08: Normalization of Database Tables
Lab 09: Database Design
Lab 10: Transaction & Concurrency Control
Lab 11: Distributed Database Management Systems
Lab 12: Client / Server, Object-Based System
Lab 13: Trends: Data Warehouse & Data Mining Web Database
Full Version

6. Database Fundamentals (Lab Answers from Tutorial TC201)
Lab 01: Database Concepts
Lab 02: Relational Data Model
Lab 03: ER Modeling Part I
Lab 04: ER Modeling Part II
Lab 05: Structured Query Language (SQL)
Lab 06: Advanced Structured Query Language (SQL)
Lab 07: Advanced Structured Query Language (SQL)
[NOTE: Until Question 7 ONLY WITHOUT including Extra Exercise]
Lab 08: Normalization of Database Tables
Lab 09: Database Design
Lab 10: Transaction & Concurrency Control
Lab 11: Distributed Database Management Systems
Lab 12: Client / Server, Object-Based System
Lab 13: Trends: Data Warehouse & Data Mining Web Database
Full Version

7. Database Fundamentals (Lab Answers from Tutorial TC204)
Lab 01: Database Concepts
Lab 02: Relational Data Model
Lab 03: ER Modeling Part I
Lab 04: ER Modeling Part II
Lab 05: Structured Query Language (SQL)
Lab 06: Advanced Structured Query Language (SQL)
Lab 07: Advanced Structured Query Language (SQL)
[NOTE: Until Question 7 ONLY WITHOUT including Extra Exercise]
Lab 08: Normalization of Database Tables
Lab 09: Database Design
Lab 10: Transaction & Concurrency Control
Lab 11: Distributed Database Management Systems (Tutor Version)
Lab 12: Client / Server, Object-Based System (Tutor Version)
Lab 13: Trends: Data Warehouse & Data Mining Web Database (Tutor Version)
Full Version

8. Database Fundamentals (Quiz from Tutorial TC204)
Quiz 1
Quiz 2
Full Version

9. Database Fundamentals (Quiz Answers)
Quiz 1
Quiz 2
Full Version

10a. Database Fundamentals (Mid-Term Test 1 Question Paper)
10b. Database Fundamentals (Mid-Term Test 1 Answer)

11. Gliffy - Online Diagram Software and Flowchart Software

12. IBM DB2 Express-C V9.7.4
Part 1
Part 2

13a. Database Fundamentals (Quiz 1 Marks for TC101 Students)
13b. Database Fundamentals (Results for TC102 Students)
13c. Database Fundamentals (Barring List for TC102 Students)
13d. Database Fundamentals (Overall Marks for TC101 Students)
13e. Database Fundamentals (Coursework Marks for TC102 Students)

14. Database Fundamentals (Extra Materials from Kirby510's Fans)
Database Midterm Part B Answer
Lab 06 Answer

Return to Bachelor of Computer Science (Hons)