IT3292E Database
HomePage
Class Information
Class: ICT-K667(151997)
Time: 12:30-14:00, Monday
Location: D9-402
Instructor: Vũ Tuyết Trinh
School of Information Technology and Communication
Hanoi University of Science and Technology
Email: trinhvt@soict.hust.edu.vn
Description
Database is a collection of data which is intended to be shared by
users and applications. DBMS (Database Management System) is a
computer system which enables to handle this collection of data
efficiently. In this course, topics such as purposes and roles of
database, the relational model as a data representation method, the
SQL language to manipulate stored data, database design methods to
handle data efficiently, transaction management which enables data
sharing by users and applications, architecture of DBMS to process
huge datasets, recent trends and future directions will be
introduced.
- Students can explain purposes and roles of database in
information systems.
- Students can make programs to manipulate data with SQL.
- Students can explain important concepts on database design such
as normalization and integrity constraints.
- Students can explain basic methods for transaction management,
such as concurrency control and fault recovery
- Students can explain the basic structure of DBMS, such as index
management and query processing.
Grading
- Midterm exam: 50%
2-3 tests/assignment (both computer-based and written exam)
- Final exam: 50% (MCQ)
Text and Reading
1. Raghu Ramakrishnan, Johannes Gehrke. Database Management Systems
(3rd edition). 2003. McGraw-Hill
2. C. J. Date. An introduction to database systems (8th edition).
2004. Pearson/Addison-Wesley
3. Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom.
Database systems : the complete book (2nd edition). 2008.
Prentice Hall
4. R. Elmasri and S. Navathe. Fundamentals of Database Systems.
2004 (4th edition). Addison-Wesley.
5. Nguyễn Kim Anh. Nguyên lý của các hệ cơ sở dữ liệu. 2004. Nhà
xuất bản Đại học Quốc Gia Hà Nội.
Useful website/resources
- Online course by Jennifer Widom (Stanford University) :
Databases: Introduction to Relational Databases at
https://www.edx.org/course/databases-5-sql, especially the
following parts
• Databases: Relational Databases and SQL
• Databases: Advanced Topics in SQL (prerequisite: Relational
Databases and SQL)
• Databases: Modeling and Theory
• others parts may be skipped until end of this class
- others will be provided during the class
Tentative Plan
Week Topics Materials
2 Introduction to Database slides1_Introduction.pdf
9/9 Relational DB
3 Relational Database Language SQL slides2_SQL(part1).pdf
16/9 Assignment (on MS. Teams)
4 SQL (cont.) slides3_SQL(part2).pdf
23/9 Assignment – correction & discussion
Assignment for grading
(Deadline :30/9/2024)
5 slides5_ER-class.pdf
Conceptual Design with ER Model
30/9
6 Exercises (SQL): Correction &
7/10 Discussion
7
Test 1
14/10
8 Database Design: bottom-up approach slides6_Functional_Dependency
21/10 Functional Dependency
9 Normal Forms & Normalization slides6_Normalization
28/10 Exercises
10
SEMESTER BREAK
4/11
11 No class
11/11
12 Index Management slides7_Storage
18/11
13 No class
25/11
14 Query Processing (relational algebra) slides8_QueryProcessing
2/12 Exercises
Exercises
7/12 -
Saturday Contraints & triggers slides9_Constraints_Triggers
(online) Security
15
Transaction
9/12
16 Test 2
16/12
17
Review
23/12
18 Exercises
30/12 DB++
FINAL EXAM (schedule TBD)
