Course title
M02240002
Database Systems

 LAOHAKANGVALVIT TIPPORN
Course description
This course provides principles, design, implementation, and management of databases, which are fundamental to modern information systems. Students will gain proficiency in Structured Query Language (SQL) for data manipulation and retrieval within relational databases. Through lectures, hands-on exercises, and projects, students will develop practical skills in database design, implementation, and management. This course prepares students for careers in software development, data analysis, and information management.
Purpose of class
Students are expected to obtain knowledge, understanding, and technical skills to design and develop a program to manage and operate database. Also, students are aim to understand the role of database systems in real-world applications.
Goals and objectives

 Goals and objectives Course Outcomes
1. Students can explain fundamental knowledge about database design and implementation techniques.
A-1
2. Students can effectively use SQL for database implementation, manipulation and retrieval.
A-1
3. Students can apply theoretical concepts to design and implement a database system for real-world applications.
A-2
,
B
Relationship between 'Goals and Objectives' and 'Course Outcomes'

 Assignments Mid-term Examination Final Project Total.
1. 10% 10% 5% 25%
2. 10% 10% 15% 35%
3. 10% 10% 20% 40%
Total. 30% 30% 40% -
Class schedule

 Class schedule HW assignments (Including preparation and review of the class.) Amount of Time Required
1. Introduction to database systems Review after class and do assignment 190分
2. Database concepts and architectures Review after class and do assignment 190分
3. Database design and modeling Review after class and do assignment 190分
4. Entity-Relationship (ER) diagram Review after class and do assignment 190分
5. Database storage, indexing, and normalization Review after class and do assignment 190分
6. SQL language (1) Review after class and do assignment 190分
7. Mid-term examination & Discussion on solutions Review all previous classes and prepare for examination 220分
8. SQL language (2) Review after class and do assignment 190分
9. Query processing and optimization Review after class and do assignment 190分
10. Tools for implementing database management systems (DBMS) Review after class and do assignment 190分
11. Project-based Learning: Requirement gathering and design of DBMS Work on project 190分
12. Project-based Learning: Implementation of DBMS & Progress report on design Work on project 190分
13. Project-based Learning: Implementation of DBMS & Progress report on implementation Work on project 190分
14. Course review & Final project presentation and discussion Preparation for presentation and discussion 220分
Total. - - 2720分
Goals and objectives (Other Courses)
A:Fundamental Mechanical Engineering B:Advanced Mechanical Engineering C:Environment and Materials Engineering D:Chemistry and Biotechnology E:Electrical Engineering and Robotics G:Advanced Electronic Engineering F:Information and Communications Engineering L:Computer Science and Engineering H:Urban Infrastructure and Environment
Language
English
Evaluation method and criteria
"Assignments will contribute 30% of the grade.
Mid-term examination and final project will contribute 70% of the grade.
*Those who get at least 60% of the total score will receive the credits of this course.
Feedback on exams, assignments, etc.
ways of feedback specific contents about "Other"
Feedback in outside of the class (ScombZ, mail, etc.)
Textbooks and reference materials
Fundamentals of Database Systems (7th Edition). Ramez Elmasri and Shamkant B. Navathe. Pearson (2015).
Prerequisites
Knowledge and experience to develop a basic web application is required, as the final project will involve developing web-based database management systems.
(*Review on the basic web programming will not be provided.)
Office hours and How to contact professors for questions
  • Office hours: After class or by appointment
    For appointment, please contact me by e-mail: tipporn@shibaura-it.ac.jp
Regionally-oriented
Non-regionally-oriented course
Development of social and professional independence
  • Course that cultivates an ability for utilizing knowledge
  • Course that cultivates a basic problem-solving skills
  • Course that cultivates a basic interpersonal skills
Active-learning course
Most classes are interactive
Course by professor with work experience
Work experience Work experience and relevance to the course content if applicable
N/A N/A
Education related SDGs:the Sustainable Development Goals
  • 4.QUALITY EDUCATION
Last modified : Wed Mar 12 04:10:53 JST 2025