1. Instructor information
:
Instructor name: MSc. Do Thi Minh Phung Email: phungdtm@uit.edu.vn
Phone: (84-8) …………………… Cell phone: (84-8) ……………
Office: Unisoft, Linh Trung, Thu Duc, HCMC Office hours: ………………….
(other instructors)
2. Class room
:
Main class room (campus): Unisoft Auditorium
Online classroom (website): www.cttt/
Class meeting time: weekly
Library hours (where): VNU-Library.
3. Course information
:
Course description:
Credit: 4 (3 lecture + 1 lab)
This course covers relational database technology, including basic concepts, relational algebra, enhanced entity-relationship data modeling, functional
dependencies and normalization, design methodology, SQL query language (DDL and DML), views, security and transaction management. Students design and
implement a database application using RDBMS. Also covers some current database trends such as replication, object-relational DBMS, data warehousing and
OLAP, and use of databases through web technology.
Course objectives:
At the completion of this course, a student should be able to:
- Describe the functions and characteristics of the relational database model.
- Apply techniques of database design including:
ü Enhanced entity-relationship modeling;
ü Functional dependencies and normalization; and
ü Derivation of relations schema from EER models.
- Apply database design process to design and implement a database application using a RDBMS.
- Describe security issues and data protection techniques in a database environment.
- Use relational algebra operations to solve relational queries.
- Use SQL to implement and query a relational database.
- Discuss techniques for transaction management and concurrency control.
- Explain the use of databases in data warehousing and OLAP.
- Identify recent trends and developments in the database systems area.
Prerequisite: none
4. Book and materials
:
Required textbook:
Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom, Database Systems - The Complete Book, Prentice Hall, ISBN: 0-13-031995-32002.
Other materials:
Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems, Third Edition, McGraw Hill, 2003. ISBN: 0-07-246563-8.
C. J. Date, An Introduction to Database Systems, Eighth Edition, Addison- Wesley, 2003. ISBN 0-321-19784-4.
Ramez Elmasri and Shamkant B. Navathe, Fundamentals of Database Systems. Fourth Edition, Addison-Wesley, 2004. ISBN 0-321-12226-7.
Abraham Silberschatz, Henry F. Korth and S. Sudarshan, Database System Concepts, Fourth Edition. McGraw Hill, 2004. ISBN 0-07-255481-9.
Course website: www.uit.edu.vn/
5. Course requirements
:
Assignments: Exercises are in corresponding sections of the required book.
Computer-based training and testing: . . .
Projects or Team Class Projects: Projects are given by the instructor after finishing a chapter.
Midterm Examinations:
Class attendance/participation: Evaluated by checking in the Attendance Book
Final Examination: Students are directly tested and automatically marked on computers.
6. Grading Procedures
:
Assignments: ............................................................................... 20%
Quizzes: ...............................................................................................
Computer-based training and testing: ..................................................
Projects or Team Class Projects: ................................................... 10%
Midterm Examinations: ............................................................... 25%
Class attendance/participation: ...................................................... 5%
Final Examination: ....................................................................... 40%
Total point and Grades
:
90-100: Good (A) 80-89: Well (B) 70-79: Mean (C)
60-69: Weak (D) 50-59: bad (E) 1-49: too bad (F)
7. Academic integrity Policies
:
- Student may not be absence in 4 sessions. If so, he/she will be prohibited from test or exam.
- Student may not use Vietnamese language in their class, or will be reduced 2% final marks.
- Be punctual to come and leave the class.
- Maximum cancellation time per semester is 6 hours per class.
etc.
8. Course outline
:
|
Week |
Session |
Date
|
Topics
|
Assignments
|
|
1 |
Chapter 1 – |
|
||
|
2 |
Chapter 2 – Entity-relational data model Entities and Entity types, Relationship and Relationship type, Constraints, Weak Entity Types, ER Diagrams |
Exc |
||
|
3 |
Chapter 3 – Relational data model
Attribute, Relationship, Tuple, Relation schema, Database schema, Relation instance, Key (Super key, Key, Primary key, Equivalent key, |
Exc |
||
|
4+5 |
Chapter 4 - Relational algebra language Operations on sets (Union, Intersection, Subtraction, …), Relational operations (Projection, Selection, Joining, …), |
Exc |
||
|
6+7 |
Chapter 5 SQL Data Manipulation language: Insert, Update, Delete, Basics, Joins, Sets, Aggregates, Subqueries and Views |
Exc |
||
|
8+9 |
Chapter 6 – Integrity constraint in context of one relation, Integrity constraint in context of many relations Transaction management |
|
||
|
10+11 |
Chapter 7 - Functional Dependencies and Normalization |
|
||
|
12 |
Final Exam Week |
|
Schedule, deadlines, deliverables by week: Students submit weekly Assignments on Fri/week
Important dates: ……………………..: Midterm test. …………………: Final exam.
9. Comments and notes
:
Make-up: Make-up classes are officially accepted after the Make-up forms are signed by all of the students in the class and directly send to the
Registrars.
Preparation for Class: It is expected that the students read related chapter in textbook and lecture noted before each class. This will help to
capture the topics presented and discussed during class hours.
Use of Class Time: Class time will be used mainly for lectures and discussions. A small part of class hours is used for testing. House works will
be discussed on individual basis.
Class Attendance: Due to the broad range of topics discussed throughout the course and their inter-relationship, it is requested that the students
should attend the class regularly.
Incomplete Grade: A grade of “I” (Incomplete) will be administered only under extreme, verifiable “emergency” situation where the student is
unable to complete some portion of the course work due to circumstances beyond his/her control PROVIDED THE STUDENT IS PASSING THE COURSE.
Assignment Requirement: Assignments of each session must be submitted by email before the next session begins.
Instructor’s Signature
MSc. Do Thi Minh Phung