Database System Management

Syllabus: EP03.CNTT1152 - DATABASE MANAGEMENT SYSTEMS 

Reference books:

1. Database Systems: Design, Implementation,... by Coronel, Carlos (amazon.com) 

2. Database System Concepts: 9780078022159: Computer Science Books @ Amazon.com 

3. MySQL Crash Course: A Hands-on Introduction to Database Development: Silva, Rick: 9781718503007: Amazon.com: Books 

Online Practice :

1. SQL Tutorial (geeksforgeeks.org) 

2. Solve SQL | HackerRank 

3. Problems - LeetCode (Database section)

4. Làm quen với SQL (codelearn.io) 

5. Giới thiệu SQL và SQL server | How Kteam 

MySQL:

1. MySQL :: MySQL Community Downloads (Workbench & MySQL Server)

Session 1:

1. Slide: Database System, Data Model 

2. Read: Chapter 1, 2 [1], Chapter 1, 2 [3]

3. Practice/Exercises: 

   • Compile exercises from Chapters 1 and 2 [1] excluding those that require private data. The deadline for completion is 09/01/2024. Additionally, students are allowed to form groups with a maximum of 4 students for collaborative work.

   • Install MySQL and practice the exercises mentioned in Chapters 1 and 2 [2].

Session 2:

1. Slide: Relation Database Model

2. Read: Chapter 3 [1], Chapter 2 [2]

3. Practice/Exercise:

   • Compile exercises from Chapter 3 [1] and Chapter 2 [2] excluding those that require private data. The deadline for completion is 16/01/2024. Additionally, students are allowed to form groups with a maximum of 4 students for collaborative work.

   • SQL: Chapter 3 [3]

Session 3:

1. Slide: Entity Relationship Modeling 

2. Read: Chapter 4 [1], Chapter 6 [2]

3. Practice/Exercise:

   • Compile exercises from Chapter 4 [1] (and Chapter 6 [2] - optional) excluding those that require private data. The deadline for completion is 29/01/2024. Additionally, students are allowed to form groups with a maximum of 4 students for collaborative work.

   • SQL: Chapter 4 [3]

Session 4:

1. Slide: Extended Entity Relation Modeling

2. Read: Chapter 5 [1]

3. Practice/Exercise:

   • Compile exercises from Chapter 5 [1] excluding those that require private data. The deadline for completion is 31/03/2024. Additionally, students are allowed to form groups with a maximum of 4 students for collaborative work

Session 5:

1. Slide: Normalization of Database Tables

2. Read: Chapter 6 [1] 

3. Practice/Exercise:

   • Compile exercises from Chapter 6 [1] excluding those that require private data. The deadline for completion is 07/04/2024. Additionally, students are allowed to form groups with a maximum of 4 students for collaborative work

Session 6:

1. Slide: Introduction to SQL

2. Read: Chapter 7 [1], Chapter 3 [2]

3. Practice/Exercise:

   • Compile exercises from Chapter 7 [1] excluding those that require private data. The deadline for completion is 14/04/2024. 

Session 7:

1. Slide: Introduction to SQL

2. Read: Chapter 7 [1], Chapter 3 [2]

3. Practice/Exercise:

   • Compile exercises from Chapter 7 [1] excluding those that require private data. The deadline for completion is 14/04/2024. 

Session 8:

1. Slide: Advanced SQL

2. Read: Chapter 8 [1], Chapter 3 [2]

3. Practice/Exercise:

   • Compile exercises from Chapter 8 [1] excluding those that require private data. The deadline for completion is 21/04/2024.