Course Syllabus

Course Information：

Year-Semester	Course Number	Course Name	Phase	Credits	Hours	Required/Elective	Instructor	Class	Student NO.	Withdraw	Note
Spring Semester Year 2023	312303	Database Systems	1	3.0	3	▲	Liu Chien-Hung	IEECSU3	20	0

Course Plan：

Instructor	Liu Chien-Hung　Office Hours
Email	cliu@ntut.edu.tw
Last Updated	2022-12-20 10:10:58
Course Objective	This course is designed to introduce concepts and skills essential in the database systems. Relational database will be the main focus with related topics such as relational model, design concepts, and structured query language. The topics to be covered include: introduction to database systems, record storage and file organizations, indexed structures for files, the relational model, relational algebra and calculus, SQL, conceptual and logical design for relational database, functional dependencies, normalization and database management system technology.
Course Schedule	Week Topics ---- ----------------------------- 1 Databases and Database User 2 Database System Concepts & Architecture 3 Entity-Relationship Data Modeling 4 Enhanced Entity-Relationship & UML Modeling 5 Relational Data Model & Constraints 6 Relational Algebra and Calculus 7 Relational Database Design 8 SQL 9 Midterm Exam 10 More SQL 11 Functional Dependencies and Normalization 12 Relational Database Design Algorithms 13 Practical Database Design Methodology 14 Disk Storage and Basic File Structures 15 Indexing Structures for Files 16 Transaction Processing Concepts and Theory 17 Project Presentation 18 Final Exam
Evaluation and grading policy	1. Homework and Attendance (15%)                        2. Exams  a. Midterm (30%)            b. Final (30%)                 3. Team Project (25%)
Materials	All right reserved. Do not reproduce without permission. Foreign-language textbooks:Yes Textbook: Ramez Elmasri and Shamkant B. Navathe, Fundamentals of Database Systems, 7th Edition, Pearson, 2017. Reference Books: Abraham Silberschatz, Henry F. Kotth, and S. Sudarshan, Database System Concepts, 7th Edition, McGraw Hill, 2019. Thomas Connolly and Carolyn Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, 6th Edition, Pearson Education Limited, 2015.
The access to curricular consultation	The instructor is available for tutoring or consultations by students during the following scheduled office hours in the Technology Research Building, Room 1523. Tuesday: 9:00am-12:00pm Thuresday: 9:00am-12:00pm
Expanding teaching and resources
The course corresponds to the SDGs
Does the course incorporate AI
Note	The course will be offered online using MS Teams during the period of Level 3 COVID-19 Alert. The Teams link created by school will be used. Check https://myweb.ntut.edu.tw/~cliu/courses/db/db.htm or email instructor for details.