1. Instructor information
:
Instructor name: DO PHUC Email: phucdo@uit.edu.vn
Phone: (84-8) 4471192 Cell phone: (84-8) 3942460
Office: Unisoft, Linh Trung, Thu Duc, HCMC Office hours: 7:30-9:00 am
2. Class room
:
Main class room (campus): Unisoft Auditorium
Online classroom (website): www.uit.edu.vn/DataminingDatawarehouse-courses
Class meeting time: weekly
Library hours (where): VNU-Library.
3. Course information
:
Course description:
Credit: 4 ( 3 lecture. + 1 lab)
To introduce concepts and types of Computer Database, examine theoretical and pragmatic ideas underlying relational databases, and discuss certain other
aspects of database systems - recovery, concurrency, security, and integrity. The Database Administration of Oracle will be presented as a typical database
admistration.
Course objectives:
Upon completion of this course, the students should be able to outline an architecture for a database system, define and manipulate data, and understands
transactions process of database systems.
Prerequisite: None
4. Book and materials
:
Required textbook:
- Peter Rob, Carlos Coronel, Database Systems: Design, Implementation, and Management, 4th edition, Course Technology, 1999.
- D. Kroenke, Database Processing: Fundamentals, Design and Implementation, Prentice Hall Business Publishing, 1997.
- C. J. Date, An Introduction to Database Systems, 6th ed., Addison Wesley, 1995.
- Ramez Elmasri and Shamkant B. Navathe, Fundamentals of Database Systems, 2nd ed., Benjamin/Cummings Publishing Co., 1994
- Connolly, T., Begg, C. & Strachan, A.. Database Systems: A Practical Approach to Design, Implementation and Management, Addison-We
Course website: www.uit.edu.vn/databasesystem
5. Course requirements
:
Programming Assignments: Exercises are in corresponding sections of the required book.
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
:
Prograrming 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 prohibitted from test or exam
- Student may not use Vietnamese languague 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.
8. Course outline
:
|
Unit |
Topics |
Time |
|
1 |
Introduction |
(3 Hours) |
|
2 |
Data Modelling
Entity-Relationship(ER) Model, Entities and Entity types, Relationship and Relationship type, Constraints, Weak Entity Types, ER Diagrams. |
(7 Hours) |
|
3 |
Process of Database Design
Phase 1 : Requirement Analysis |
(3 Hours) |
|
4 |
Database and Database Application Design
Database design using entity-relationship and semantic object models, database application design. Terminology in Relational Data Model, |
(8 Hours) |
|
5 |
Database Implementation
Foundations of relational implementation. Structured Query Language (SQL): DML Features in SQL, DDL in SQL, Updates in SQL, Views in SQL, |
(8 Hours) |
|
6 |
Functional Dependencies
Amstrong's Inference Rules and Minimum Covers, Normal Forms: First Normal Form, Second Normal Form, Third Normal Form, Boyce-Codd Normal |
(8 Hours) |
|
7 |
Database Administration
Fundamentals of the tasks and functions required of a database administrator. While Oracle is the Primary Database
|
(4 Hours) |
|
8 |
Trends In Database Current Trends in Database Systems: Client-Server database systems,, Knowledge-Based Systems, data warehousing and data mining concepts. |
(3 Hours) |
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 submited by email before the next session begins.
Instructor’s Signature
A/Prof. Dr. DO PHUC