1. COURSE OBJECTIVES
The course aims to give students an overview of data storage, query techniques, and database administration. Students will have the opportunity to explore database design methods and tools, and add real-world data processing experience using structured query language (SQL) to clean, transform data, and calculate on a modern database system for work related to industrial analysis services and data analysis, especially in business activities of enterprises.
2. COURSE CONTENT
|
No. |
Content |
Time Allocation |
Contribution to CLO |
|||
|
Hour(s) on the class |
Essays, exercise, Assignments… |
Self-study with teacher’s tutorials |
||||
|
Lecture |
Practice, Seminar… |
|||||
|
1 |
Chapter 1: Basic concepts of database. |
3 |
0 |
3 |
1,5 |
|
|
2 – 4 |
Chapter 2: Data modeling. |
6 |
3 |
4 |
9 |
1,5 |
|
5 – 7 |
Chapter 3: Data warehouse and multidimensional data model. |
6 |
3 |
4 |
9 |
1,5 |
|
8 – 13 |
Chapter 4: Structured Query Language (SQL). |
12 |
6 |
7,5 |
18 |
1,5 |
|
14 |
Project on database design |
3 |
7 |
26 |
3,4,5 |
|
|
15 |
Course summary |
3 |
17,5 |
3,4,5 |
||
|
Total (hours) |
30 |
15 |
22,5 |
82,5 |
||
3. COURSE ASSESSMENT
– Score ladder: 10
– Type of assessment
|
Form |
Content |
Criteria |
CLO |
Propor |
|
|
Formative |
Attendance |
Check attendance in lectures Participation in lesson |
The number of attendances and participation in lesson |
1,2 |
10% |
|
Quiz, midterm test |
Course knowledge Rating Criteria: – Define the problem clearly, logically, and feasible – Logical analysis, straight to the point, practical contact – Applying flexible and reasonable design |
Group project and slides of presentation Group presentation |
3,4,5 |
30% |
|
|
Summative |
Final Test |
Course knowledge |
MCQs + writing (90 mins) |
1,2,3,4 |
60% |
|
|
|
|
Total: |
100% |
|