FPT UNIVERSITY

UNDERGRADUATE PROGRAM
SYLLABUS

(Under Decision No. 318/QĐ-ĐHFPT dated 25/4/2015)

1 Course Name Database Systems

2 Course Code DBI202
3 No of credits 3
4 Degree Level Bachelor

Class hours: 60 hours

Lectures: 17
5 Time Allocation
Lab/Tutorials: 13

Recommended to have knowledge of Discrete Maths and Introduction to

6 Pre-requisite
Computing in advance

To provide students with basic knowledge on database models,

designing relational databse and skills in using SQL statements and SQL
Server.
Upon successful completion of this course, students should have:
1) Understand (ABET b)
• Relational Model of Data
• Design theory for Relational databases
• High-level Database Models
• Query languages
• Database Language SQL
7 Main objectives • Database Contraints
2) Be able to use a certain DBMS (ABET k)
• To do basic database administration operations (creation of table,
primary key, foreign key, diagram…)
• to query and manipulate data
3) Be able to prepare, make a presentation of a special DB related
topic (ABET i)

This course gives students an introduction to the evolution of Database

Systems and a basic understanding of a Database Management System,
devotes to the Relational Database Modeling, Design Theory for
Relational Databases as well as various aspects of Relational Database
Programming such as database query language, SQL, transactions,
8 Description contraints, triggers, and stored procedure.
During the course, students will have a chance to practice on a certain
DMBS suitable to the concrete context of course implementation.

806825668.xls
 - Students must attend more than 80% of contact slots in order to be
accepted to the final examination.
- Student is responsible to do all assigned exercises/asignments given by
9 Student's task instructor in class or at home and submit on time
- Use laptop in class only for learning purpose
- Promptly access to the FU CMS at http://cms.fpt.edu.vn for up-to-date
course information

Main books/resources:
1) Textbook: First Course in Database Systems, A, 3/E
Jeffrey D. Ullman, Jennifer Widom
ISBN-10: 013600637X
ISBN-13: 9780136006374
Publisher: Prentice Hall
Copyright: 2008
2) Author Website (Open Access) to slides and lecture notes
http://infolab.stanford.edu/~ullman/fcdb.html
3) Solutions Manual for A First Course in Database Systems, 3/E on
http://www.pearsonhighered.com/educator/hip_main_content/1,3120,-
500,00.html (or file 94888-Solution_FCDB3e.zip)
4) GOAL accompagned with the textbook on
Teaching &
http://esminfo.prenhall.com/goal/
10 Learning
5) FU Slides
Materials
6) FU CMS at http://cms.fpt.edu.vn .

Other references/resources:
1) Course CS145 (Stanford University):
http://infolab.stanford.edu/~widom/cs145/
2) SQL Server Book Online.

Tools:
- Internet
- Any DBMS (Client and Server) appropriate for creating and operating
relational databases

1) On-going Assessment:
- 05 Labs 15% (ABET k)
- 02 progress tests: 10% (ABET b)
- 01 Assignment: 20% (ABET b, i)
- Practical exam 25% (ABET k)
Assessment
11 2) Final Exam: 30% (ABET b)
scheme
3) Final Result 100%
Completion Criteria:
1) Every on-going assessment component >0
2) Practical Exam >=4
3) Final Exam Score >=4 & Final Result >=5

12 Scoring scale 10
13 Schedule See Appendix 1
14 Exam structure See Appendix 2

15 Approval Date

806825668.xls
 16 Approval Level

806825668.xls
 APPENDIX 1: COURSE SCHEDULE

Chapter Slot Content Category Student's Project Task before class

1.1 The Evolution of Database Systems

1.2 Overview of Database Management System
1 1 1.3 Outline of Database-System Studies Read chapter 1 in text book, focus on 1.1 and 1.2

Assignment Introduction (individual) Lecture

2.1 An Overview of Data Models
2 Read chapter 2 in text book, focus on 2.1 and 2.2
2.2 Basics of the Relational Model Lecture

3 2.3 Defining a Relation Schema in SQL Read chapter 2 in text book, focus on 2.3
Lecture
2
4 2.4 An Algebraic Query Language Read chapter 2 in text book, focus on 2.4
Lecture

5 Lab1 assistance Tutorial Do lab 1 as homework

6 Assignment assistance Tutorial Prepare the assignment proposal
3.1 Functional Dependencies
7 Lecture Read chapter 3 in text book, focus on 3.1 and 3.2
3.2 Rules About Functional Dependencies
8 3.3 Design of Relational Database Schema Lecture Read chapter 3 in text book, focus on 3.3

