User Rating: 5 / 5
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%