Course Information
Course title
Database Systems 
Semester
104-1 
Designated for
COLLEGE OF ELECTRICAL ENGINEERING AND COMPUTER SCIENCE  DEPARTMENT OF COMPUTER SCIENCE & INFOR  
Instructor
SHU HONG-MING 
Curriculum Number
CSIE4240 
Curriculum Identity Number
902 47000 
Class
 
Credits
Full/Half
Yr.
Half 
Required/
Elective
Elective 
Time
Wednesday 2,3,4(9:10~12:10) 
Remarks
The upper limit of the number of students: 50. 
 
Course introduction video
 
Table of Core Capabilities and Curriculum Planning
Table of Core Capabilities and Curriculum Planning
Course Syllabus
Please respect the intellectual property rights of others and do not copy any of the course information without permission
Course Description

Course Description:

This is the first course in database management systems. You will learn (1)
how to design and create relational databases, (2) how to use SQL on
relational databases, and (3) how to build a relational database. You will
also learn some advance topics, such as transaction management, query
optimization, etc. This course emphasizes on students`s hands-on learning.
This means that there will be some programming assignments which students
will implement several components of a relational database system.

This course is taught in English.

Prerequisite:

- Data structure and algorithms
- Proficiency in C++ programming

Required Textbook:

- `Database Management Systems, Third Edition` by Ramakrishnan and Gehrke.


Database Systems
- course description
This is an introductory course on database systems. This course will cover
the following topics: the entity-relationship model, the relational data
models, SQL languages, relational algebra and calculus, query evaluation and
optimization, storage and indexing, security and authorization, transaction
management, concurrency control, fault tolerance, and crash recovery. Since
this is a computer science course, this course will place more emphasis on
how to build modern database systems, rather than how to use commercial
database systems. Students are encouraged to take a complementary
project-course `practicum in database systems` that teaches how to build a
simple database system. The difference between these two courses is that
this course will teach you `concepts` of database systems, whereas the
practicum course will teach you how to actually program a real database
system. This course will be taught in English.
- course prerequisite:
Data structure and algorithms.
C++ programming
- required textbook
Database Management Systems, Third Edition” by Ramakrishnan and Gehrke.
 

Course Objective
 
Course Requirement
 
Student Workload (expected study time outside of class per week)
 
Office Hours
 
Designated reading
 
References
 
Grading
   
Progress
Week
Date
Topic
No data