9 3.5 Third Normal Form Lecture Read chapter 3 in text book, focus on 3.5
3
10 Lab 2 assistance Tutorial Do lab 2 as homework
Progress test 1 (<=30')
11 Tutorial
Assignment assistance
4.1 The Entity / Relationship Model
12 Read chapter 4 in text book, focus on 4.1 and 4.2
4.2 Design Principles Lecture
4.3 Constraints in the E / R Model
13 Read chapter 4 in text book, focus on 4.3 and 4.4
4.4 Weak Entity Sets Lecture
4.5 From E / R Diagrams to Relational Designs
4 14 Read chapter 4 in text book, focus on 4.5 and 4.6
4.6 Converting Subclass Structures to Relations Lecture
15 Lab 3 assistance Tutorial Do lab 3 as homework
16 Assignment assistance Tutorial

806825668.xls
 6.1 Simple Queries in SQL
17 Read chapter 6 in text book, focus on 6.1 and 6.2
6.2 Queries Involving More Than One Relation Lecture
6.2 Queries Involving More Than One Relation (cont)
18 Read chapter 6 in text book, focus on 6.2 and 6.3
6.3 Subqueries Lecture

6 19 6.4 Full-Relation Operations Read chapter 6 in text book, focus on 6.4

Lecture
6.5 Database Modifications
20 Read chapter 6 in text book, focus on 6.5 and 6.6
6.6 Transactions in SQL Lecture
21 Lab 4 assistance Tutorial Do lab 4 as homework
22 Assignment assistance (focus on query) Tutorial
7.1 Keys and Foreign Keys
23 7.2 Constraints on Attributes and Tuples Read chapter 7 in text book, focus on 7.1 and 7.2
(implement constraints with MS SQL Server) Lecture
7
7.5 Triggers
24 Lecture Read chapter 7 in text book, focus on 7.5
(implement trigger with MS SQL Server)
25 Assignment assistance Tutorial
9. PSM/Stored Procedures
26 Read chapter 9 in text book
(implement stored procedure with MS SQL Server) Lecture
9
Progress Test 2 (<=30')
27
Lab 5 assistance Tutorial Do lab 5 as homework
28 Practical Exam Preparation Tutorial
29 Practical Exam (85')
30 Course Summary Tutorial Submit assignment
FINAL EXAM

806825668.xls
EDULE
Student's Project
Teacher's Material
Task after class

Exercise
Book, Power point, Solution for Exercise
CMS

Exercise
Book, Power point, Solution for Exercise
CMS
Exercise
Book, Power point, Solution for Exercise
CMS
Exercise
Book, Power point, Solution for Exercise
CMS

Submit lab 1
CMS
Exercise
Book, Power point, Solution for Exercise
CMS
Exercise
Book, Power point, Solution for Exercise
CMS
Exercise
Book, Power point, Solution for Exercise
CMS

Submit lab 2

CMS
Exercise
Book, Power point, Solution for Exercise
CMS
Exercise
Book, Power point, Solution for Exercise
CMS
Exercise
Book, Power point, Solution for Exercise
CMS
Submit lab 3
CMS

806825668.xls
 Exercise
Book, Power point, Solution for Exercise
CMS
Exercise
Book, Power point, Solution for Exercise
CMS
Exercise
Book, Power point, Solution for Exercise
CMS
Exercise
Book, Power point, Solution for Exercise
CMS
Submit lab 4
CMS

Exercise
Book, Power point, Solution for Exercise
CMS

Exercise
Book, Power point, Solution for Exercise
CMS
CMS

Book, Power point, Solution for Exercise

CMS

Submit lab 5

806825668.xls
 Back to Syllabus APPENDIX 2: ASSESSMENT STRUCTURES
Evaluation Type of Number of Scope of knowledge
# Weight Duration How? Note
Category questions questions and skills of questions
in lab practical related to studied Guided by
1 Labs 15% may be continued at home.
session exercises modules instructor

Instruction and shedules for Progress

tests must be presented in the Course
Implementation Plan approved by director
20
Multiple choices of the campus.
Level 1: 4
Quiz or Marked by up to 04 covered by instructor
2 10% 20' Level 2: 12
Progress test Computer or a chapters using computer Progress test must be taken right after
Level 3: 4
suitable format the last lectures of required material.

Instructor has resposibility to review the

test for students after graded.

guided by 40% Design,

Design; Simple RDBS design and
instructor, prepare 20% Implementation,
3 Assignment 20% at home Implementation; implementation using a
at home present in 40% Presentation
Presentation DBMS
class of the whole Project
Preferable to be
marked by by exam board
Practical Practical Exam database is up load in
4 25% 85' Scripts DB programing skills and department
Exam CMS in advanced.

Knowledge and skills in

the course, but with
60 much focus on the items
Multiple choices
Level 1: 6 in Chapters 2 to 6, by exam board
5 Final exam 30% 60' Marked by
Level 2: 48 >= 70% new questions
Computer
Level 3: 6 (for the current
semester);

806825668.xls